sqliteHow do I insert data into a SQLite database?

To insert data into a SQLite database, follow the steps below:

1. Connect to the SQLite database using the sqlite3 Python module.

import sqlite3

connection = sqlite3.connect("mydatabase.db")
cursor = connection.cursor()

2. Create a SQL statement to insert the data into the table.

sql_statement = "INSERT INTO users (name, email) VALUES (?, ?)"

3. Execute the statement with the data to be inserted.

cursor.execute(sql_statement, ("John Doe", "[email protected]"))

4. Commit the changes to the database.

connection.commit()

5. Close the connection to the database.

connection.close()

For more information, see the SQLite Documentation and the Python SQLite3 Tutorial.

Edit this code on GitHub