MySQL Tips & Tricks

Wednesday, October 8, 2008

How can you test if/when a database was last used/updated?

SHOW TABLE STATUS for database01;

This lists create_time & update_time it is easy to visually scan to see latest update date.

0 Comments:

Post a Comment



<< Home