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 UI/UX Design

UI/UX Design by makandra brand

We make sure that your target audience has the best possible experience with your digital product. You get:

  • Design tailored to your audience
  • Proven processes customized to your needs
  • An expert team of experienced designers
Read more Show archive.org snapshot
Posted by Thomas Eisenbarth to makandra dev (2015-03-04 14:01)