I don't think there is an SMTP API built into MySQL. A trigger could insert a record into another table and a crontab could send mails based on the contents of this table..
On 5/31/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > If we get triggers in mysql 5, couldn't you setup something like this? > > --ja > > On Tue, 31 May 2005, Philip Denno wrote: > > > I doubt you would find this feature in any database. You would have to > > implement at the application code level. Basically whenever you insert > > into a table have the application framework send an e-mail. > > > > The log4j package provides this kind of functionality. > > > > See http://logging.apache.org/ > > > > And look for information on the SMTP appender. > > > > Cheers, > > Philip. > > > > -----Original Message----- > > From: Jayson [mailto:[EMAIL PROTECTED] > > Sent: May 31, 2005 6:59 AM > > To: mysql@lists.mysql.com > > Subject: email notification > > > > > > I'm looking for a feature in mysql where it will email me if ther are > > any changes in a particular database or table. > > > > > > -- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]