SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘DATABASE_NAME‘ ;
mysql查询所有表行数
原文：http://www.cnblogs.com/lurenjiashuo/p/mysql-all-table-rows-count.html
