/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

7 votes124 views2 answers
Show size database mysql
SQL
1 vote127 views1 answer
Hackerrank sql test solutions
SQL
0 vote148 views1 answer
Load data infile mariadb slow
SQL
4 votes158 views1 answer
Postgresql change default value
SQL
0 vote128 views1 answer
Sql sort ages
SQL
1 vote126 views1 answer
Oracle rolling back transactions
SQL
0 vote151 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote146 views1 answer
Sql server phone constraint
SQL
0 vote141 views2 answers
Postgresql variable in query
SQL
1 vote117 views1 answer
Jooq convert using gbk
SQL