SELECT TABLE_SCHEMA,TABLE_NAME, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA IN ('db1','db2','db3') ORDER BY `TABLE_SCHEMA`, `TABLE_NAME`, `TABLE_ROWS`; /* This will show you database table counts */