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]
Comments
| 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. |