Yes, we wil explain, but at least elaborate few things such as what exactly you want to do? So other kids like me understand your actual concern issue.. Anyway, if your question is about “how to send email from stored procedure in MySQL?” then you can consider following steps.
Quote:
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.
|
06-08-11, 06:32
How does work my SQl to send emails.?
Linear Mode
