MySQL查看指定数据库的所有表及对应的记录数

MySQL查看指定数据库的所有表及对应的记录数

 

use information_schema;

 

select table_name,table_rows from tables where TABLE_SCHEMA = 'dbname' order by table_rows desc;

 

 

查看指定表的列

select COLUMN_NAME from information_schema.COLUMNS where table_name = 'table_name';