topic Re: Automatically trigger in mysql insert or update or delete?? in Talend Studio

Automatically trigger in mysql insert or update or delete??

Ashok200792 — Mon, 19 Mar 2018 12:28:10 GMT

Automatically trigger in mysql insert or update or delete??

When insert or update or delete how to write the trigger automatically in the mysql ??

Can you please guide me the further process.

Re: Automatically trigger in mysql insert or update or delete??

TRF — Mon, 19 Mar 2018 13:03:32 GMT

Hi,

This is not a Talend question.

Refer yourself to the documentation https://dev.mysql.com/doc/refman/5.5/en/trigger-syntax.html

Re: Automatically trigger in mysql insert or update or delete??

Ashok200792 — Mon, 19 Mar 2018 13:18:08 GMT

Thanks for you kindly reply my friend, but we need to integrated in talend ,

Before you guide me how to insert the records from the file read and data store into the table @TRF

Now we want trigger in talend tool and read the data and generated the reports in based on the mysql tables data and send mail continually based on the record ,

how to send mail continuously daily or weekly or monthly ?? Its send to routine cycle days or weeks or month's automatically. Its possible , Can you guide me same as for further process

With Regards,

Ashok M

Re: Automatically trigger in mysql insert or update or delete??

Ashok200792 — Fri, 23 Mar 2018 13:47:48 GMT

We can use one table depends changes means we can use trigger , but we need to listen more than one tables in MySql .