Quadcap Software

Quadcap Embeddable Database

Quadcap Software

UPDATE statement

This statement is used to modify the values in one or more rows of an existing table or updatable view.

Syntax

updateStmt
  :  "update" sqlId "set" 
    (  updateItem ( COMMA updateItem )* 
    |  
    ) 
    whereExpression 
  ;

Examples

UPDATE TEMP_SS SET GRADE=GRADE + 1 WHERE GRADE > 10;