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: