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;
相关文章：
