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. Quote 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 Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.