SQL Row Count For All Tables - gecko-8/devwiki GitHub Wiki

SELECT table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '<table name>';