Getting MySQL row count of all tables in a database with one query
A quick way to get the row count of all tables in a database is querying data from the information_schema database directly.
Example
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = 'yourTable' ORDER BY table_name;