Use mysql stored procedure to send emails

Posted on 2008-11-09
Last Modified: 2012-05-05
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.
Question by:two-chez
    LVL 31

    Accepted Solution

    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.

    Author Closing Comment

    Thanks, makes sense.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now