Modifying data in the database (UPDATE)

Modifying data in the database (UPDATE)
The UPDATE statement allows the contents of existing rows in a named table to be
changed. The format of the command is:
UPDATE TableName
SET columnName1 = dataValue1 [, columnName2 = dataValue2 . . . ]
[WHERE searchCondition]
TableName can be the name of a base table or an updatable view (see Section 6.4). The
SET clause specifies the names of one or more columns that are to be updated. The
WHERE clause is optional; if omitted, the named columns are updated for all rows in
the table. If a WHERE clause is specified, only those rows that satisfy the searchCondition
are updated. The new dataValue(s) must be compatible with the data type(s) for the
corresponding column(s).