The Mysql JDBC driver does not allow multiple SQL statements in a single statement by default. However, a configuration parameter allows you to change its default behavior as explained below:
- Double-click tMysqlRow to open its Basic Settings view in the Component tab.
In the Advanced settings tab, add the parameter
"allowMultiQueries=true" to the Additional
JDBC Parameter field.
- Execute multiple statements as follows in the component view: