The UPDATE statement is the DML one providing a way to modify already existing records.


Syntax of the UPDATE statement

UPDATE table_name SET {attr_name = attr_value}[ WHERE where_criteria]



table_name The name of a table where records for update are stored.
attr_name The name of attribute to be changed
attr_value New value of attr_name
WHERE where_criteria Determines records that will be changed. If not used, then all records will be modified. Refer to the chapter WHERE for more details.