Skip to content Skip to sidebar Skip to footer
Home / Mysql / Sql

How To Display All The Tables With More Information (create Date, Size,...) In A Mysql Database?

Post a Comment
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 creat

Solution 1:

INFORMATION_SCHEMA.TABLES is the most easily queryable, but that doesn't have creation date. show table status does return creation date information. You can probably craft something to get the table name out of information_schema, then call show table status on each.


Post a Comment for "How To Display All The Tables With More Information (create Date, Size,...) In A Mysql Database?"