The Mysql JDBC driver does not allow multiple SQL statements in a single statement by default. 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 demonstrate how to execute multiple SQL statements on a tMysqlRow component.
The detailed job settings and explanation are as follows: