Creates SQL that retrieves all tables and row counts for a given schema

gistfile1.txt

SELECT CONCAT(
    'SELECT "', 
    table_name, 
    '" AS table_name, COUNT(*) AS exact_row_count FROM ', 
    table_schema,
    '.',
    table_name, 
    ' UNION '
) 
FROM INFORMATION_SCHEMA.TABLES 
WHERE table_schema = 'your_db_here';

Generate many SQL lines such as...

SELECT "FAQ_categories" AS table_name, COUNT(*) AS exact_row_count FROM dbname.FAQ_categories UNION
SELECT "FAQ_titles" AS table_name, COUNT(*) AS exact_row_count FROM dbname.FAQ_titles UNION

Remember to remove the final UNION piece of SQL.