Explains how to execute multiple SQL statements using a single tMysqlRow component.
This procedure was written with:
Talend verified this procedure to be compatible with:
By default, the MySQL JDBC driver does not allow multiple SQL statements in a single statement. Execution stops after the first semi-colon. However, a configuration parameter allows you to modify the default behavior. Update Additional JDBC Parameters to include "allowMultiQueries=true".
The following example Job demonstrates how to execute multiple SQL statements in a tMysqlRow component. The detailed job settings and explanation are as follows: