Alex Rivera | Logout

Watching a table for change in MySQL?

Asked 2008-10-03T14:51:28.730
29

Is there a better way to watch for new entries in a table besides selecting from it every n ticks of time or something like that?

I have a table that an external program updates very often, and clients can watch for this new data as it arrive, how can I make that without having to set a fixed period of repeatable select statements?

Edit
Report

1 Answer

1

This is just a small improvement to your method. Write a trigger on the table(s) you are watching to update a Last_Changed table.

answered 2008-10-03T14:56:54.867

Your Answer