How to find out number of records in each table of MySQL database?.We can do a count from each table but that was not a good solution.So below query is the solution to find out each rows count in table without hitting count(*).


select table_name,  table_rows from information_schema.tables where 
TABLE_SCHEMA='testdb'  order by 2 desc ;

Here testdb is database name,After executing above query it will display the number of row count in each table .