A phpmyadmin kényelmes, de nincs mindig.

SELECT table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db';

NoXy