Help Centre › Building Processes
Run one parameterised statement once per row of parameters.
Add it to a process
In the process designer, open the Add step tab. Find Execute many under Database › Query & Execute, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| SQL statement | Yes | The SQL statement to execute once per row, with placeholders |
| Rows | Yes | List of parameter sets, one per execution |
| Variable | No | Name of the variable where the result will be stored Default: affected_rows. |
| Fail when no rows change | No | Stop with an error when the statement changes no rows, instead of only noting it in the log Default: off. |
What it gives back
{affected_rows}– Total number of rows affected
See all Database steps.