me,myself,english and programming..
«
»

MySQL – Show all tables row count

SELECT table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = ‘YOUR SCHEMA’;

mysql-count

 

p/s :
Dear blog, it has been quite some time i’m not write anything here.

This entry was posted on Tuesday, March 27th, 2012 at 9:25 am and is filed under SQL/ETL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Post a Comment