You can change the contents of multiple rows in one operation by using an Update query. For example, in a titles
table you can use an Update query to add 10% to the price of all books for a particular publisher.
When you create an Update query, you specify:
For example, the following query updates the titles
table by adding 10% to the price of all titles for one publisher:
UPDATE titles
SET price = price * 1.1
WHERE (pub_id = '0766')
For general information about using queries to update tables, see Modifying Data Using Queries.
Caution You cannot undo the action of executing an Update query. As a precaution, back up your data before executing the query.
To create an Update query
Note If more than one table is displayed in the Diagram pane when you start the Update query, the Query Designer displays the Update Table dialog box to prompt you for the name of the table to update.
Caution The Query Designer cannot check that a value fits within the length of the column you are updating. If you provide a value that is too long, it might be truncated without warning. For example, if a name
column is 20 characters long but you specify an update value of 25 characters, the last 5 characters might be truncated.
If you do not specify a search condition, all rows in the specified table will be updated.
Note When you add a column to the Grid pane for use in a search condition, the Query Designer also adds it to the list of columns to be updated. If you want to use a column for a search condition but not update it, clear the check box next to the column name in the input source window ( ).
When you execute an Update query, no results are reported in the Results pane. Instead, a message appears indicating how many rows were changed.