mysql error msg:Index column size too large. The maximum column size is 767 bytes
2022-4-26 夙夜
修改mysql my.cnf文件配置，追加或删除
innodb_large_prefix=ON
innodb_file_per_table
=ON
innodb_file_format=Barracuda
重启mysql
使用语句查看状态
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_per_table';
show variables like 'innodb_file_format';
之后应该将原先表结构修改为
ALTER TABLE mytable ROW_FORMAT=DYNAMIC;
标签: mysql