/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

3 votes177 views1 answer
Postgres add not null to existing column
SQL
1 vote158 views1 answer
How to run sql script
SQL
0 vote186 views2 answers
Insert data mysql with cmd
SQL
4 votes150 views3 answers
Copy table postgres
SQL
0 vote179 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
5 votes178 views4 answers
Change auto increment mysql
SQL
-1 vote165 views3 answers
Error mysql shutdown unexpectedly
SQL
3 votes170 views2 answers
Sql select data from last week
SQL
0 vote173 views1 answer
Sql max min
SQL
92 votes2.3K views6 answers
Substring
SQL