Challenge: First Table

Завдання

Swipe to show code editor

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 articles with the following fields:
- id — type INTEGER.
- title — type TEXT.
- content — type TEXT.
- author — type TEXT.
Save the changes and close the database connection.

_{Once you've completed this task, click the button below the code to check your solution.}

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 1. Розділ 5

Завдання

Swipe to show code editor

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 articles with the following fields:
- id — type INTEGER.
- title — type TEXT.
- content — type TEXT.
- author — type TEXT.
Save the changes and close the database connection.

_{Once you've completed this task, click the button below the code to check your solution.}

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 1. Розділ 5

Завдання

Swipe to show code editor

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 articles with the following fields:
- id — type INTEGER.
- title — type TEXT.
- content — type TEXT.
- author — type TEXT.
Save the changes and close the database connection.

_{Once you've completed this task, click the button below the code to check your solution.}

Все було зрозуміло?

Дякуємо за ваш відгук!

Завдання

Swipe to show code editor

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 articles with the following fields:
- id — type INTEGER.
- title — type TEXT.
- content — type TEXT.
- author — type TEXT.
Save the changes and close the database connection.

_{Once you've completed this task, click the button below the code to check your solution.}

Секція 1. Розділ 5