Philip Denno wrote:
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.
Regards
Hi,
Triggers were added at 5.0.2 They have some limitations but are documented in the manual at http://dev.mysql.com/doc/mysql/en/create-trigger.html
Regards
--
David Logan South Australia
when in trouble, or in doubt run in circles, scream and shout
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]