In the UPDATE statement, you specify the database table and columns to update, and provide the new data. You can specify the new data with values or with the results from running a query.
The UPDATE statement can be conditional. Using one or more conditions in a WHERE clause for the UPDATE statement, you can specify which rows in the database table to update. If the UPDATE statement does not have a WHERE clause, all rows of the target table are updated.
Prerequisite: Before you specify an UPDATE statement, create the statement in the SQL builder.
To specify an UPDATE statement in the SQL builder: