Using MySQL, is there any way to dump the count of records in each of all 200 tables in a database?

Say if there is a database that has 200 tables, is there a quick way to see how many records are in each table,开发者_运维问答 if possible, sorted by the number of records descendingly?

SELECT table_name,
       table_rows
  FROM `information_schema`.`tables`
 WHERE table_schema = '<Your Database Name>'
 ORDER BY table_rows DESC

Does show table status work for your problem? It has the row counts?