UPDATE statements in the SQL builder

An UPDATE statement updates data in a table. In the UPDATE statement, you must specify the database table and the columns to update, and provide the new data. You can specify the new data with values or with the results from a query.

An update 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 you do not include a WHERE clause, all rows of the target table are updated. Use the Where page in the Design pane of the SQL builder to add a WHERE clause to an UPDATE statement.

The SET clause specifies which columns to update and calculates new values for them. The table to update is specified before the SET clause. Use the Set page in the Design pane of the SQL builder to add a SET clause to an UPDATE statement.

See your database vendor documentation for information about the syntax of UPDATE statements. Different database vendors use different syntax.


Feedback