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.


python
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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.

Oppgave

Swipe to start coding

Write an SQL query to insert a new record into the articles table. The query should insert values into the title, content, and author columns. Store the query in the variable insert_query.
Use the cursor method to execute the SQL query with the data stored in the article_data variable.

Løsning

import sqlite3

# Connecting to the database

conn = sqlite3.connect("my_database.db")

cursor = conn.cursor()

# Creating the `articles` table if it doesn't already exist

cursor.execute("CREATE TABLE IF NOT EXISTS articles (id INTEGER PRIMARY KEY, title TEXT, content TEXT, author TEXT)")

# SQL query to insert a record into the `articles` table

insert_query = "INSERT INTO articles (title, content, author) VALUES (?, ?, ?)"

article_data = ("Python Coding", "Python is a high-level, general-purpose programming language.","John Doe")

# Execute the SQL query with data

cursor.execute(insert_query, article_data)

conn.commit() # save the changes

conn.close() # close the connection

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 2. Kapittel 2

import sqlite3

# Connecting to the database

conn = sqlite3.connect("my_database.db")

cursor = conn.cursor()

# Creating the `articles` table if it doesn't already exist

cursor.execute("CREATE TABLE IF NOT EXISTS articles (id INTEGER PRIMARY KEY, title TEXT, content TEXT, author TEXT)")

# SQL query to insert a record into the `articles` table

insert_query = "___"

article_data = ("Python Coding", "Python is a high-level, general-purpose programming language.", "John Doe")

# Execute the SQL query with data

___.___(insert_query, article_data)

conn.commit() # save the changes

conn.close() # close the connection

Spør AI

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår