get all rows count of all tables in a mysql database.

select t.table_rows, t.table_name from information_schema.tables t where table_schema = 'nova';

select t.table_rows, t.table_name from information_schema.tables t where table_schema = 'nova' and t.table_rows > 0;