参考地址: https://www.cnblogs.com/kerrycode/p/9680881.html
Mysql5.6默认关闭的,5.7默认打开的
show variables like ‘%innodb_large_prefix%‘; set global innodb_large_prefix=on; show variables like ‘%innodb_file_format%‘; #显示结果如下 innodb_file_format Antelope innodb_file_format_check ON innodb_file_format_max Antelope set global innodb_file_format=Barracuda;
Mysql ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
原文:https://www.cnblogs.com/eason-d/p/10826863.html