Creation Operations
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.
Swipe to start coding
-
Write an SQL query to insert a new record into the
articles
table. The query should insert values into thetitle
,content
, andauthor
columns. Store the query in the variableinsert_query
. -
Use the cursor method to execute the SQL query with the data stored in the
article_data
variable.
Løsning
Tak for dine kommentarer!