Updating multiple records
As Jason discussed in the video, by using a where
clause that selects more records, you can update multiple
records at once. Unlike inserting, updating multiple records works exactly the same way as updating a single record (as long as you are updating them with the same value). It's time now to practice this!
For your convenience, the names of the tables and columns of interest in this exercise are: state_fact
(Table), notes
(Column), and census_region_name
(Column).
This exercise is part of the course
Introduction to Databases in Python
Exercise instructions
- Build an
update
statement to update thenotes
column in thestate_fact
table to'The Wild West'
. Save it asstmt
. - Use a
where
clause to filter for records that have'West'
in thecensus_region_name
column of thestate_fact
table. - Execute
stmt_west
via theconnection
and save the output asresults
. - Run the solution to print
rowcount
of theresults
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Build a statement to update the notes to 'The Wild West': stmt
stmt = update(____).values(____=____)
# Append a where clause to match the West census region records: stmt_west
stmt_west = stmt.____(____ == ____)
# Execute the statement: results
results = connection.execute(____)
# Print rowcount
print(results.rowcount)