In Mysql, how do you list tables order by their creation dates?

Question

I know that using "show tables;" command can list the tables in a database.

But it seems that, by default, it shows the list in alphabetical order.

I would like them to be ordered by their creation/modified dates

The "modified" here does not mean modifications on the rows. It refers to modifications on its structure, for example, adding a column.

Many thanks to you all.

Answer 1

If you have MySQL 5.0.3 or above you can use 'show table status' which will list the tables and show their last date and time they were modified.  However, it still lists them in alphabetical order.  The column "Create_time" shows the date and time they were modified.