The set clause specifies columns and changed values. The where clause determines which rows are to be updated. If you do not include the where clause, the specified columns of all the rows are updated with the values provided in the set clause.
For example, if all the publishing houses in the publishers table move their head offices to Atlanta, Georgia, update the table using:
update publishers set city = "Atlanta", state = "GA"
In the same way, you can change the names of all the publishers to NULL with:
update publishers set pub_name = null
You can use computed column values in an update. To double all the prices in the titles table, use:
update titles set price = price * 2
Since there is no where clause, the change in prices is applied to every row in the table.