   |
   |
|
UPDATE
|
|
|
|
Syntax
UPDATE table_sources SET column_path = expression [, ...] [WHERE search_expression]
Description
Updates the fields of a table or several tables according to the SET expressions given. The table_sources behave the same as with the SELECTcommand and can contain more than one joined table. Unlike some other SQL based databases, any columns of any tables in the table sources can be updated in the SET list.
The WHERE search_expression follows the same syntax as with the SELECT command. It is used to narrow the selection of rows that are updated.
Related