Update all rows in a table
Update all rows meeting a condition
Updating multiple columns in table
You can update multiple columns in a table in the same statement, separating col=val pairs with commas:
Updating a table based on joining another table
You can also update data in a table based on data from another table:
Here we are joining the person city column to the cities city column in order to get the city's state code. This is then used to update the state_code column in the person table.