MySQL last table alteration time
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:
If you are using v5 you can also likely use the information_schema view.
More information about the PLUG