/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 vote166 views1 answer
Apex select list ORA-20999
SQL
0 vote151 views1 answer
Postgres list tables and row counts
SQL
13 votes187 views6 answers
Mysql remove duplicates
SQL
0 vote148 views1 answer
Max mysql
SQL
0 vote190 views2 answers
Insert data into multiple tables mysql
SQL
1 vote154 views1 answer
Declare variables sql
SQL
2 votes157 views2 answers
Mysql alter column default
SQL
1 vote141 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote192 views1 answer
Creating sqeuence in oracle database
SQL
0 vote151 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL