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';
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';
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
