/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 vote318 views1 answer
How to find median of a column sql
SQL
0 vote333 views1 answer
Sql period overlap
SQL
0 vote374 views1 answer
Array aggre distinct postgres
SQL
1 vote351 views1 answer
Isnull sql server
SQL
8 votes340 views1 answer
Oracle add auto_increment column to existing table
SQL
5 votes316 views1 answer
Oracle columns in all_tables
SQL
1 vote311 views1 answer
Oracle list constraints
SQL
0 vote409 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote315 views1 answer
Error code 1055
SQL
1 vote301 views1 answer
Find logged in users mysql
SQL