Re: last UPDATE or INSERT time of a table?

From: "Louis-David Mitterrand" <cunctator@apartia.ch>

> Is there a way to check the last time a table was UPDATEd or INSERTEd?
> Is there a timestamp somewhere in the system tables?
>
> (If not that would be really useful to help in web page cacheing and
> expiration to learn if any change occured on the data)
>
> Thanks in advance,

You can set up a trigger. See my previous post RFC: automatic
"lastchange"... for some more info, or search the archives.

- Richard Huxton