Automatically trigger in mysql insert or update or delete??

Six Stars

Automatically trigger in mysql insert or update or delete??

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.

 

 

Forteen Stars TRF
Forteen Stars

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

Hi,

This is not a Talend question.

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


TRF
Six Stars

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

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

Six Stars

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

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