/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 vote200 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote222 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote252 views1 answer
Sqlite trim
SQL
0 vote217 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
10 votes200 views4 answers
SELECT FROM WHERE
SQL
2 votes299 views2 answers
Mysql compare datetime to another datetime
SQL
1 vote186 views1 answer
How to use a trigger to validate input data
SQL
0 vote230 views1 answer
Get null value in sql
SQL
0 vote197 views1 answer
Mysql workbench indent formatting
SQL
0 vote187 views2 answers
Android sqlite tutorial for beginners
SQL