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 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 Share on other sites More sharing options...
iamdaboss Posted September 28, 2007 Author Share Posted September 28, 2007 thank you. Quote Link to comment 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 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.