/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

2 votes357 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote358 views1 answer
Sql find leading space
SQL
4 votes344 views1 answer
Sql delete where in select
SQL
3 votes357 views2 answers
Mysql user permission database
SQL
16 votes379 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote333 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote365 views1 answer
C# get sql min date
SQL
12 votes364 views6 answers
Select distinct
SQL
0 vote351 views1 answer
How to input data as id in database sql c#
SQL
2 votes360 views3 answers
How to get second highest salary in each department in sql
SQL