MySQL last table alteration time

Nicholas Leippe nick at leippe.com
Tue Mar 27 16:20:44 MDT 2007


On Tuesday 27 March 2007, 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.

SHOW TABLE STATUS LIKE '<table>';
look at the Update_time column.

Also, in MySQL 5.x there is the metadata stuff that may be more accurate.

Nick



More information about the PLUG mailing list