UPDATE

SQL Guide : solidDB® SQL statements : UPDATE

UPDATE

UPDATE table_name
  SET [table_name.]column_identifier = {expression | NULL}
  [, [table_name.]column_identifier = {expression | NULL}]...
  [WHERE search_condition]

UPDATE table_name
  SET [table_name.]column_identifier = {expression | NULL}
  [, [table_name.]column_identifier = {expression | NULL}]...
  WHERE CURRENT OF cursor_name

Usage

There are two types of UPDATE statements:

▪The searched UPDATE statement, UDPATE table_name ... [WHERE search_condition], modifies the values of one or more columns in one or more rows specified with search_condition.

▪The positioned UPDATE statement, UPDATE table_name ... WHERE CURRENT OF cursor_name, updates the current row of the cursor. The name of the cursor is defined using ODBC API function named SQLSetCursorName.

table_name can be a table name or an alias.

Example of searched UPDATE

UPDATE TEST SET C = 0.44 WHERE ID = 5

Example of positioned UPDATE

UPDATE TEST SET C = 0.33 WHERE CURRENT OF MYCURSOR