MySQL last table alteration time

Ryan Simpkins plug at ryansimpkins.com
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:

http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

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

-Ryan



More information about the PLUG mailing list