PDA

View Full Version : Last time the table was changed



Masetek
06-12-2006, 04:34 AM
Does anyone know if there is a mysql command that returns the last time a table was modified?

fatnewt
06-12-2006, 10:24 AM
You can use SHOW TABLE STATUS. This will output the status details of every table on the active database.

One of the columns returned is Update_time, which is what you want.


See: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

Masetek
06-12-2006, 06:52 PM
Excellent, thanks :)