select sum(row_size) from ( select char_length(column1)+ char_length(column2)+ char_length(column3)+ char_length(column4) ... <-- repeat for all columns as row_size from your_table) as tbl1;
char_length对
enum，
set可能不准确，请注意
select sum(row_size) from ( select char_length(column1)+ char_length(column2)+ char_length(column3)+ char_length(column4) ... <-- repeat for all columns as row_size from your_table) as tbl1;
char_length对
enum，
set可能不准确，请注意
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
