Skip to main content Skip to complementary content
  • New archived content: Talend MDM, Talend Data Catalog 8.0, and Talend 7.3 products reached their end of life in 2024. Their documentation was moved to the Talend Archive page and will no longer receive content updates.

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

Leave your feedback here