MySQL last table alteration time

Ryan Simpkins plug at
Tue Mar 27 16:17:48 MDT 2007

On Tue, March 27, 2007 16:12, Dave Smith wrote:
> Does MySQL provide a way to query the last time a table's data was
> changed (i.e., insert, delete, or update)? Preferably, I'd like to
> execute an SQL statement to get the information. I realize I could go
> look at the .frm files on disk, but I may not have local access to the
> MySQL server.

You might take a look at this:

If you are using v5 you can also likely use the information_schema view.


More information about the PLUG mailing list