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 /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
