Does anyone know if there is a mysql command that returns the last time a table was modified?
Does anyone know if there is a mysql command that returns the last time a table was modified?
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
Colin Temple
Video Game Consoles | RPGs and MMOs | Xbox Living
Philosophy | Mythology | Tourette's Syndrome
Blog: Work, Web, Play
Bookmarks