Updating and Deleting Data

UPDATE customer
SET email = 'first.coustomer@mail.ru'
WHERE customer_id = 1


The basic format of an UPDATE statement is made up of three parts:

✓ The table to be updated;

✓ The column names and their new values;

✓ The filter condition that determines which rows should be updated.