update [#]<table_name>
   set <column_assignment>
 where <where_clause>;