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

Here you are:

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database' order by table_rows;
Thomas Eisenbarth over 7 years ago
This website uses short-lived cookies to improve usability.
Accept or learn more