本文主要是介绍mysql Specified key was too long; max key length is 767 bytes,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
一、数据库修改
show variables like '%innodb_large_prefix%';
set global innodb_large_prefix = ON;show variables like '%innodb_file_format%';
set global innodb_file_format = Barracuda;
set global innodb_file_format_max = Barracuda;
二、语句问题
在语句后面加上
ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT = 'xx';ENGINE=InnoDB ROW_FORMAT=DYNAMIC 是关键
这篇关于mysql Specified key was too long; max key length is 767 bytes的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!