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.

Tarea

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.

Solución

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

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 2. Capítulo 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

Pregunte a AI

Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla