Load data from a list into the Table
Using the multiple insert pattern, in this exercise, you will load the data from values_list
into the table.
Cet exercice fait partie du cours
Introduction to Databases in Python
Instructions
- Import
insert
fromsqlalchemy
. - Build an insert statement for the
census
table. - Execute the statement
stmt
along withvalues_list
. You will need to pass them both as arguments toconnection.execute()
. - Print the
rowcount
attribute ofresults
.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
# Import insert
# Build insert statement: stmt
# Use values_list to insert data: results
# Print rowcount
print(____)