数据库各表当前记录数查询

MySQL数据库：

SELECT TABLE_NAME, TABLE_ROWS, (DATA_LENGTH+INDEX_LENGTH)/1024/1024 AS TOTAL_MB
FROM information_schema.TABLES
WHERE TABLE_SCHEMA=’database_name‘
ORDER BY TABLE_ROWS DESC
LIMIT 100;

“database_name”改成需要查询的数据库名即可。