key_len的长度计算公式:
varchr(10)变长字段且允许NULL = 10 * ( character set:utf8=3,gbk=2,latin1=1)+1(NULL)+2(变长字段)
varchr(10)变长字段且不允许NULL = 10 *( character set:utf8=3,gbk=2,latin1=1)+2(变长字段)
char(10)固定字段且允许NULL = 10 * ( character set:utf8=3,gbk=2,latin1=1)+1(NULL)
char(10)固定字段且不允许NULL = 10 * ( character set:utf8=3,gbk=2,latin1=1)
例如order表其中一个字段:
1,如`order_no` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL
则key_len = 10 * 3 + 2 + 1 = 33
2,如`order_no` varchar(10) COLLATE utf8_unicode_ci NOT NULL
则key_len = 10 * 3 + 2 = 32
3,如`order_no` char(10) COLLATE utf8_unicode_ci DEFAULT NULL
则key_len = 10 * 3 + 1 = 31
4,如`order_no` char(10) COLLATE utf8_unicode_ci NOT NULL
则key_len = 10 * 3 = 30