Hello,
I am fairly new to mysql and have a strange request .... I am not sure if "stored procedures" will solve this.
I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed.
I think we'll try to do something regarding this asap 5.0 gets in production mode (and when we'll have time, whichever comes first ;)
Our first idea is to add a stored procedure triggered on update of a particular table, then the stored procedure would call an UDF-function which would do the job. (just ping a particular port on a remote server, to force it update that table). As anyone been doing something like this ?
At the moment we're just polling the whole table every 5 seconds (not a big table less than 500 records)
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]