Handling SQL SELECT result

See also:
Running a SQL statement in a Microsoft SQL server database
Running a SQL statement in a MySQL server database
Running a SQL statement in a ODBC-compatible database

If you use an SQL SELECT sentence in any of the database actions available (MySQL, SQL Server or ODBC) Email Parser will automatically add to the available fields the retrieved data. For example:

If you use the following SQL sentence:

SELECT part_id, name, quantity FROM parts;

The resulting fields are made available to the next actions:

With these set of fields you can then use Run a set of actions multiple times to launch actions for each fetched row.