In this post, I am sharing one of the basic DBA query to find the last updated time of the MySQL Table.
We can also check the row level last updated time by adding one extra column into table like, last_updated_datetime.
Generally for reporting purpose, we are using this approach to check the row level last updated datetime.
As a Database Administrator, This is our responsibility to monitor some of the important tables of our MySQL database.
Here, The DBA requires to know last updated time at the Table Level.
We can use information_schema.tables to find information of the MySQL tables.
WHERE TABLE_SCHEMA = 'Database_Name'
AND TABLE_NAME = 'Table_Name';
Using Status Command:
SHOW TABLE STATUS FROM Database_Name LIKE 'Table_Name';
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.