solidDB Help : solidDB reference : SQL: Statements : UPDATE
  
UPDATE
UPDATE table‑name
   SET [table‑name.]column‑identifier = {expression | NULL}
   [, [table‑name.]column‑identifier = {expression | NULL} …]
   [WHERE {search‑condition | CURRENT OF cursor‑name}]
where:
expression::= see expression
Access requirements
UPDATE privileges on table
Usage
Use the UPDATE statement to update one or more rows in a specified table.
Parameters, clauses, keywords, and variables
▪ table-name: A table name or an alias.
▪ search-condition: Executes a ‘searched’ update operation that modifies the values of one or more columns in the rows that match the search condition, see search‑condition.
▪ CURRENT OF cursor‑name: Executes a ‘positioned’ update operation that modifies the values or one or more columns in just the current row of the cursor. The name of the cursor is defined by using ODBC API function named SQLSetCursorName.
Examples
Searched UPDATE
UPDATE TEST SET C = 0.44 WHERE ID = 5
Positioned UPDATE
UPDATE TEST SET C = 0.33 WHERE CURRENT OF MYCURSOR
Go up to
SQL: Statements