How to display all the tables with more information (create date, size,…) in a MySQL database?

Searched and searched and gave up. All I want is more info on a MySQL table or better yet, a list of all tables in a MySQL database in the descending/ascending order of their create date.

Something like this :

SHOW TABLES FROM MyDB ORDER BY CREATE_DATE;

Donnie's answer did the trick :

select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'DBName' order by create_time desc;
12
задан ThinkCode 16 November 2010 в 19:04
поделиться