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;