mysql查表大小

代元培

于 2020-06-01 15:25:12 发布

阅读量195

点赞数

CC 4.0 BY-SA版权

分类专栏： MySQL 文章标签：表大小 mysql

本文链接：https://blog.youkuaiyun.com/sosemseo/article/details/106473227

MySQL 专栏收录该内容

20 篇文章

订阅专栏

select 
    concat(round(sum(DATA_LENGTH/1024/1024),2),'M')
from information_schema.tables
where table_schema='bfb_db' 
AND table_name='t_network_bank_info';

+-------------------------------------------------+
| concat(round(sum(DATA_LENGTH/1024/1024),2),'M') |
+-------------------------------------------------+
| 24.56M                                          |
+-------------------------------------------------+