Hi All, Thanks for the feedback!
On 5/17/05, David Logan <[EMAIL PROTECTED]> wrote: > 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]