How to send email via stored procedure in MySQL?

[Arthur]

Hi

Can anyone tell me how to send email from stored procedure in MySQL?

[Michelle Taylor]

According to personal experience, the simplest method would be:

1.Just create a table to keep emails such as (ID, Email, Subject, Body, Sent mail Flag,etc.)
2.Use trigger to write to this table
3.You have to process (Unix cron job etc....) that polls this table looking for any new entries ie. Where not sent.
4.You would also have a time showing so it will display when the record was added and when it was sent.