iamdaboss Posted September 25, 2007 Share Posted September 25, 2007 Hi, How do i find out the last modification time of a table in MySQL database. I would like to use this time in a PHP script. Thank you. Link to comment https://forums.phpfreaks.com/topic/70657-solved-mysql-get-last-modification-time-of-table/ Share on other sites More sharing options...
php_dave Posted September 25, 2007 Share Posted September 25, 2007 Hi you need access to the information_schema schema and query the TABLES table something like SELECT information_schema.`TABLES`.UPDATE_TIME FROM information_schema.`TABLES` WHERE information_schema.`TABLES`.TABLE_NAME = 'your_table_name' HTH Dave Link to comment https://forums.phpfreaks.com/topic/70657-solved-mysql-get-last-modification-time-of-table/#findComment-355131 Share on other sites More sharing options...
iamdaboss Posted September 28, 2007 Author Share Posted September 28, 2007 thank you. Link to comment https://forums.phpfreaks.com/topic/70657-solved-mysql-get-last-modification-time-of-table/#findComment-356916 Share on other sites More sharing options...
fenway Posted September 28, 2007 Share Posted September 28, 2007 I think there's also a way to query the table metadata in <v5. Link to comment https://forums.phpfreaks.com/topic/70657-solved-mysql-get-last-modification-time-of-table/#findComment-356945 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.