Executing multiple SQL statements with one tMysqlRow component | Talend Components for Jobs Help
Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Executing multiple SQL statements with one tMysqlRow component

Last updated: 8/27/2026

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 – please let us know!

Leave your feedback here