469,159 Members | 1,476 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

How to use MySQL trigger to send Email?

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.
Oct 24 '07 #1
2 13030
r035198x
13,262 8TB
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.
Oct 24 '07 #2
Atli
5,058 Expert 4TB
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.
Oct 24 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Neal | last post: by
reply views Thread by Dennis Francis B. Tutanes | last post: by
reply views Thread by Chris Moy | last post: by
4 posts views Thread by Dave | last post: by
1 post views Thread by Barbara Lindsey | last post: by
4 posts views Thread by Egyd Csaba | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.