Read more

SQL: Find out number of rows of all tables within a MySQL database

Thomas Eisenbarth
March 04, 2015Software engineer at makandra GmbH

Here you are:

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database' order by table_rows;
Illustration web development

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

  • We build reliable cloud solutions with Infrastructure as code
  • We are experts in security, Linux and databases
  • We support your dev team to perform
Read more Show archive.org snapshot
Posted by Thomas Eisenbarth to makandra dev (2015-03-04 14:01)