I have ~ 50 tables in database. How to list tables by update time?
'show tables' - Can I order it?

Thanks

    SHOW TABLE STATUS has an "update_time" column

      Using the information_schema database:

      select UPDATE_TIME, TABLE_NAME from TABLES where TABLE_SCHEMA like '%db_name%' order by UPDATE_TIME;

      Edit: only change db_name to the name of the database

        Write a Reply...