MySQL 5.5.24 (WAMP 2.2) is being used. Could you please provide some details on how this can be done?
Thanks in advance.
MySQL 5.5.24 (WAMP 2.2) is being used. Could you please provide some details on how this can be done?
Thanks in advance.
Last edited by vrltwe; 30th December 2013 at 17:11. Reason: updated contents
AFAICT there is no inbuilt Mysql mechanism to alert an external observer that a table has changed. You can use a trigger to detect updates but to notify an external watcher you would need to use a user-defined function (UDF) to call an external application that broadcasts the notification. Here is an example
https://help.pubnub.com/entries/2244...abase-Trigger-
(This will not scale well for high speed inserts)
You can also use a trigger to update a single row table containing a timestamp that your program can poll. When the timestamp becomes newer than your local last update time then refresh your view. Google has plenty of different variations on this theme.
vrltwe (31st December 2013)
Bookmarks