The update statement is used to update records in a database. The keywords used in an update statement are summarised in the following table.
|UPDATE||Updates data in one or more tables.|
|SET||Specifies the field names to be updates. If the fields belong to more that one table, the table name should be specified before the field name. (eg. search.Page).|
|WHERE||Criteria to restrict the records updated.|
The following example updates all records in the search table to change the category from Jive, to Java.
SET Category = 'Java'
WHERE Category = 'Jive';
The file may then be used with MySQL as follows:
mysql> \. update.sql
The same characters need escaping as mentioned on the previous page.