The UPDATE statement is used to modify existing records in a table.

Basic Syntax

UPDATE person
SET first_name = 'Jonathan'
WHERE person_id = 1;

Update the first name of person with ID 1.

Updating Multiple Columns

Multiple columns can be updated simultaneously:

UPDATE person
SET first_name = 'Jane', last_name = 'Doe'
WHERE person_id = 2;

Update multiple fields in a single statement.