MySQL last table alteration time
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.
More information about the PLUG