/SQL/How to insert string variable into sqlite database

How to insert string variable into sqlite database

def create_db():
    with con:
        cur = con.cursor()
        cur.execute("DROP TABLE IF EXISTS Contacts")
        cur.execute("CREATE TABLE Contacts (First Name TEXT, Last Name TEXT, Phone TEXT, Email TEXT);")
        cur.execute("INSERT INTO Contacts VALUES (?, ?, ?, ?);", (firstname, lastname, phone, email))

        ## call commit on the connection...
        con.commit()

Source: stackoverflow.com

Similar codes

0 vote110 views1 answer
Mysql reset wp_options
SQL
2 votes102 views2 answers
Postgres set user as superuser
SQL
2 votes102 views1 answer
Import database in mysql command line xampp
SQL
0 vote140 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote101 views1 answer
Find invalid datetime field
SQL
5 votes99 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote108 views1 answer
Postgresql select fast check no rows
SQL
1 vote98 views1 answer
Group_concat max length mysql
SQL
0 vote158 views1 answer
Insert query return id mysql
SQL
5 votes102 views1 answer
Oracle ora-00054 causes
SQL