Last time the table was changed

[Masetek]

Does anyone know if there is a mysql command that returns the last time a table was modified?

[fatnewt]

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/...le-status.html

[Masetek]

Excellent, thanks