An Update statement changes the value of columns in the selected rows of a table. The following syntax is supported for UPDATE statements:

UPDATE <table_name> SET <column_name> = <expression> [, ...] [WHERE <conditions>]

where:

table_name

is the name of the table for which you want to update values.

column_name

is the name of a column, the value of which is to be changed. Multiple column values can be changed in a single statement.

expression

is the new value for the column. The expression can be a constant value or a subquery that returns a single value. Subqueries must be enclosed in parentheses.