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.
Updating the Same Column Twice

Updating the Same Column Twice

You can specify the same column more than once in the SET clause. If you do so, the column is set to the last value that you specified for the column. In the next example, the fname column appears twice in the SET clause. For the row where the customer number is 101, the user sets fname first to gary and then to harry. After the UPDATE statement executes, the value of fname is harry.

UPDATE customer
   SET fname = "gary", fname = "harry"
      WHERE customer_num = 101;