#查看各表行数

USE information_schema;

SELECT

table_name,

table_rows

FROM

TABLES

WHERE

TABLE_SCHEMA = '【这里是数据库名】'

ORDER BY

table_rows DESC;