/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

0 vote323 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote358 views1 answer
Find how many table doesn't contain column in mysql
SQL
2 votes354 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
3 votes345 views1 answer
Select database in sql
SQL
0 vote316 views1 answer
Not between mysql
SQL
0 vote558 views1 answer
The differnece between to values in sql
SQL
0 vote373 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
3 votes351 views2 answers
MySQL query to get column names
SQL
1 vote331 views2 answers
Check if word is in column sql
SQL
2 votes346 views1 answer
Update with join sql server
SQL