首页 > 数据库技术 > 详细

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

时间:2019-05-07 18:21:10      阅读:808      评论:0      收藏:0      [点我收藏+]

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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!