CODEWITHSUNDEEP
mysqlsqldatabasecount
nonopolarity
nonopolarity

Reputation: 150976

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?

Upvotes: 0

Views: 189

Answers (2)

Mark Baker
Mark Baker

Reputation: 212412

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

Upvotes: 2

Rob Di Marco
Rob Di Marco

Reputation: 44942

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

Upvotes: 2

Related Questions