Use mysql stored procedure to send emails

Need example of how to use mysql stored procedure to send emails with all information coming from mysql database only.  Do not want to use php or other non sql method.  Will be sending email based on status of record (i.e., approved) and DateEmailSent is null.
two-chezAsked:
Who is Participating?
 
Frosty555Connect With a Mentor Commented:
MySql is a database server. It alone does not have provisions for sending emails. You must use a technology other than MySql to send the email.

MySql is capable of writing records to tables, or even writing data to a text file on the server, but it cannot send emails. You would need to have some other program on the server watching for the changes and sending the emails.
0
 
two-chezAuthor Commented:
Thanks, makes sense.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.