MySQL查询指定数据库表名及每张表数据条数

-- 查询指定数据库表名及每张表数据条数
SELECT 
    TABLE_NAME AS 'Table',
    TABLE_ROWS AS 'Rows'
FROM 
    INFORMATION_SCHEMA.TABLES
WHERE 
    TABLE_SCHEMA = 'mydb';