how to insert string variable into sqlite database

Solutions on MaxInterview for how to insert string variable into sqlite database by the best coders in the world

Search
showing results for - "how to insert string variable into sqlite database"
Danny
24 Aug 2020
1def create_db():
2    with con:
3        cur = con.cursor()
4        cur.execute("DROP TABLE IF EXISTS Contacts")
5        cur.execute("CREATE TABLE Contacts (First Name TEXT, Last Name TEXT, Phone TEXT, Email TEXT);")
6        cur.execute("INSERT INTO Contacts VALUES (?, ?, ?, ?);", (firstname, lastname, phone, email))
7
8        ## call commit on the connection...
9        con.commit()
source
similar questions
how to insert text into database python sqlitesqlite create indexadd colum sqlite tablesqlite insert rowcreate table sqlitequery params sql insert python f stringcreate table sqlite android studioconvert varchar to int in sqlitesqlite alter table add columninsert records into sqlite table pythonhow to declare variables in vb net and store variable data in sql serverinsert sqlitehow to create a database in sqlitecreate table sqliteinsert bulk values into table in sqlitehow to save result of sqlite query in a tableconcat sqlite
queries leading to this page
python sqlite3 insert variablehow to how to give variable data to sqlite statement in pythonpython database insert variablehow to how to give variable data to sqlite statement in python in wherehow to insert string variable into sqlite databaseadding variables to sqllite3 serverhow to insert string variable into sqlite database