The Following SQL query will list all tables in a MySQL database and also list the row counts for each.
SELECT TABLE_NAME, TABLE_ROWS
FROM `information_schema`.`tables`
WHERE `table_schema` = 'mydatabase';
where mydatabase is the name or your database. The output will like something like the following:
+------------+------------+
| table_name | table_rows |
+------------+------------+
| lines | 2271 |
| links | 484 |
| word | 25004 |
+------------+------------+