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