The UPDATE statement

The UPDATE-SET-WHERE statement

UPDATE table_name
SET column_name = value_1 
WHERE condition; -- omitting the where clause leads to the updating of all records