docker解决mysql索引过长异常

导入数据时候显示 Index column size too large. The maximum column size is 767 bytes.

docker exec -it mysql mysql -uroot -p
输入密码

设置参数
set global innodb_file_format = BARRACUDA;
设置参数
set global innodb_large_prefix = ON;
刷新配置
flush privileges;
sql文件添加配置
ROW_FORMAT=DYNAMIC