when a MySQL table was last updated?
by Jayanthi[ Edit ] 2014-02-18 15:15:22
you can use the information_schema database to tell you when another table was updated
SELECT UPDATE_TIME
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'YOUR_DBNAME'
AND TABLE_NAME = 'YOUR_TABLENAME'
If you don't have information_schema database using this query.
show table status from YOUR_DBNAME like 'YOUR_TABLENAME'
This query shows all information of table.the column 'update_time' is last update time.
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
