Getting the number of records in all tables in MySQL (use count)

mysql_get_table_count.sql

SET GROUP_CONCAT_MAX_LEN=131072;
SET @selects = NULL;
SELECT CONCAT('SELECT * FROM (\n', GROUP_CONCAT(single_select SEPARATOR ' UNION\n'), '\n ) Q ORDER BY Q.TABLE_ROWS DESC') AS sql_query
FROM (
    SELECT CONCAT(
        'SELECT "', 
        table_name, 
        '" AS TABLE_NAME, COUNT(1) AS TABLE_ROWS
        FROM `', 
        table_schema,
        '`.`',
        table_name, 
        '`'
    ) AS single_select
    FROM information_schema.tables
    WHERE table_schema = DATABASE()
      AND ENGINE = 'InnoDB'
      AND table_type = 'BASE TABLE'
) Q INTO @selects;
PREPARE stmt FROM @selects;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;