Get Row Counts in MySQL

get_row_counts.sql

SELECT 
    TABLE_SCHEMA, TABLE_NAME, SUM(TABLE_ROWS) as row_count
FROM
    INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA , TABLE_NAME
HAVING row_count > 0
ORDER BY row_count desc;