How to use MySQL trigger to send Email?

[yprashant]

Hi guys,
I have a databae in MYSQL, ver 5.1, I am supposed to fire a trigger when a row in table reaches certain value. The trigger is supposed to send an email to all the users in database. can u guys help me out in this issue.

[r035198x]

Hi guys,
I have a databae in MYSQL, ver 5.1, I am supposed to fire a trigger when a row in table reaches certain value. The trigger is supposed to send an email to all the users in database. can u guys help me out in this issue.

I don't know how you intend to send the email in a trigger but you can get the trigger syntax from the refmanual.

[Atli]

Hi. Welcome to TSDN!

MySQL is not able to send emails. So you will need some other mechanism to send them.

It would perhaps be better to have the code that inserts the row check the value once it has inserted it and check if an email has to be sent.

P.S.
I've edited the thread's title to better describe it's content.
Please check out the Posting Guidelines before posting.