Get notified on table-change.

Get notified on table-change.

Postby GEswin » Mon 22 Nov 2004 15:19

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
GEswin
 
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Re: Get notified on table-change.

Postby Ikar » Mon 22 Nov 2004 16:22

MySQL server doesn't provide such functionality.
Probably, timestamp fields will more suit for your task.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components