Challenge: First Table
Завдання
Swipe to start coding
Your task is to complete the code that creates an SQLite database and a table called articles. Here’s what you need to do:
- Connect to the database
my_database.db. - Create a cursor to execute SQL commands.
- Use the cursor to create a table named
articleswith the following fields:id— typeINTEGER.title— typeTEXT.content— typeTEXT.author— typeTEXT.
- Save the changes and close the database connection.
Рішення
import sqlite3
conn = sqlite3.connect("my_database.db") # create a new database
cursor = conn.cursor() # create a cursor
# Create a table named `articles` with the specified fields
cursor.execute('''
CREATE TABLE IF NOT EXISTS articles (
id INTEGER,
title TEXT,
content TEXT,
author TEXT
)
''')
conn.commit() # save the changes
conn.close() # close the database connection
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 1. Розділ 5
import sqlite3
conn = sqlite3.connect("my_database.db") # create a new database
cursor = ___.___() # create a cursor
# Create a table named `articles` with the specified fields
___.___('''
CREATE TABLE IF NOT EXISTS articles (
id INTEGER,
title TEXT,
content TEXT,
author TEXT
)
''')
conn.___() # save the changes
conn.___() # close the database connection
