Update (SQL)

Change the existing field values in a table.

Syntax
UPDATE table SET newvalue WHERE criteria;
Key
table The name of the table to modify.
newvalue An expression that determines the value to be
updated in a specific field in the table.
criteria An expression that determines which records
will be updated.

Multiple records can be updated together, or the criteria can limit the update to a single row.
Several fields can be updated at the same time.