If you use MyISAM tables you could always do:
SHOW TABLE STATUS LIKE 'tablename'
Then look at the Update_time column.
If that has changed since last time then something has changed. Then
implement a php/perl/whatever script around it to email you.
Note: On my InnoDB tables this time seems to
Jayson,
Are you working with Windows or UNIX versions of MySQL?
Mikhail Berman
-Original Message-
From: Jayson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 9:59 AM
To: mysql@lists.mysql.com
Subject: email notification
I'm looking for a feature in mysql where it will email me i
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 lik
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 applicat
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 lo
