/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

5 votes260 views2 answers
Mysql date greater than 30 days
SQL
0 vote156 views1 answer
Mysql:5.6 syntax create table
SQL
3 votes152 views1 answer
Mssql remove column
SQL
2 votes152 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes161 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote150 views1 answer
Oarcale list objects
SQL
1 vote183 views1 answer
Psql search table
SQL
0 vote146 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote147 views1 answer
Get number of rows in every table mysql
SQL
0 vote147 views1 answer
Output table plsql
SQL