How to get the data count for all tables in a MySQL database

We can use the following query to get the data count for all tables in MySQL database.

>SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = 'dbname';

Where dbname need to be replaced with the name of the required database.

That's all…