Action disabled: source

DRAFT

Omnidex SQL UPDATE

Description

Update existing data in a database.

Syntax

UPDATE table_spec SET column-assignments 
    [WHERE < predicate-list | CURRENT > 
    [ < ON / OF > [ CURSOR ] cursor ] ] 
    [WITH options]

Discussion

table_spec

Required. The name of the table containing the data to be updated.

column-assignments

Required. A comma separated list of column name/new value pairs. (column-name = new-value, …)

WHERE predicate-list | CURRENT

Optional. Provide a predicate-list to qualify specific rows to be updated or update only the CURRENT row. Caution! If omitted, ALL rows will be updated with the new values. predicate-list - Criteria to determine which rows will be updated. CURRENT - Update only the current row.

[ON [CURSOR] cursor]

Optional. The cursor on which to perform the delete. If omitted, the delete will be performed on the current cursor.

[WITH options] Optional - Specify options to be used for this command.

Examples

UPDATE INVENTORY SET PRICE=10.95 WHERE PRICE=9.95
 
Back to top
dev/sql/statements/update/home.txt · Last modified: 2016/06/28 22:38 (external edit)