mysql查询数据库的大小

select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data

  from information_schema.TABLES

 where table_schema = 'testdb'

   and table_name = 'test_a';

select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data

  from information_schema.TABLES

 where table_schema = 'testdb'

   and table_name like 'test%';