when a MySQL table was last updated?

by Jayanthi 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 |
483
like
1
dislike
0
mail
flag

You must LOGIN to add comments