Page 1 of 1

Get notified on table-change.

Posted: Mon 22 Nov 2004 15:19
by GEswin
Hi, I need in a certain case alert a user when a table got a new record. Is there any callback method or similar ? Right now I use a timer that does a recordcount of that table (select sum(*) from table). is there any better way to do this ? Or get some CRC of the table, or similar ?

thanks in advance,

J.Pieter Vos

Re: Get notified on table-change.

Posted: Mon 22 Nov 2004 16:22
by Ikar
MySQL server doesn't provide such functionality.
Probably, timestamp fields will more suit for your task.