Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
UPDATE statementUse the UPDATE statement to change the values in one or more columns of one or more existing rows in a table or view.
SET ClauseUse the SET clause to identify the columns to be updated and assign values to each column.

SET Clause

Use the SET clause to identify the columns to be updated and assign values to each column.

The SET clause supports the following syntax formats:

A single-column format, which pairs each column with a single expression
A multiple-column format, which associates a list of multiple columns with the values returned by one or more expressions

SET Clause

Notes:

¹ See Single-Column Format
² HCL OneDB™ extension
³ See Multiple-Column Format

The following UPDATE statement uses the single-column format of the SET clause to change the value of the customer.city column of any existing row whose value in the customer.customer_num column is 103.

UPDATE customer
   SET city = 'Alviso'
      WHERE customer_num = 103;

If no row has 103 as its customer_num column value, this example has no effect on the customer table.