MySQL常见问题记录

  |   0 评论   |   0 浏览

不同文本字段大小

字段类型字节大小
text6553564KB
longtext21474836472GB
mediumtext1677721516MB

各表大小

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