KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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;
Tags (comma-separated)
Save Edits
Cancel