/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

2 votes127 views1 answer
Oracle run_duration average
SQL
7 votes137 views1 answer
Mysql unsafe update
SQL
0 vote151 views3 answers
Insert query in ci
SQL
-1 vote167 views4 answers
Sql view postgresql
SQL
1 vote126 views1 answer
Select statement to print longest name
SQL
1 vote136 views2 answers
Snowflake alter column data type
SQL
0 vote139 views1 answer
How to tell if i have lactose intolerance
SQL
2 votes80 views1 answer
Sql select in list
SQL
0 vote159 views2 answers
Getting customers with no orders sql
SQL
4 votes153 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL