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

佚名 6年前 (2019-05-07) 随笔 1898人围观抢沙发百度已收录

参考地址: https://www.cnblogs.com/kerrycode/p/9680881.html

Mysql5.6默认关闭的，5.7默认打开的

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

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;