Mysql ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

时间：2019-05-07 18:21:10 收藏：0 阅读：808

参考地址: 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;

原文：https://www.cnblogs.com/eason-d/p/10826863.html