1 of 1

ColumnStore UPDATE

The UPDATE statement changes data stored in rows.

Syntax

UPDATE  table_reference 
  SET col1={expr1|DEFAULT} [,col2={expr2|DEFAULT}] ...
  [WHERE where_condition]
  [ORDER BY ...]
  [LIMIT row_count]

Only one table can be updated from the table list in table_reference. However, multiple columns can be updated.