Contenido del Curso
Databases in Python
Databases in Python
1. Introduction to SQLite
3. More About SQLite
Challenge: First Table
Tarea
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
articles
with the following fields:id
— typeINTEGER
.title
— typeTEXT
.content
— typeTEXT
.author
— typeTEXT
.
- Save the changes and close the database connection.
Once you've completed this task, click the button below the code to check your solution.
Solución
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 1. Capítulo 5
Challenge: First Table
Tarea
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
articles
with the following fields:id
— typeINTEGER
.title
— typeTEXT
.content
— typeTEXT
.author
— typeTEXT
.
- Save the changes and close the database connection.
Once you've completed this task, click the button below the code to check your solution.
Solución
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 1. Capítulo 5