1.查看所有数据库中，所有表的记录数，并倒序输出

SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS FROM information_schema.TABLES where TABLE_SCHEMA!='information_schema' order by TABLE_ROWS desc;

2.查看指定数据库test中，所有表的记录数，并倒序输出

SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS FROM information_schema.TABLES where TABLE_SCHEMA!='test' order by TABLE_ROWS desc;