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 :)
Powered by vBulletin® Version 4.2.2 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.