====== UPDATE Statement ======

UPDATE statement allows you to update columns of existing rows in the specified table. 

**Syntax**:

<code language="sql">
UPDATE table_name
  SET col = expr [, coln = exprn] ...
  [WHERE condition]
  
UPDATE table_name
  SET (col [, coln] ...) = (expr [, exprn] ... | select_statement)
  [WHERE condition]
</code>