MySQL - Generate selects for counting rows of each table in a database

mysql_count_rows_sql_generator.sql

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 = '<database_name>'

Generates output like the following

| SELECT "asn_assignee" AS table_name, COUNT(*) AS exact_row_count F|
| SELECT "asn_assignees" AS table_name, COUNT(*) AS exact_row_count |
| SELECT "asn_assignment" AS table_name, COUNT(*) AS exact_row_count|
| SELECT "asn_assignment_entry" AS table_name, COUNT(*) AS exact_row|