E-mail notification for database record additions

How can I set up my MySQL 4.0 database so that I get e-mail notification each time a record is added? Is there a way to do is using a shell or PHP script?

    Requires Free Membership to View

    Login

The simplest way is to add an e-mail send to the application adding the data. In MySQL 5.0, you could use a combination of a trigger and a user-defined function (UDF) to do this, with the UDF calling some form of C function for sending email.

This was first published in April 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top