select table_name,table_rows from tables where TABLE_SCHEMA = ‘database name‘ order by table_rows desc;
查看mysql中所有表的数据记录
原文：http://www.cnblogs.com/learningJAVA/p/7839489.html
