send a mail by stored procedure in msyql

Pawan Kumar · #1 (**permalink**) 04-26-11, 03:50

Hi All,
Could anyone help me out how to send mail from stored procedure in mysql??

Thanks..

mike_bike_kite · #2 (**permalink**) 04-26-11, 04:32

I guess the easiest method would be to :

Create a table to hold the emails (id, email, subject, body, sent_flg ).
Get your trigger to write to this table.
Have a process (Unix cron job etc) that polls this table looking for any new entries (ie where not sent).
When it finds one then it sends the email and updates the sent flag.
I'd also have a time showing when the record was added and when it was sent.