/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 vote191 views1 answer
Check command
SQL
0 vote182 views1 answer
Mariadb select limit offset
SQL
1 vote191 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote171 views1 answer
Oracle current session details
SQL
11 votes189 views3 answers
Sql_mode=only_full_group_by
SQL
1 vote172 views1 answer
Python escape mysql
SQL
4 votes178 views2 answers
Installing sql on ubuntu
SQL
0 vote177 views1 answer
18446744073709551615 mariadb left join order by
SQL
27 votes176 views5 answers
Mysql set password for user
SQL
2 votes155 views3 answers
3 days back in sql server
SQL