Assignment clause

The syntax for the assignment clause in BNF is as follows:

Syntax

assignment ::=
  column = {expr| NULL }| ( column[, column], ... ) = ( expr[, expr], ... ) 
   | ( column[, column], ... ) = ( query_expression )

For more information, see UPDATE.