码农日记

薄洪涛的个人博客

[Err] 1071 - Specified key was too long; max key length is 767 bytes2018-12-07 09:21:15

做数据库sql导入的时候，报错，[Err] 1071 - Specified key was too long; max key length is 767 bytes修正方法set global innodb_large_prefix=1;  set global innodb_file_format=BARRACUDA; set global innodb_file_format_max=BARRACUDA;每个建表语

作者:薄洪涛 | 分类:PHP | 浏览:1136 | 评论:0

<< 1 >>

Powered By Z-BlogPHP 1.7.3

版权所有 | 转载请标明出处