查看mysql中所有表的数据记录

select table_name,table_rows from tables 
where TABLE_SCHEMA = 'database name' 
order by table_rows desc;