/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 vote359 views1 answer
Command to give readonly access to a postgres sql user
SQL
1 vote381 views1 answer
Mariadb get column names from table
SQL
0 vote350 views1 answer
Primary key multiple colums
SQL
1 vote365 views1 answer
Backup mysql schema only
SQL
0 vote362 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote349 views1 answer
Oracle check table lock
SQL
0 vote326 views1 answer
How to close external sql connection in laravel
SQL
1 vote324 views2 answers
Sql select only first occurrence
SQL
2 votes339 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote336 views1 answer
Create new schema mysql
SQL