The UPDATE Clause

This is used to change field values in existing records. The syntax is:

UPDATE tableName SET field=value list

field=value list is a comma separated list in the format of field name = field value