mysql实用语句

select a.TABLE_SCHEMA ,a.TABLE_NAME ,a.TABLE_ROWS from information_schema.tables a where a.TABLE_SCHEMA ='db_patrol' order by a.TABLE_ROWS ;