mysql Index column size too large. The maximum column size is 767 bytes.的解决办法
mysql Index column size too large. The maximum column size is 767 bytes
查询是否是ON状态:
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_format';
如果不是开启状态,修改ROW_FORMAT格式,语句如下:
创建表语句后面加:ROW_FORMAT=DYNAMIC
修改表:ALTER TABLE mytable ROW_FORMAT=DYNAMIC;