Hi, logbin can help you to track transactions and then write your notification code.
trigger in mysql 5.x will help you a lot (v5 in still in beta state now). Mathias Selon Philip Denno <[EMAIL PROTECTED]>: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
