Reference Guide › Command Reference › SQL Statements › UPDATE

UPDATE

►►─┬─ searched UPDATE ───┬────────────────────────────────────────────────────►◄
   └─ positioned UPDATE ─┘

Searched UPDATE

►►─ UPDATE ─┬─ table-name ─┬─┬────────────────────┬─ SET ─────────────────────►
            └─ view-name ──┘ └─ correlation-name ─┘

   ┌─ , ────────────────────────────┐
 ►─▼─ column-name ─┬─ expression ─┬─┴─┬────────────────────────────┬──────────►◄
                   └─ NULL ───────┘   └─ WHERE ─ search-condition ─┘

Note: The Assignment Statement, CASE, CREATE RULE, IF-THEN, ITERATE, LEAVE, REPEAT-UNTIL, and WHILE statements are executed within the Compound Statement. See the CALL/EXECUTE PROCEDURE for the EXECUTE PROCEDURE syntax. See the CREATE TRIGGER/RULE for the CREATE RULE syntax.