MySQL错误 Specified key was too long max key length is 1000 bytes 的解决办法

经过查询才知道是Mysql字段设置太长了于是我把这两个字段长度改了下就好了

建立索引时数据库计算key长度是累加所有Index用到字段char长度后再按下面比例乘起来不能超过限定key长度1000:
latin1 = 1 = 1 character
uft8 = 3 = 1 character
gbk = 2 = 1 character
举例能看得更明白些以GBK为例:
CREATE UNIQUE INDEX `unique_record` _disibledevent=>如果表是UTF8集那索引还是建立不了

延伸阅读