UPDATE
Modifies existing rows in a table.
UPDATE film SET rental_rate = rental_rate * 1.1 WHERE length > 120
When to use
A DML command. Without a WHERE it changes every row. In PP 01 and PP 04 the point is that constraints reject an INSERT or UPDATE that would break them.
See Read 01.