Version: 4

Update multiple rows

The Update multiple rows action allows you to modify the values of one or more rows within a table simultaneouly.

Action Conditions

Action condition	Description
Table	Select the table where you want to modify the values for one or more rows.
Select fields to update	Select or enter the fields whose values you want to modify.
WHERE Condition	Enter the conditions using the WHERE clause to specify unique identifiers in the table that uniquely identify the rows you wish to modify. Following is an example of a WHERE clause condition: WHERE CUSTOMER_ID = 12345

Action condition

Description

Table

Select the table where you want to modify the values for one or more rows.

Select fields to update

Select or enter the fields whose values you want to modify.

WHERE Condition

Enter the conditions using the WHERE clause to specify unique identifiers in the table that uniquely identify the rows you wish to modify.

Following is an example of a WHERE clause condition:

WHERE CUSTOMER_ID = 12345