472,133 Members | 1,138 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.

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 13550
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.