#查看各表行数
USE information_schema;
SELECT
table_name,
table_rows
FROM
TABLES
WHERE
TABLE_SCHEMA = '【这里是数据库名】'
ORDER BY
table_rows DESC;