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).

Diese Übung ist Teil des Kurses

Introduction to Databases in Python

Kurs anzeigen

Anleitung zur Übung

Build an update statement to update the notes column in the state_fact table to 'The Wild West'. Save it as stmt.
Use a where clause to filter for records that have 'West' in the census_region_name column of the state_fact table.
Execute stmt_west via the connection and save the output as results.
Run the solution to print rowcount of the results.

Interaktive Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

# 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)

Code bearbeiten und ausführen