Skip to main content Skip to complementary content

Executing multiple SQL statements with one tMysqlRow component

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:

Procedure

  1. Double-click tMysqlRow to open its Basic Settings view in the Component tab.
  2. In the Advanced settings tab, add the parameter "allowMultiQueries=true" to the Additional JDBC Parameter field.
  3. Execute multiple statements as follows in the component view:

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here