MYSQL-查询多表数据量

SQL

查询多表数据量执行sql

select
table_schema as '数据库'  ,
table_name as '表名' ,
table_rows as '记录数量'
FROM information_schema.tables
where TABLE_SCHEMA = 'db_name' 
AND table_name in 
(
'table_name1' ,
'table_name2' 
)