统计MySQL中某个数据库中有多少张表 SELECT count(*) TABLES, table_schema FROM information_schema.TABLES where table_schema = 'db_production' GROUP BY table_schema;
统计MySQL中某个数据库中表记录数 use information_schema; select table_name,table_rows from tables where TABLE_SCHEMA = 'pims_ptemp' order by table_rows desc;
where table_schema = 你的数据库名