mysql 数据库脚本报错处理

执行如下代码

 show variables like 'innodb_large_prefix'

 set global innodb_file_format = BARRACUDA;

 set global innodb_large_prefix = ON;

 show variables like 'innodb_large_prefix'

 

 

 

 

 

 

 

 

 

ENGINE = InnoDB AUTO_INCREMENT = 3860231 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '产品表' ROW_FORMAT = Dynamic
[ERR] 1071 - Specified key was too long; max key length is 767 bytes