RE: email notification

2005-05-31 Thread Philip Denno 
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]

RE: mysql client update

2005-05-17 Thread Philip Denno 
I'm no database expert, so I may be wrong but I do not think this
functionality exists. Usually this type of notification is handled at
the application level. That is build an application layer on top of the
database which handles all reads and writes to the database. This layer
would also keep track of all connected clients and would notify when a
record is modified/inserted/created.

Cheers,
Philip.

-Original Message-
From: Eric White [mailto:[EMAIL PROTECTED] 
Sent: May 17, 2005 10:44 AM
To: mysql@lists.mysql.com
Subject: mysql client update


Hi,

Where should I look to find information about
having clients notified when a table/record is
updated?

I have a situation where multiple clients will each
have an open database connection, and I would
like for them to be notified when the database is
modified by a member of the group.

Something like a trigger that informs all clients
that a new record has been added for example.

Thanks in advance.

-- 
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]