Updating individual records
The update statement is very similar to an insert statement. For example, you can update all wages in the employees table as follows:
stmt = update(employees).values(wage=100.00)
The update statement also typically uses a where clause to help us determine what data to update. For example, to only update the record for the employee with ID 15, you would append the previous statement as follows:
stmt = stmt.where(employees.id == 15)
You'll be using the FIPS state code here, which is appropriated by the U.S. government to identify U.S. states and certain other associated areas.
For your convenience, the names of the tables and columns of interest in this exercise are: state_fact (Table), name (Column), and fips_state (Column).
Este exercício faz parte do curso
Introduction to Databases in Python
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
# Build a select statement: select_stmt
select_stmt = select([____]).where(____ == ____)
# Execute select_stmt and fetch the results
results = connection.____(____).____()
# Print the results of executing the select_stmt
print(____)
# Print the FIPS code for the first row of the result
print(results[0]['___'])