Specifying UPDATE statements in the SQL builder

Use an UPDATE statement to update data in a table.

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:

  1. Add the table that you want to update data in.
  2. Create a SET clause that specifies the columns to update and the new values for the columns.
  3. Optional: Add a WHERE clause.
  4. Optional: Run the SQL statement. A message in the Data Output view indicates whether the statement ran successfully.
Related reference
SQL builder for UPDATE statements

Feedback