Creation operations in SQLite involve adding new records to a database table. These operations allow you to populate your tables with data. Let's explore how insertion operations work within the context of database creation.

Inserting a Record

This code snippet uses the SQL INSERT INTO statement to add a new record to the "users" table, inserting values for the "username" and "email" fields. The data is passed as a tuple, and the query is executed with the execute() method to insert the values.

import sqlite3

# Connect to the database
conn = sqlite3.conn('my_database.db')
cursor = conn.cursor()

# SQL query to insert a record into the `users` table
insert_query = "INSERT INTO users (username, email) VALUES (?, ?)"
user_data = ('john_doe', 'john.doe@email.com')

# Execute the SQL query with data
cursor.execute(insert_query, user_data)

conn.commit()  # save the changes
conn.close()  # close the connection

Be careful because this code considers working on an already existing table. If you don't have a users table in your database, then you need to create one.

To avoid the error, you need to create a table in the database with the name users and fields username and email. Only after that can you add records to this table.