saint959 Posted March 24, 2011 Share Posted March 24, 2011 Hey all, Is there a way that i can get the date that a mysql table's structure was last changed? I know i can get the last updated time but that only shows me when a record was entered into the table. I need to find when last the Structure was changed? Any help would be hugely appreciated. Link to comment https://forums.phpfreaks.com/topic/231589-get-the-last-date-the-table-structure-was-changed/ Share on other sites More sharing options...
The Little Guy Posted March 25, 2011 Share Posted March 25, 2011 $sql = mysql_query("SHOW TABLE STATUS where Name = 'table_name'"); // The where is optional, if not given it will show all tables $row = mysql_fetch_assoc($sql); echo $row['Update_time']; Link to comment https://forums.phpfreaks.com/topic/231589-get-the-last-date-the-table-structure-was-changed/#findComment-1192056 Share on other sites More sharing options...
fenway Posted April 1, 2011 Share Posted April 1, 2011 Update_time isn't robust -- doesn't work on all platforms. Link to comment https://forums.phpfreaks.com/topic/231589-get-the-last-date-the-table-structure-was-changed/#findComment-1195684 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.