Automatically trigger in mysql insert or update or delete??

[Ashok200792]

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.

[TRF]

Hi,

This is not a Talend question.

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

[Ashok200792]

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

[Ashok200792]

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