系统变量innodb_large_prefix为ON
系统变量innodb_file_format为Barracuda
ROW_FORMAT为DYNAMIC或COMPRESSED
show variables like '%innodb_large_prefix%';//查看是否开启
set global innodb_large_prefix=on;//如果没有开启设置开启
show variables like '%innodb_file_format%';//查看file格式
set global innodb_file_format=Barracuda;//设置格式
set global innodb_file_format_max=Barracuda;//设置格式
row_format=DYNAMIC或COMPRESSED ;//设置格式
系统变量innodb_large_prefix为ON 系统变量innodb_file_format为Barracu...
1、Syntax error or access violation: 1071 Specified key wa...
清空具有外键约束的表时报ERROR 1701(42000)的解决 ERROR 1701 (42000): Cann...
错误记录ERROR 1064 (42000): You have an error in your SQL解决办法...
今天在MySQL 5.6版本的数据库中修改InnoDB表字段长度时遇到了”ERROR 1071 (42000): ...
//-------------------------------------------------------...
创建表时，报如下错误： 1071 - Specified key was too long; max key le...
PyMySql ERROR 1148 (42000): The used command is not allow...
在 mysql 5.7版本 出现 ERROR 1064 (42000): You have an error in...
ERROR 1055 (42000): Expression #1 of SELECT list is not i...
本文标题：解决ERROR 1071 (42000) : Specified
本文链接：https://www.haomeiwen.com/subject/bxcdrctx.html
网友评论