Disable foreign keys constraint before executing batch

One Star

Disable foreign keys constraint before executing batch

Hello,
I would like to know how to execute a custom sql query in my Talend job on my MySQL database before importing batch data with Talend.
Basically I would like in my Talend job to:
- call a custom sql query on my database
- import my CSV file in the table
- call a custom sql query to reenable the foreign keys on my database
Is there a tComponent that is best for this ?
Thanks
Gilles
Employee

Re: Disable foreign keys constraint before executing batch

Hello,
You can use tMySQLRow
Regards,