/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

1 vote299 views1 answer
How to see all table partition in oracle
SQL
0 vote313 views1 answer
Liquibase update row
SQL
0 vote332 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote328 views1 answer
How to delete python anywhere mysql database
SQL
4 votes310 views1 answer
Force drop all tables postgres
SQL
0 vote308 views3 answers
Sql select statements
SQL
0 vote295 views1 answer
Difference between cross apply and inner join
SQL
0 vote305 views1 answer
Mysql select all where count more than"
SQL
6 votes362 views6 answers
Rename column postgres
SQL
0 vote394 views1 answer
Redshift running queries
SQL