/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

4 votes267 views1 answer
SQL find text in SP
SQL
0 vote249 views1 answer
Sql query with date
SQL
3 votes286 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
8 votes255 views2 answers
Mysql query dates between two dates
SQL
4 votes231 views1 answer
Install postgres 12 on ubuntu
SQL
0 vote246 views1 answer
Remove from table where
SQL
0 vote272 views1 answer
Exectuer myssql .sql
SQL
0 vote252 views1 answer
Raiserror nowait sql server
SQL
2 votes314 views2 answers
Set value to null sql
SQL
0 vote262 views1 answer
Output table plsql
SQL