Firebird 2.0
PSQL Reference
Manual

UPDATE STATEMENT

Pupose

Use the UPDATE statement to update new rows into a table. The PSQL update statement is identical to the SQL update statement followed by a semicolon.

Syntax

<psql_update_stmt> ::=
<update_stmt> ;


Element
Description
update_stmt

A SQL update statement as defined in the SQL Reference manual.

Semantics

See the SQL Reference Manual for a description of the update statement.

Examples

The below is an example of a valid UPDATE statement in PSQL:

   UPDATE table1 SET salary = :new_sal WHERE id = :emp_id;


See also

DELETE, INSERT and SELECT


previous page goto index next page

Legal information