mysql统计指定数据库的各表的条数

mysql统计指定数据库的各表的条数

SELECT table_schema,table_name,table_rows,CREATE_TIME FROM TABLES WHERE TABLE_SCHEMA='cloud_**'  ORDER BY table_rows DESC;

SELECT table_schema,table_name,table_rows,CREATE_TIME FROM TABLES WHERE TABLE_SCHEMA='db_name_xxxx' and table_name like 'tabe_name%' ORDER BY table_name DESC;

 

相关文章：

 1、mysql查看数据库表大小、索引大小与表数量

 2、MySQL 字段信息统计机制