/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

8 votes198 views5 answers
Grant permission in postgres
SQL
0 vote199 views1 answer
Mysql workbench view
SQL
0 vote191 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
1 vote207 views1 answer
Blob datatype in mysql
SQL
0 vote185 views1 answer
Sql value exists in column
SQL
49 votes227 views6 answers
Install mysql ubuntu
SQL
0 vote216 views2 answers
Dumping sql table
SQL
0 vote207 views1 answer
Mysql query to select the highest value
SQL
1 vote209 views1 answer
Update mysql centos
SQL
16 votes249 views2 answers
Sql vs nosql
SQL