The syntax for UPDATE in BNF is as follows:

Syntax

update statement ::=
 UPDATE table_name  SET assignment[,assignment], ...
  [ WHERE search_condition] ;

For more information, see UPDATE.