insert sqlite

1INSERT INTO table (column1,column2 ,..) VALUES( value1,	value2 ,...);

1import sqlite3
2
3def insertVaribleIntoTable(id, name, email, joinDate, salary):
4    try:
5        sqliteConnection = sqlite3.connect('SQLite_Python.db')
6        cursor = sqliteConnection.cursor()
7        print("Connected to SQLite")
8
9        sqlite_insert_with_param = """INSERT INTO SqliteDb_developers
10                          (id, name, email, joining_date, salary) 
11                          VALUES (?, ?, ?, ?, ?);"""
12
13        data_tuple = (id, name, email, joinDate, salary)
14        cursor.execute(sqlite_insert_with_param, data_tuple)
15        sqliteConnection.commit()
16        print("Python Variables inserted successfully into SqliteDb_developers table")
17
18        cursor.close()
19
20    except sqlite3.Error as error:
21        print("Failed to insert Python variable into sqlite table", error)
22    finally:
23        if (sqliteConnection):
24            sqliteConnection.close()
25            print("The SQLite connection is closed")
26
27insertVaribleIntoTable(2, 'Joe', 'joe@pynative.com', '2019-05-19', 9000)
28insertVaribleIntoTable(3, 'Ben', 'ben@pynative.com', '2019-02-23', 9500)

1-- To insert a single row into a table, you use the following form of the INSERT statement:
2
3INSERT INTO table (column1,column2 ,..)
4VALUES( value1,	value2 ,...);Code language: SQL (Structured Query Language) (sql)

1INSERT INTO TABLE (something1,something2, something3) VALUES (?, ?, ?)