这期内容当中小编将会给大家带来有关mysql5.6错误代码都有哪些,文章内容丰富且以专业的角度为大家分析和叙述,阅读完这篇文章希望大家可以有所收获。

版本5.6MySQL5.6参考手册/错误,错误代码和常见问题/服务器错误代码和消息B.3服务器错误代码和消息当服务器返回错误时,MySQL程序可以访问多种类型的错误信息。例如,mysql客户端程序使用以下格式显示错误:shell>SELECT*FROMno_such_table;ERROR1146(42S02):Table'test.no_such_table'doesn'texist显示的信息包含三种信息:数字错误代码(1146)。这个数字是MySQL特定的,不能移植到其他数据库系统。五个字符的SQLSTATE值('42S02')。这些值取自ANSISQL和ODBC,并且更加标准化。并不是所有的MySQL错误号都有相应的SQLSTATE值。在这些情况下,使用'HY000'(一般错误)。提供错误文本描述的消息字符串。对于错误检查,请使用错误代码,而不是错误消息。错误消息不会经常更改,但这是可能的。另外,如果数据库管理员更改语言设置,则会影响错误消息的语言。在给定的MySQL系列的GA版本中,错误代码是稳定的。在一系列达到GA状态之前,新的代码可能仍在开发中并可能发生变化。服务器错误信息来自以下源文件。有关错误信息定义方式的详细信息,请参阅MySQLInternals手册。错误消息信息在share/errmsg-utf8.txt文件中列出。%d并分别%s代表数字和字符串,它们在显示时被替换为消息值。列出的错误值share/errmsg-utf8.txt用于生成include/mysqld_error.h和include/mysqld_ername.hMySQL源文件中的定义。列出的SQLSTATE值share/errmsg-utf8.txt用于生成include/sql_state.hMySQL源文件中的定义。由于更新频繁,这些文件可能会包含其他错误信息,这里没有列出。错误:1000SQLSTATE:()HY000ER_HASHCHK消息:hashchk没用过。错误:1001SQLSTATE:()HY000ER_NISAMCHK消息:isamchk没用过。错误:1002SQLSTATE:()HY000ER_NO消息:没有用于构建其他消息。错误:1003SQLSTATE:()HY000ER_YES消息:是的用于构建其他消息。扩展EXPLAIN格式生成注释消息。在随后的输出中用于这些消息ER_YES的Code列中SHOWWARNINGS。错误:1004SQLSTATE:()HY000ER_CANT_CREATE_FILE消息:无法创建文件“%s”(错误:%d-%s)发生无法创建或复制某些操作所需的文件。可能的原因:源文件的权限问题;目标文件已经存在但不可写入。错误:1005SQLSTATE:()HY000ER_CANT_CREATE_TABLE消息:无法创建表'%s'(错误:%d)InnoDB在无法创建表格时报告此错误。如果错误消息引用错误150,表创建失败,因为外键约束不正确形成。如果错误消息指向错误-1,则表创建可能失败,因为表包含与内部InnoDB表名称匹配的列名称。错误:1006SQLSTATE:()HY000ER_CANT_CREATE_DB消息:无法创建数据库'%s'(错误:%d)错误:1007SQLSTATE:()HY000ER_DB_CREATE_EXISTS消息:无法创建数据库'%s';数据库存在由于数据库已经存在,因此尝试创建数据库失败。如果您真的想要替换现有的数据库,则首先删除数据库;如果保留现有的数据库而不会导致语句产生错误,则可以IFNOTEXISTS向该CREATEDATABASE语句添加一个子句。错误:1008SQLSTATE:()HY000ER_DB_DROP_EXISTS消息:无法删除数据库'%s';数据库不存在错误:1009SQLSTATE:()HY000ER_DB_DROP_DELETE消息:删除数据库时出错(不能删除'%s',errno:%d)错误:1010SQLSTATE:()HY000ER_DB_DROP_RMDIR消息:删除数据库时出错(不能rmdir'%s',errno:%d)错误:1011SQLSTATE:()HY000ER_CANT_DELETE_FILE消息:删除'%s'错误(错误:%d-%s)错误:1012SQLSTATE:()HY000ER_CANT_FIND_SYSTEM_REC消息:无法读取系统表中的记录由于InnoDB试图InnoDBINFORMATION_SCHEMA在InnoDB不可用时访问表而返回。错误:1013SQLSTATE:()HY000ER_CANT_GET_STAT消息:无法获取'%s'的状态(错误:%d-%s)错误:1014SQLSTATE:()HY000ER_CANT_GET_WD消息:无法获取工作目录(错误号:%d-%s)错误:1015SQLSTATE:()HY000ER_CANT_LOCK消息:无法锁定文件(错误:%d-%s)错误:1016SQLSTATE:()HY000ER_CANT_OPEN_FILE消息:无法打开文件:'%s'(错误:%d-%s)InnoDB当InnoDB数据文件中的表无法找到时报告此错误,即使.frm该表的文件存在。请参见第14.21.3节“排除InnoDB数据字典操作”。错误:1017SQLSTATE:()HY000ER_FILE_NOT_FOUND消息:找不到文件:'%s'(错误:%d-%s)错误:1018SQLSTATE:()HY000ER_CANT_READ_DIR消息:无法读取'%s'的目录(错误号:%d-%s)错误:1019SQLSTATE:()HY000ER_CANT_SET_WD消息:无法将目录更改为'%s'(错误:%d-%s)错误:1020SQLSTATE:()HY000ER_CHECKREAD消息:自从上次在表'%s'中读取后,记录发生了变化错误:1021SQLSTATE:()HY000ER_DISK_FULL消息:磁盘已满(%s);等待某人释放一些空间...(错误:%d-%s)错误:1022SQLSTATE:()23000ER_DUP_KEY消息:不能写;表'%s'中的重复键错误:1023SQLSTATE:()HY000ER_ERROR_ON_CLOSE消息:关闭“%s”时出错(错误号:%d-%s)错误:1024SQLSTATE:()HY000ER_ERROR_ON_READ消息:读取文件'%s'错误(错误:%d-%s)错误:1025SQLSTATE:()HY000ER_ERROR_ON_RENAME消息:将'%s'重命名为'%s'时出错(错误号:%d-%s)错误:1026SQLSTATE:()HY000ER_ERROR_ON_WRITE消息:写入文件'%s'时出错(错误号:%d-%s)错误:1027SQLSTATE:()HY000ER_FILE_USED消息:'%s'被锁定以防止更改错误:1028SQLSTATE:()HY000ER_FILSORT_ABORT消息:排序中止错误:1029SQLSTATE:()HY000ER_FORM_NOT_FOUND消息:查看'%s'不存在'%s'错误:1030SQLSTATE:()HY000ER_GET_ERRNO消息:从存储引擎收到错误%d检查%d值以查看OS错误的含义。例如,28表示您的磁盘空间不足。错误:1031SQLSTATE:()HY000ER_ILLEGAL_HA消息:'%s'的表存储引擎没有这个选项错误:1032SQLSTATE:()HY000ER_KEY_NOT_FOUND消息:在'%s'中找不到记录错误:1033SQLSTATE:()HY000ER_NOT_FORM_FILE消息:文件中的信息不正确:'%s'错误:1034SQLSTATE:()HY000ER_NOT_KEYFILE消息:表'%s'的密钥文件不正确;尝试修复它错误:1035SQLSTATE:()HY000ER_OLD_KEYFILE消息:表'%s'的旧密钥文件;修理它!错误:1036SQLSTATE:()HY000ER_OPEN_AS_READONLY消息:表'%s'是只读的错误:1037SQLSTATE:()HY001ER_OUTOFMEMORY消息:内存不足;重新启动服务器并重试(需要%d个字节)错误:1038SQLSTATE:()HY001ER_OUT_OF_SORTMEMORY消息:排序内存不足,请考虑增加服务器排序缓冲区大小错误:1039SQLSTATE:()HY000ER_UNEXPECTED_EOF消息:读取文件'%s'时发现意外的EOF(错误:%d-%s)错误:1040SQLSTATE:()08004ER_CON_COUNT_ERROR消息:连接太多错误:1041SQLSTATE:()HY000ER_OUT_OF_RESOURCES消息:内存不足;检查mysqld或其他进程是否使用了所有可用的内存;如果没有,你可能不得不使用“ulimit”来允许mysqld使用更多的内存,或者你可以添加更多的交换空间错误:1042SQLSTATE:()08S01ER_BAD_HOST_ERROR消息:无法获取您的地址的主机名错误:1043SQLSTATE:()08S01ER_HANDSHAKE_ERROR信息:不好的握手错误:1044SQLSTATE:()42000ER_DBACCESS_DENIED_ERROR消息:访问拒绝用户'%s'@'%s'到数据库'%s'错误:1045SQLSTATE:()28000ER_ACCESS_DENIED_ERROR消息:拒绝用户“%s”的访问@“%s”(使用密码:%s)错误:1046SQLSTATE:()3D000ER_NO_DB_ERROR消息:没有选择数据库错误:1047SQLSTATE:()08S01ER_UNKNOWN_COM_ERROR消息:未知的命令错误:1048SQLSTATE:()23000ER_BAD_NULL_ERROR消息:列'%s'不能为空错误:1049SQLSTATE:()42000ER_BAD_DB_ERROR消息:未知数据库'%s'错误:1050SQLSTATE:()42S01ER_TABLE_EXISTS_ERROR消息:表'%s'已经存在错误:1051SQLSTATE:()42S02ER_BAD_TABLE_ERROR消息:未知表格'%s'错误:1052SQLSTATE:()23000ER_NON_UNIQ_ERROR消息:%s中的列'%s'不明确%s=columnname%s=locationofcolumn(forexample,"fieldlist")可能的原因:列中出现没有适当限定的查询,例如在选择列表或ON子句中。例子:mysql>SELECTiFROMtINNERJOINtASt2;ERROR1052(23000):Column'i'infieldlistisambiguousmysql>SELECT*FROMtLEFTJOINtASt2ONi=i;ERROR1052(23000):Column'i'inonclauseisambiguous解析度:使用适当的表名限定列:mysql>SELECTt2.iFROMtINNERJOINtASt2;修改查询以避免需要资格:mysql>SELECT*FROMtLEFTJOINtASt2USING(i);错误:1053SQLSTATE:()08S01ER_SERVER_SHUTDOWN消息:正在进行服务器关闭错误:1054SQLSTATE:()42S22ER_BAD_FIELD_ERROR消息:'%s'中的未知列'%s'错误:1055SQLSTATE:()42000ER_WRONG_FIELD_WITH_GROUP消息:'%s'不在GROUPBY中错误:1056SQLSTATE:()42000ER_WRONG_GROUP_FIELD消息:无法在“%s”上进行分组错误:1057SQLSTATE:()42000ER_WRONG_SUM_SELECT消息:语句在同一语句中具有总和函数和列错误:1058SQLSTATE:()21S01ER_WRONG_VALUE_COUNT消息:列计数与值计数不匹配错误:1059SQLSTATE:()42000ER_TOO_LONG_IDENT消息:标识符名称'%s'太长错误:1060SQLSTATE:()42S21ER_DUP_FIELDNAME消息:重复列名称'%s'错误:1061SQLSTATE:()42000ER_DUP_KEYNAME消息:重复键名称'%s'错误:1062SQLSTATE:()23000ER_DUP_ENTRY消息:键%d的重复条目'%s'此错误返回的消息使用格式字符串ER_DUP_ENTRY_WITH_KEY_NAME。错误:1063SQLSTATE:()42000ER_WRONG_FIELD_SPEC消息:列'%s'的列说明符不正确错误:1064SQLSTATE:()42000ER_PARSE_ERROR消息:在%d行'%s'附近的%s错误:1065SQLSTATE:()42000ER_EMPTY_QUERY消息:查询是空的错误:1066SQLSTATE:()42000ER_NONUNIQ_TABLE消息:不是唯一的表/别名:'%s'错误:1067SQLSTATE:()42000ER_INVALID_DEFAULT消息:“%s”的默认值无效错误:1068SQLSTATE:()42000ER_MULTIPLE_PRI_KEY消息:定义了多个主键错误:1069SQLSTATE:()42000ER_TOO_MANY_KEYS消息:指定的密钥太多;最大%d个键允许错误:1070SQLSTATE:()42000ER_TOO_MANY_KEY_PARTS消息:指定的关键部件过多;最大%d部分允许错误:1071SQLSTATE:()42000ER_TOO_LONG_KEY消息:指定的密钥太长;最大密钥长度是%d个字节错误:1072SQLSTATE:()42000ER_KEY_COLUMN_DOES_NOT_EXITS消息:表中不存在键列'%s'错误:1073SQLSTATE:()42000ER_BLOB_USED_AS_KEY消息:在使用的表类型的密钥规范中,不能使用BLOB列'%s'错误:1074SQLSTATE:()42000ER_TOO_BIG_FIELDLENGTH消息:列'%s'的列长度太大(max=%lu);改为使用BLOB或TEXT错误:1075SQLSTATE:()42000ER_WRONG_AUTO_KEY消息:表格定义不正确;只能有一个自动列,它必须被定义为一个键错误:1076SQLSTATE:()HY000ER_READY消息:%s:准备好连接。版本:'%s'套接字:'%s'端口:%d错误:1077SQLSTATE:()HY000ER_NORMAL_SHUTDOWN消息:%s:正常关机错误:1078SQLSTATE:()HY000ER_GOT_SIGNAL消息:%s:得到的信号%d。中止!错误:1079SQLSTATE:()HY000ER_SHUTDOWN_COMPLETE消息:%s:关闭完成错误:1080SQLSTATE:()08S01ER_FORCING_CLOSE消息:%s:强制关闭线程%lduser:'%s'错误:1081SQLSTATE:()08S01ER_IPSOCK_ERROR消息:无法创建IP套接字错误:1082SQLSTATE:()42S12ER_NO_SUCH_INDEX消息:表'%s'没有像在CREATEINDEX中使用的索引;重新创建表格错误:1083SQLSTATE:()42000ER_WRONG_FIELD_TERMINATORS消息:字段分隔符参数不是预期的;检查手册错误:1084SQLSTATE:()42000ER_BLOBS_AND_NO_TERMINATED消息:您不能在BLOB中使用固定的行长度;请使用'终止的字段'错误:1085SQLSTATE:()HY000ER_TEXTFILE_NOT_READABLE消息:文件'%s'必须位于数据库目录中,或者全部可读错误:1086SQLSTATE:()HY000ER_FILE_EXISTS_ERROR消息:文件'%s'已经存在错误:1087SQLSTATE:()HY000ER_LOAD_INFO消息:记录:%ld删除:%ld跳过:%ld警告:%ld错误:1088SQLSTATE:()HY000ER_ALTER_INFO消息:记录:%ld重复:%ld错误:1089SQLSTATE:()HY000ER_WRONG_SUB_KEY消息:不正确的前缀密钥;使用的密钥部分不是字符串,使用的长度比密钥部分长,或者存储引擎不支持唯一的前缀密钥错误:1090SQLSTATE:()42000ER_CANT_REMOVE_ALL_FIELDS消息:无法使用ALTERTABLE删除所有列;改用DROPTABLE错误:1091SQLSTATE:()42000ER_CANT_DROP_FIELD_OR_KEY消息:不能删除'%s';检查列/键是否存在错误:1092SQLSTATE:()HY000ER_INSERT_INFO消息:记录:%ld重复:%ld警告:%ld错误:1093SQLSTATE:()HY000ER_UPDATE_TABLE_USED消息:您无法在FROM子句中指定目标表'%s'进行更新尝试在单个语句中选择和修改同一个表时发生此错误。请参见第C.4节“对子查询的限制”。错误:1094SQLSTATE:()HY000ER_NO_SUCH_THREAD消息:未知的线程ID:%lu错误:1095SQLSTATE:()HY000ER_KILL_DENIED_ERROR讯息:您不是线程%lu的拥有者错误:1096SQLSTATE:()HY000ER_NO_TABLES_USED消息:没有使用的表错误:1097SQLSTATE:()HY000ER_TOO_BIG_SET消息:列%s和SET的字符串太多错误:1098SQLSTATE:()HY000ER_NO_UNIQUE_LOGFILE消息:无法生成唯一的日志文件名%s。(1-999)错误:1099SQLSTATE:()HY000ER_TABLE_NOT_LOCKED_FOR_WRITE消息:表'%s'被READ锁定锁定,无法更新错误:1100SQLSTATE:()HY000ER_TABLE_NOT_LOCKED消息:表'%s'没有被LOCKTABLES锁定错误:1101SQLSTATE:()42000ER_BLOB_CANT_HAVE_DEFAULT消息:BLOB/TEXT列'%s'不能有默认值错误:1102SQLSTATE:()42000ER_WRONG_DB_NAME消息:错误的数据库名称'%s'错误:1103SQLSTATE:()42000ER_WRONG_TABLE_NAME消息:错误的表名'%s'错误:1104SQLSTATE:()42000ER_TOO_BIG_SELECT消息:SELECT将检查多于MAX_JOIN_SIZE行;检查你的WHERE并使用SETSQL_BIG_SELECTS=1或SETMAX_JOIN_SIZE=#如果SELECT可以错误:1105SQLSTATE:()HY000ER_UNKNOWN_ERROR消息:未知的错误错误:1106SQLSTATE:()42000ER_UNKNOWN_PROCEDURE消息:未知程序'%s'错误:1107SQLSTATE:()42000ER_WRONG_PARAMCOUNT_TO_PROCEDURE消息:过程'%s'的参数计数不正确错误:1108SQLSTATE:()HY000ER_WRONG_PARAMETERS_TO_PROCEDURE消息:过程'%s'的参数不正确错误:1109SQLSTATE:()42S02ER_UNKNOWN_TABLE消息:%s中的未知表格“%s”错误:1110SQLSTATE:()42000ER_FIELD_SPECIFIED_TWICE消息:列'%s'指定了两次错误:1111SQLSTATE:()HY000ER_INVALID_GROUP_FUNC_USE消息:无法使用组功能错误:1112SQLSTATE:()42000ER_UNSUPPORTED_EXTENSION消息:表'%s'使用此MySQL版本中不存在的扩展名错误:1113SQLSTATE:()42000ER_TABLE_MUST_HAVE_COLUMNS消息:表格必须至少有1列错误:1114SQLSTATE:()HY000ER_RECORD_FILE_FULL消息:表格'%s'已满InnoDB当系统表空间用尽可用空间时报告此错误。重新配置系统表空间以添加新的数据文件。错误:1115SQLSTATE:()42000ER_UNKNOWN_CHARACTER_SET消息:未知字符集:'%s'错误:1116SQLSTATE:()HY000ER_TOO_MANY_TABLES消息:表太多;MySQL只能在连接中使用%d个表错误:1117SQLSTATE:()HY000ER_TOO_MANY_FIELDS消息:列太多错误:1118SQLSTATE:()42000ER_TOO_BIG_ROWSIZE消息:行大小太大。已用表类型的最大行大小(不计算BLOB)为%ld。这包括存储开销,检查手册。您必须将某些列更改为TEXT或BLOB错误:1119SQLSTATE:()HY000ER_STACK_OVERRUN消息:线程堆栈溢出:使用:%ld堆栈的%ld。如果需要,使用'mysqld--thread_stack=#'指定一个更大的堆栈错误:1120SQLSTATE:()42000ER_WRONG_OUTER_JOIN消息:在OUTERJOIN中发现交叉依赖;检查你的ON条件错误:1121SQLSTATE:()42000ER_NULL_COLUMN_IN_INDEX消息:表处理程序不支持给定索引中的NULL。请将列'%s'更改为NOTNULL或使用其他处理程序错误:1122SQLSTATE:()HY000ER_CANT_FIND_UDF消息:无法加载函数'%s'错误:1123SQLSTATE:()HY000ER_CANT_INITIALIZE_UDF消息:无法初始化函数'%s';%S错误:1124SQLSTATE:()HY000ER_UDF_NO_PATHS消息:没有允许共享库的路径错误:1125SQLSTATE:()HY000ER_UDF_EXISTS消息:函数'%s'已经存在错误:1126SQLSTATE:()HY000ER_CANT_OPEN_LIBRARY消息:无法打开共享库“%s”(错误:%d%s)错误:1127SQLSTATE:()HY000ER_CANT_FIND_DL_ENTRY消息:在库中找不到符号'%s'错误:1128SQLSTATE:()HY000ER_FUNCTION_NOT_DEFINED消息:函数'%s'未定义错误:1129SQLSTATE:()HY000ER_HOST_IS_BLOCKED消息:主机'%s'由于连接错误而被阻止;用'mysqladminflush-hosts'解锁错误:1130SQLSTATE:()HY000ER_HOST_NOT_PRIVILEGED消息:主机'%s'不允许连接到这个MySQL服务器错误:1131SQLSTATE:()42000ER_PASSWORD_ANONYMOUS_USER消息:您正在使用MySQL作为匿名用户,匿名用户不允许更改密码错误:1132SQLSTATE:()42000ER_PASSWORD_NOT_ALLOWED消息:您必须具有更新mysql数据库中的表的权限才能更改其他人的密码错误:1133SQLSTATE:()42000ER_PASSWORD_NO_MATCH消息:在用户表中找不到任何匹配的行错误:1134SQLSTATE:()HY000ER_UPDATE_INFO消息:匹配的行:%ld更改:%ld警告:%ld错误:1135SQLSTATE:()HY000ER_CANT_CREATE_THREAD消息:不能创建一个新的线程(errno%d);如果你的内存不足,你可以参考手册了解一个可能依赖操作系统的错误错误:1136SQLSTATE:()21S01ER_WRONG_VALUE_COUNT_ON_ROW消息:列计数与行%ld处的值计数不匹配错误:1137SQLSTATE:()HY000ER_CANT_REOPEN_TABLE消息:无法重新打开表格:'%s'错误:1138SQLSTATE:()22004ER_INVALID_USE_OF_NULL消息:无效的NULL值使用错误:1139SQLSTATE:()42000ER_REGEXP_ERROR消息:从正则表达式中收到错误“%s”错误:1140SQLSTATE:()42000ER_MIX_OF_GROUP_FUNC_AND_FIELDS消息:如果没有GROUPBY子句,则GROUP列(MIN(),MAX(),COUNT(),...)与GROUP列的混合是非法的错误:1141SQLSTATE:()42000ER_NONEXISTING_GRANT消息:在主机'%s'上没有为用户'%s'定义的此类授权错误:1142SQLSTATE:()42000ER_TABLEACCESS_DENIED_ERROR消息:%s命令被拒绝给用户'%s'@'%s'表'%s'错误:1143SQLSTATE:()42000ER_COLUMNACCESS_DENIED_ERROR消息:表'%s'中的%s命令被拒绝给用户'%s'@'%s'列'%s'错误:1144SQLSTATE:()42000ER_ILLEGAL_GRANT_FOR_TABLE消息:非法的GRANT/REVOKE命令;请查阅手册以查看可以使用哪些权限错误:1145SQLSTATE:()42000ER_GRANT_WRONG_HOST_OR_USER消息:GRANT的主机或用户参数太长错误:1146SQLSTATE:()42S02ER_NO_SUCH_TABLE消息:表'%s。%s'不存在错误:1147SQLSTATE:()42000ER_NONEXISTING_TABLE_GRANT消息:表'%s'上的主机'%s'上没有为用户'%s'定义的此类授权错误:1148SQLSTATE:()42000ER_NOT_ALLOWED_COMMAND消息:这个MySQL版本不允许使用命令错误:1149SQLSTATE:()42000ER_SYNTAX_ERROR消息:您的SQL语法有错误;检查与您的MySQL服务器版本相对应的手册,以便使用正确的语法错误:1150SQLSTATE:()HY000ER_DELAYED_CANT_CHANGE_LOCK消息:延迟的插入线程无法获取对表%s的请求锁定错误:1151SQLSTATE:()HY000ER_TOO_MANY_DELAYED_THREADS消息:正在使用的延迟线程太多错误:1152SQLSTATE:()08S01ER_ABORTING_CONNECTION消息:中止连接%ld到db:'%s'用户:'%s'(%s)错误:1153SQLSTATE:()08S01ER_NET_PACKET_TOO_LARGE消息:得到比'max_allowed_packet'字节大的数据包错误:1154SQLSTATE:()08S01ER_NET_READ_ERROR_FROM_PIPE消息:来自连接管道的读取错误错误:1155SQLSTATE:()08S01ER_NET_FCNTL_ERROR消息:从fcntl()中得到一个错误错误:1156SQLSTATE:()08S01ER_NET_PACKETS_OUT_OF_ORDER消息:有数据包故障错误:1157SQLSTATE:()08S01ER_NET_UNCOMPRESS_ERROR消息:无法解压缩通信数据包错误:1158SQLSTATE:()08S01ER_NET_READ_ERROR消息:读取通信数据包时出错错误:1159SQLSTATE:()08S01ER_NET_READ_INTERRUPTED消息:超时读取通信数据包错误:1160SQLSTATE:()08S01ER_NET_ERROR_ON_WRITE消息:写入通信数据包时出错错误:1161SQLSTATE:()08S01ER_NET_WRITE_INTERRUPTED消息:得到超时写通信数据包错误:1162SQLSTATE:()42000ER_TOO_LONG_STRING消息:结果字符串比'max_allowed_packet'字节长错误:1163SQLSTATE:()42000ER_TABLE_CANT_HANDLE_BLOB消息:使用的表类型不支持BLOB/TEXT列错误:1164SQLSTATE:()42000ER_TABLE_CANT_HANDLE_AUTO_INCREMENT消息:使用的表类型不支持AUTO_INCREMENT列错误:1165SQLSTATE:()HY000ER_DELAYED_INSERT_TABLE_LOCKED消息:INSERTDELAYED不能与表'%s'一起使用,因为它被LOCKTABLES锁定错误:1166SQLSTATE:()42000ER_WRONG_COLUMN_NAME消息:错误的列名'%s'错误:1167SQLSTATE:()42000ER_WRONG_KEY_COLUMN消息:使用的存储引擎不能索引列'%s'错误:1168SQLSTATE:()HY000ER_WRONG_MRG_TABLE消息:无法打开不同定义的非基础表或非MyISAM类型或不存在的基础表错误:1169SQLSTATE:()23000ER_DUP_UNIQUE消息:由于唯一的约束,无法写入表'%s'错误:1170SQLSTATE:()42000ER_BLOB_KEY_WITHOUT_LENGTH消息:在没有密钥长度的密钥规范中使用的BLOB/TEXT列'%s'错误:1171SQLSTATE:()42000ER_PRIMARY_CANT_HAVE_NULL消息:PRIMARYKEY的所有部分必须是NOTNULL;如果你需要在一个键NULL,而不是使用UNIQUE错误:1172SQLSTATE:()42000ER_TOO_MANY_ROWS消息:结果由多行组成错误:1173SQLSTATE:()42000ER_REQUIRES_PRIMARY_KEY消息:此表类型需要主键错误:1174SQLSTATE:()HY000ER_NO_RAID_COMPILED消息:此版本的MySQL不支持RAID编译错误:1175SQLSTATE:()HY000ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE消息:您正在使用安全更新模式,并试图更新没有使用KEY列的WHERE表错误:1176SQLSTATE:()42000ER_KEY_DOES_NOT_EXITS消息:表'%s'中不存在键'%s'错误:1177SQLSTATE:()42000ER_CHECK_NO_SUCH_TABLE消息:无法打开表格错误:1178SQLSTATE:()42000ER_CHECK_NOT_IMPLEMENTED消息:该表的存储引擎不支持%s错误:1179SQLSTATE:()25000ER_CANT_DO_THIS_DURING_AN_TRANSACTION消息:您不能在事务中执行此命令错误:1180SQLSTATE:()HY000ER_ERROR_DURING_COMMIT消息:COMMIT期间出现错误%d错误:1181SQLSTATE:()HY000ER_ERROR_DURING_ROLLBACK消息:在ROLLBACK期间出现错误%d错误:1182SQLSTATE:()HY000ER_ERROR_DURING_FLUSH_LOGS消息:在FLUSH_LOGS期间出现错误%d错误:1183SQLSTATE:()HY000ER_ERROR_DURING_CHECKPOINT消息:CHECKPOINT期间出现错误%d错误:1184SQLSTATE:()08S01ER_NEW_ABORTING_CONNECTION消息:中止连接%ld到db:'%s'用户:'%s'主机:'%s'(%s)错误:1185SQLSTATE:()HY000ER_DUMP_NOT_IMPLEMENTED消息:表的存储引擎不支持二进制表转储错误:1186SQLSTATE:()HY000ER_FLUSH_MASTER_BINLOG_CLOSED消息:Binlog关闭,不能RESETMASTER错误:1187SQLSTATE:()HY000ER_INDEX_REBUILD消息:重建转储表'%s'的索引失败错误:1188SQLSTATE:()HY000ER_MASTER消息:来自主设备的错误:'%s'错误:1189SQLSTATE:()08S01ER_MASTER_NET_READ消息:从主站读取错误错误:1190SQLSTATE:()08S01ER_MASTER_NET_WRITE消息:写入主的网络错误错误:1191SQLSTATE:()HY000ER_FT_MATCHING_KEY_NOT_FOUND消息:无法找到匹配列列表的FULLTEXT索引错误:1192SQLSTATE:()HY000ER_LOCK_OR_ACTIVE_TRANSACTION消息:由于您拥有活动的锁定表或活动事务,因此无法执行给定的命令错误:1193SQLSTATE:()HY000ER_UNKNOWN_SYSTEM_VARIABLE消息:未知的系统变量'%s'错误:1194SQLSTATE:()HY000ER_CRASHED_ON_USAGE消息:表'%s'被标记为崩溃,应该修复错误:1195SQLSTATE:()HY000ER_CRASHED_ON_REPAIR消息:表'%s'被标记为崩溃,上次(自动?)修复失败错误:1196SQLSTATE:()HY000ER_WARNING_NOT_COMPLETE_ROLLBACK消息:一些非事务性更改的表无法回滚错误:1197SQLSTATE:()HY000ER_TRANS_CACHE_FULL消息:多语句事务需要超过“max_binlog_cache_size”字节的存储空间;增加这个mysqld变量,然后再试一次错误:1198SQLSTATE:()HY000ER_SLAVE_MUST_STOP消息:该操作不能用正在运行的从机执行;首先运行STOPSLAVE错误:1199SQLSTATE:()HY000ER_SLAVE_NOT_RUNNING消息:该操作需要一个正在运行的从站;配置slave,并执行STARTSLAVE错误:1200SQLSTATE:()HY000ER_BAD_SLAVE消息:服务器未配置为从站;修改配置文件或修改主机错误:1201SQLSTATE:()HY000ER_MASTER_INFO消息:无法初始化主信息结构;更多的错误信息可以在MySQL错误日志中找到错误:1202SQLSTATE:()HY000ER_SLAVE_THREAD消息:无法创建从属线程;检查系统资源错误:1203SQLSTATE:()42000ER_TOO_MANY_USER_CONNECTIONS消息:用户%s已经有多个“max_user_connections”活动连接错误:1204SQLSTATE:()HY000ER_SET_CONSTANTS_ONLY消息:您只能使用常量表达式错误:1205SQLSTATE:()HY000ER_LOCK_WAIT_TIMEOUT消息:超出锁定等待超时;尝试重新启动事务InnoDB在锁定等待超时到期时报告此错误。等待时间过长的陈述被回滚(不是整个交易)。innodb_lock_wait_timeout如果SQL语句应该等待更长的时间才能完成其他事务,那么可以增加配置选项的值;如果太多长时间运行的事务导致锁定问题并降低繁忙系统上的并发性,则可以减少该值。错误:1206SQLSTATE:()HY000ER_LOCK_TABLE_FULL消息:锁的总数超过锁表大小InnoDB当锁的总数超过专用于管理锁的内存量时报告此错误。为了避免这个错误,增加值innodb_buffer_pool_size。在个别应用程序中,解决方法可能是将大型操作分解为更小的部分。例如,如果错误发生的很大INSERT,执行几个较小的INSERT操作。错误:1207SQLSTATE:()25000ER_READ_ONLY_TRANSACTION消息:在READUNCOMMITTED事务期间无法获取更新锁错误:1208SQLSTATE:()HY000ER_DROP_DB_WITH_READ_LOCK消息:当线程持有全局读锁定时,DROPDATABASE不允许错误:1209SQLSTATE:()HY000ER_CREATE_DB_WITH_READ_LOCK消息:线程持有全局读取锁定时不允许CREATEDATABASE错误:1210SQLSTATE:()HY000ER_WRONG_ARGUMENTS消息:%s的参数不正确错误:1211SQLSTATE:()42000ER_NO_PERMISSION_TO_CREATE_USER消息:'%s'@'%s'不允许创建新用户错误:1212SQLSTATE:()HY000ER_UNION_TABLES_IN_DIFFERENT_DIR消息:表格定义不正确;所有的MERGE表必须在同一个数据库中错误:1213SQLSTATE:()40001ER_LOCK_DEADLOCK消息:尝试锁定时发现死锁;尝试重新启动事务InnoDB在事务遇到死锁时报告此错误,并自动回滚,以便您的应用程序可以采取纠正措施。要从此错误中恢复,请再次运行此事务中的所有操作。当锁的请求在事务之间以不一致的顺序到达时发生死锁。被回滚的事务释放了所有的锁,而另一个事务现在可以获得它所请求的所有锁。因此,当您重新运行回退的事务时,可能需要等待其他事务完成,但通常不会重复发生死锁。如果遇到频繁的死锁,请执行锁定操作的顺序(LOCKTABLES,SELECT...FORUPDATE等等)在遇到问题的不同事务或应用程序之间一致。有关详细信息,请参见第14.5.5节“InnoDB中的死锁”。错误:1214SQLSTATE:()HY000ER_TABLE_CANT_HANDLE_FT消息:使用的表类型不支持FULLTEXT索引错误:1215SQLSTATE:()HY000ER_CANNOT_ADD_FOREIGN消息:无法添加外键约束错误:1216SQLSTATE:()23000ER_NO_REFERENCED_ROW消息:无法添加或更新子行:外键约束失败InnoDB当您尝试添加一行但报告没有父行,并且外键约束失败时报告此错误。首先添加父行。错误:1217SQLSTATE:()23000ER_ROW_IS_REFERENCED消息:无法删除或更新父行:外键约束失败InnoDB当您尝试删除具有子级别的父行,并且外键约束失败时报告此错误。先删除孩子。错误:1218SQLSTATE:()08S01ER_CONNECT_TO_MASTER消息:连接到主设备时出错:%s错误:1219SQLSTATE:()HY000ER_QUERY_ON_MASTER消息:在主服务器上运行查询时出错:%s错误:1220SQLSTATE:()HY000ER_ERROR_WHEN_EXECUTING_COMMAND消息:执行命令%s时出错:%s错误:1221SQLSTATE:()HY000ER_WRONG_USAGE消息:%s和%s的使用不正确错误:1222SQLSTATE:()21000ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT消息:使用的SELECT语句具有不同数量的列错误:1223SQLSTATE:()HY000ER_CANT_UPDATE_WITH_READLOCK消息:由于读取锁有冲突,无法执行查询错误:1224SQLSTATE:()HY000ER_MIXING_NOT_ALLOWED消息:事务性和非事务性表的混合被禁用错误:1225SQLSTATE:()HY000ER_DUP_ARGUMENT消息:选项'%s'在语句中使用了两次错误:1226SQLSTATE:()42000ER_USER_LIMIT_REACHED消息:用户'%s'已超过'%s'资源(当前值:%ld)错误:1227SQLSTATE:()42000ER_SPECIFIC_ACCESS_DENIED_ERROR消息:访问被拒绝;您需要(至少有一个)%s权限(s)用于此操作错误:1228SQLSTATE:()HY000ER_LOCAL_VARIABLE消息:变量'%s'是一个SESSION变量,不能与SETGLOBAL一起使用错误:1229SQLSTATE:()HY000ER_GLOBAL_VARIABLE消息:变量'%s'是一个GLOBAL变量,应该用SETGLOBAL来设置错误:1230SQLSTATE:()42000ER_NO_DEFAULT消息:变量“%s”没有默认值错误:1231SQLSTATE:()42000ER_WRONG_VALUE_FOR_VAR消息:变量'%s'不能被设置为'%s'的值错误:1232SQLSTATE:()42000ER_WRONG_TYPE_FOR_VAR消息:变量'%s'的参数类型不正确错误:1233SQLSTATE:()HY000ER_VAR_CANT_BE_READ消息:只能设置变量'%s',不能读取错误:1234SQLSTATE:()42000ER_CANT_USE_OPTION_HERE消息:'%s'的错误使用/位置错误:1235SQLSTATE:()42000ER_NOT_SUPPORTED_YET消息:这个版本的MySQL尚不支持'%s'错误:1236SQLSTATE:()HY000ER_MASTER_FATAL_ERROR_READING_BINLOG消息:从二进制日志读取数据时,主机发现致命错误%d:'%s'错误:1237SQLSTATE:()HY000ER_SLAVE_IGNORED_TABLE消息:由于复制-*-表规则,从属SQL线程忽略该查询错误:1238SQLSTATE:()HY000ER_INCORRECT_GLOBAL_LOCAL_VAR消息:变量'%s'是%s变量错误:1239SQLSTATE:()42000ER_WRONG_FK_DEF消息:“%s”的外键定义不正确:%s错误:1240SQLSTATE:()HY000ER_KEY_REF_DO_NOT_MATCH_TABLE_REF消息:键引用和表引用不匹配错误:1241SQLSTATE:()21000ER_OPERAND_COLUMNS消息:操作数应该包含%d列(s)错误:1242SQLSTATE:()21000ER_SUBQUERY_NO_1_ROW消息:子查询返回多于一行错误:1243SQLSTATE:()HY000ER_UNKNOWN_STMT_HANDLER消息:未知的准备好的语句处理程序(%。*s)给予%s错误:1244SQLSTATE:()HY000ER_CORRUPT_HELP_DB消息:帮助数据库已损坏或不存在错误:1245SQLSTATE:()HY000ER_CYCLIC_REFERENCE消息:子查询上的循环引用错误:1246SQLSTATE:()HY000ER_AUTO_CONVERT消息:将列'%s'从%s转换为%s错误:1247SQLSTATE:()42S22ER_ILLEGAL_REFERENCE消息:不支持引用“%s”(%s)错误:1248SQLSTATE:()42000ER_DERIVED_MUST_HAVE_ALIAS消息:每个派生表都必须有自己的别名错误:1249SQLSTATE:()01000ER_SELECT_REDUCED消息:选择%u在优化期间减少错误:1250SQLSTATE:()42000ER_TABLENAME_NOT_ALLOWED_HERE消息:来自其中一个SELECT的表'%s'不能在%s中使用错误:1251SQLSTATE:()08004ER_NOT_SUPPORTED_AUTH_MODE消息:客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端错误:1252SQLSTATE:()42000ER_SPATIAL_CANT_HAVE_NULL消息:SPATIAL索引的所有部分必须是NOTNULL错误:1253SQLSTATE:()42000ER_COLLATION_CHARSET_MISMATCH消息:COLLATION'%s'对于CHARACTERSET'%s'无效错误:1254SQLSTATE:()HY000ER_SLAVE_WAS_RUNNING消息:从站已经在运行错误:1255SQLSTATE:()HY000ER_SLAVE_WAS_NOT_RUNNING消息:从站已经停止错误:1256SQLSTATE:()HY000ER_TOO_BIG_FOR_UNCOMPRESS消息:未压缩的数据量太大;最大尺寸是%d(可能未压缩的数据长度已损坏)错误:1257SQLSTATE:()HY000ER_ZLIB_Z_MEM_ERROR消息:ZLIB:内存不足错误:1258SQLSTATE:()HY000ER_ZLIB_Z_BUF_ERROR消息:ZLIB:输出缓冲区中没有足够的空间(可能长度未压缩的数据已损坏)错误:1259SQLSTATE:()HY000ER_ZLIB_Z_DATA_ERROR消息:ZLIB:输入数据损坏错误:1260SQLSTATE:()HY000ER_CUT_VALUE_GROUP_CONCAT消息:行%u被GROUP_CONCAT()剪切错误:1261SQLSTATE:()01000ER_WARN_TOO_FEW_RECORDS消息:行%ld不包含所有列的数据错误:1262SQLSTATE:()01000ER_WARN_TOO_MANY_RECORDS消息:行%ld被截断;它包含比输入列更多的数据错误:1263SQLSTATE:()22004ER_WARN_NULL_TO_NOTNULL消息:列设置为默认值;在行%ld处将NULL提供给NOTNULL列'%s'错误:1264SQLSTATE:()22003ER_WARN_DATA_OUT_OF_RANGE消息:列%1d的列'%s'超出范围值错误:1265SQLSTATE:()01000WARN_DATA_TRUNCATED消息:数据在%ld行的列'%s'被截断错误:1266SQLSTATE:()HY000ER_WARN_USING_OTHER_HANDLER消息:对表'%s'使用存储引擎%s错误:1267SQLSTATE:()HY000ER_CANT_AGGREGATE_2COLLATIONS消息:操作'%s'非法混合整理(%s,%s)和(%s,%s)错误:1268SQLSTATE:()HY000ER_DROP_USER消息:不能删除一个或多个请求的用户错误:1269SQLSTATE:()HY000ER_REVOKE_GRANTS消息:无法撤销一个或多个请求的用户的所有权限错误:1270SQLSTATE:()HY000ER_CANT_AGGREGATE_3COLLATIONS消息:操作'%s'非法混合整理(%s,%s),(%s,%s),(%s,%s)错误:1271SQLSTATE:()HY000ER_CANT_AGGREGATE_NCOLLATIONS消息:操作“%s”的排序规则非法混合错误:1272SQLSTATE:()HY000ER_VARIABLE_IS_NOT_STRUCT消息:变量'%s'不是一个变量组件(不能用作XXXX.variable_name)错误:1273SQLSTATE:()HY000ER_UNKNOWN_COLLATION消息:未知整理:'%s'错误:1274SQLSTATE:()HY000ER_SLAVE_IGNORED_SSL_PARAMS消息:CHANGEMASTER中的SSL参数被忽略,因为此MySQL从站编译时没有SSL支持;如果启动了带有SSL的MySQL从站,则可以稍后使用它们错误:1275SQLSTATE:()HY000ER_SERVER_IS_IN_SECURE_AUTH_MODE消息:服务器以--secure-auth模式运行,但'%s'@'%s'具有旧格式的密码;请将密码更改为新的格式错误:1276SQLSTATE:()HY000ER_WARN_FIELD_RESOLVED消息:SELECT#%d中的字段或引用“%s%s%s%s%s”已在SELECT#%d中解析错误:1277SQLSTATE:()HY000ER_BAD_SLAVE_UNTIL_COND消息:STARTSLAVEUNTIL的参数或参数组合不正确错误:1278SQLSTATE:()HY000ER_MISSING_SKIP_SLAVE消息:建议在使用STARTSLAVEUNTIL进行分步复制时使用--skip-slave-start;否则,如果出现意外的从服务器的mysqld重启,你将会遇到问题错误:1279SQLSTATE:()HY000ER_UNTIL_COND_IGNORED消息:SQL线程不会被启动,所以UNTIL选项被忽略错误:1280SQLSTATE:()42000ER_WRONG_NAME_FOR_INDEX消息:不正确的索引名称'%s'错误:1281SQLSTATE:()42000ER_WRONG_NAME_FOR_CATALOG消息:错误的目录名称'%s'错误:1282SQLSTATE:()HY000ER_WARN_QC_RESIZE消息:查询缓存未能设置大小%lu;新的查询缓存大小是%lu错误:1283SQLSTATE:()HY000ER_BAD_FT_COLUMN消息:列'%s'不能成为FULLTEXT索引的一部分错误:1284SQLSTATE:()HY000ER_UNKNOWN_KEY_CACHE消息:未知的键缓存“%s”错误:1285SQLSTATE:()HY000ER_WARN_HOSTNAME_WONT_WORK消息:MySQL以--skip-name-resolve模式启动;你必须重新启动它,而不用这个开关来让这个授权工作错误:1286SQLSTATE:()42000ER_UNKNOWN_STORAGE_ENGINE消息:未知存储引擎“%s”错误:1287SQLSTATE:()HY000ER_WARN_DEPRECATED_SYNTAX消息:'%s'已被弃用,并将在未来版本中删除。请使用%s代替错误:1288SQLSTATE:()HY000ER_NON_UPDATABLE_TABLE消息:%s的目标表%s不可更新错误:1289SQLSTATE:()HY000ER_FEATURE_DISABLED消息:“%s”功能已禁用。你需要使用'%s'构建的MySQL才能正常工作错误:1290SQLSTATE:()HY000ER_OPTION_PREVENTS_STATEMENT消息:MySQL服务器正在运行%s选项,所以它不能执行这个语句错误:1291SQLSTATE:()HY000ER_DUPLICATED_VALUE_IN_TYPE消息:列'%s'在%s中重复了值'%s'错误:1292SQLSTATE:()22007ER_TRUNCATED_WRONG_VALUE消息:截断不正确的%s值:'%s'错误:1293SQLSTATE:()HY000ER_TOO_MUCH_AUTO_TIMESTAMP_COLS消息:表格定义不正确;在DEFAULT或ONUPDATE子句中只能有一个TIMESTAMP列和CURRENT_TIMESTAMP错误:1294SQLSTATE:()HY000ER_INVALID_ON_UPDATE消息:'%s'列的ONUPDATE子句无效错误:1295SQLSTATE:()HY000ER_UNSUPPORTED_PS消息:尚未在预准备语句协议中支持此命令错误:1296SQLSTATE:()HY000ER_GET_ERRMSG讯息:从%s收到错误%d'%s'错误:1297SQLSTATE:()HY000ER_GET_TEMPORARY_ERRMSG讯息:从%s获得暂时错误%d'%s'错误:1298SQLSTATE:()HY000ER_UNKNOWN_TIME_ZONE消息:未知或不正确的时区:'%s'错误:1299SQLSTATE:()HY000ER_WARN_INVALID_TIMESTAMP消息:行%1d的列'%s'中的TIMESTAMP值无效错误:1300SQLSTATE:()HY000ER_INVALID_CHARACTER_STRING消息:无效的%s字符串:'%s'错误:1301SQLSTATE:()HY000ER_WARN_ALLOWED_PACKET_OVERFLOWED消息:%s()的结果大于max_allowed_packet(%ld)-截断错误:1302SQLSTATE:()HY000ER_CONFLICTING_DECLARATIONS消息:冲突声明:'%s%s'和'%s%s'错误:1303SQLSTATE:()2F003ER_SP_NO_RECURSIVE_CREATE消息:无法在另一个存储例程中创建%s错误:1304SQLSTATE:()42000ER_SP_ALREADY_EXISTS消息:%s%s已经存在错误:1305SQLSTATE:()42000ER_SP_DOES_NOT_EXIST消息:%s%s不存在错误:1306SQLSTATE:()HY000ER_SP_DROP_FAILED消息:无法删除%s%s错误:1307SQLSTATE:()HY000ER_SP_STORE_FAILED消息:无法创建%s%s错误:1308SQLSTATE:()42000ER_SP_LILABEL_MISMATCH消息:%s没有匹配的标签:%s错误:1309SQLSTATE:()42000ER_SP_LABEL_REDEFINE消息:重新定义标签%s错误:1310SQLSTATE:()42000ER_SP_LABEL_MISMATCH消息:结束标签%s不匹配错误:1311SQLSTATE:()01000ER_SP_UNINIT_VAR消息:引用未初始化的变量%s错误:1312SQLSTATE:()0A000ER_SP_BADSELECT消息:PROCEDURE%s不能返回给定上下文中的结果集错误:1313SQLSTATE:()42000ER_SP_BADRETURN消息:RETURN仅在函数中允许错误:1314SQLSTATE:()0A000ER_SP_BADSTATEMENT消息:存储过程中不允许使用%s错误:1315SQLSTATE:()42000ER_UPDATE_LOG_DEPRECATED_IGNORED消息:更新日志已弃用,并由二进制日志替换;SETSQL_LOG_UPDATE已被忽略。错误:1316SQLSTATE:()42000ER_UPDATE_LOG_DEPRECATED_TRANSLATED消息:更新日志已弃用,并由二进制日志替换;SETSQL_LOG_UPDATE已被转换为SETSQL_LOG_BIN。错误:1317SQLSTATE:()70100ER_QUERY_INTERRUPTED消息:查询执行中断错误:1318SQLSTATE:()42000ER_SP_WRONG_NO_OF_ARGS消息:%s%s的参数数量不正确;预期%u,得到%u错误:1319SQLSTATE:()42000ER_SP_COND_MISMATCH消息:未定义条件:%s错误:1320SQLSTATE:()42000ER_SP_NORETURN消息:在FUNCTION%s中找不到RETURN错误:1321SQLSTATE:()2F005ER_SP_NORETURNEND消息:FUNCTION%s没有返回而结束错误:1322SQLSTATE:()42000ER_SP_BAD_CURSOR_QUERY消息:游标语句必须是SELECT错误:1323SQLSTATE:()42000ER_SP_BAD_CURSOR_SELECT消息:游标SELECT不能有INTO错误:1324SQLSTATE:()42000ER_SP_CURSOR_MISMATCH消息:未定义CURSOR:%s错误:1325SQLSTATE:()24000ER_SP_CURSOR_ALREADY_OPEN消息:光标已经打开错误:1326SQLSTATE:()24000ER_SP_CURSOR_NOT_OPEN消息:光标未打开错误:1327SQLSTATE:()42000ER_SP_UNDECLARED_VAR消息:未声明的变量:%s错误:1328SQLSTATE:()HY000ER_SP_WRONG_NO_OF_FETCH_ARGS消息:FETCH变量的数量不正确错误:1329SQLSTATE:()02000ER_SP_FETCH_NO_DATA消息:没有数据-获取,选择或处理零行错误:1330SQLSTATE:()42000ER_SP_DUP_PARAM消息:重复参数:%s错误:1331SQLSTATE:()42000ER_SP_DUP_VAR消息:重复的变量:%s错误:1332SQLSTATE:()42000ER_SP_DUP_COND消息:重复的情况:%s错误:1333SQLSTATE:()42000ER_SP_DUP_CURS消息:复制游标:%s错误:1334SQLSTATE:()HY000ER_SP_CANT_ALTER消息:无法更改%s%s错误:1335SQLSTATE:()0A000ER_SP_SUBSELECT_NYI消息:不支持子查询值错误:1336SQLSTATE:()0A000ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG消息:存储的函数或触发器中不允许使用%s错误:1337SQLSTATE:()42000ER_SP_VARCOND_AFTER_CURSHNDLR消息:游标或处理程序声明后的变量或条件声明错误:1338SQLSTATE:()42000ER_SP_CURSOR_AFTER_HANDLER消息:处理程序声明后的光标声明错误:1339SQLSTATE:()20000ER_SP_CASE_NOT_FOUND消息:CASE语句未找到大小写错误:1340SQLSTATE:()HY000ER_FPARSER_TOO_BIG_FILE消息:配置文件'%s'太大错误:1341SQLSTATE:()HY000ER_FPARSER_BAD_HEADER消息:文件'%s'中格式错误的文件类型头错误:1342SQLSTATE:()HY000ER_FPARSER_EOF_IN_COMMENT消息:解析注释'%s'时意外的文件结束错误:1343SQLSTATE:()HY000ER_FPARSER_ERROR_IN_PARAMETER消息:解析参数'%s'时出错(行:'%s')错误:1344SQLSTATE:()HY000ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER消息:跳过未知参数'%s'的文件意外结束错误:1345SQLSTATE:()HY000ER_VIEW_NO_EXPLAIN消息:EXPLAIN/SHOW无法发布;缺乏底层表的特权错误:1346SQLSTATE:()HY000ER_FRM_UNKNOWN_TYPE消息:文件'%s'的标题中包含未知类型'%s'错误:1347SQLSTATE:()HY000ER_WRONG_OBJECT消息:'%s。%s'不是%s指定的对象对于尝试的操作类型不正确。它必须是指定类型的对象。错误:1348SQLSTATE:()HY000ER_NONUPDATEABLE_COLUMN消息:列'%s'不可更新错误:1349SQLSTATE:()HY000ER_VIEW_SELECT_DERIVED消息:视图的SELECT在FROM子句中包含一个子查询错误:1350SQLSTATE:()HY000ER_VIEW_SELECT_CLAUSE消息:视图的SELECT包含'%s'子句错误:1351SQLSTATE:()HY000ER_VIEW_SELECT_VARIABLE消息:视图的SELECT包含一个变量或参数错误:1352SQLSTATE:()HY000ER_VIEW_SELECT_TMPTABLE消息:视图的SELECT引用临时表'%s'错误:1353SQLSTATE:()HY000ER_VIEW_WRONG_LIST消息:视图的SELECT和视图的字段列表具有不同的列数错误:1354SQLSTATE:()HY000ER_WARN_VIEW_MERGE消息:现在不能使用视图合并算法(假定未定义的算法)错误:1355SQLSTATE:()HY000ER_WARN_VIEW_WITHOUT_KEY消息:正在更新的视图不具有基础表的完整密钥错误:1356SQLSTATE:()HY000ER_VIEW_INVALID消息:查看'%s。%s'引用无效的表或列或函数或定义者/调用者没有权利使用它们错误:1357SQLSTATE:()HY000ER_SP_NO_DROP_SP消息:不能从另一个存储的例程中删除或修改%s错误:1358SQLSTATE:()HY000ER_SP_GOTO_IN_HNDLR消息:在存储过程处理程序中不允许使用GOTO错误:1359SQLSTATE:()HY000ER_TRG_ALREADY_EXISTS消息:触发器已经存在错误:1360SQLSTATE:()HY000ER_TRG_DOES_NOT_EXIST消息:触发器不存在错误:1361SQLSTATE:()HY000ER_TRG_ON_VIEW_OR_TEMP_TABLE消息:触发器的'%s'是视图或临时表错误:1362SQLSTATE:()HY000ER_TRG_CANT_CHANGE_ROW消息:%strigger中不允许更新%s行错误:1363SQLSTATE:()HY000ER_TRG_NO_SUCH_ROW_IN_TRG消息:%s触发器中没有%s行错误:1364SQLSTATE:()HY000ER_NO_DEFAULT_FOR_FIELD消息:字段'%s'没有默认值错误:1365SQLSTATE:()22012ER_DIVISION_BY_ZERO消息:由0划分错误:1366SQLSTATE:()HY000ER_TRUNCATED_WRONG_VALUE_FOR_FIELD消息:错误的%s值:'%s'列'%s'在行%ld处错误:1367SQLSTATE:()22007ER_ILLEGAL_VALUE_FOR_TYPE消息:在解析过程中发现非法的%s'%s'值错误:1368SQLSTATE:()HY000ER_VIEW_NONUPD_CHECK消息:在不可更新视图'%s。%s'上检查选项错误:1369SQLSTATE:()HY000ER_VIEW_CHECK_FAILED消息:检查选项失败'%s。%s'错误:1370SQLSTATE:()42000ER_PROCACCESS_DENIED_ERROR消息:%s命令被拒绝给用户'%s'@'%s'用于例程'%s'错误:1371SQLSTATE:()HY000ER_RELAY_LOG_FAIL消息:清除旧的中继日志失败:%s错误:1372SQLSTATE:()HY000ER_PASSWD_LENGTH消息:密码哈希应该是%d位十六进制数字错误:1373SQLSTATE:()HY000ER_UNKNOWN_TARGET_BINLOG消息:在binlog索引中找不到目标日志错误:1374SQLSTATE:()HY000ER_IO_ERR_LOG_INDEX_READ消息:读取日志索引文件的I/O错误错误:1375SQLSTATE:()HY000ER_BINLOG_PURGE_PROHIBITED消息:服务器配置不允许binlog清除错误:1376SQLSTATE:()HY000ER_FSEEK_FAIL消息:在fseek()上失败错误:1377SQLSTATE:()HY000ER_BINLOG_PURGE_FATAL_ERR消息:日志清除期间发生致命错误错误:1378SQLSTATE:()HY000ER_LOG_IN_USE消息:可清除日志正在使用中,不会清除错误:1379SQLSTATE:()HY000ER_LOG_PURGE_UNKNOWN_ERR消息:日志清除期间发生未知错误错误:1380SQLSTATE:()HY000ER_RELAY_LOG_INIT消息:初始化中继日志位置失败:%s错误:1381SQLSTATE:()HY000ER_NO_BINARY_LOGGING消息:您没有使用二进制日志记录错误:1382SQLSTATE:()HY000ER_RESERVED_SYNTAX消息:'%s'语法被保留用于MySQL服务器内部的目的错误:1383SQLSTATE:()HY000ER_WSAS_FAILED消息:WSAStartup失败错误:1384SQLSTATE:()HY000ER_DIFF_GROUPS_PROC消息:无法处理不同组别的程序错误:1385SQLSTATE:()HY000ER_NO_GROUP_FOR_PROC消息:选择必须具有此程序的组错误:1386SQLSTATE:()HY000ER_ORDER_WITH_PROC消息:不能使用此过程的ORDER子句错误:1387SQLSTATE:()HY000ER_LOGGING_PROHIBIT_CHANGING_OF消息:二进制日志记录和复制禁止更改全局服务器%s错误:1388SQLSTATE:()HY000ER_NO_FILE_MAPPING消息:无法映射文件:%s,errno:%d错误:1389SQLSTATE:()HY000ER_WRONG_MAGIC信息:%s中有错误的魔法错误:1390SQLSTATE:()HY000ER_PS_MANY_PARAM消息:Prepared语句包含太多的占位符错误:1391SQLSTATE:()HY000ER_KEY_PART_0消息:关键部分“%s”长度不能为0错误:1392SQLSTATE:()HY000ER_VIEW_CHECKSUM消息:查看文本校验和失败错误:1393SQLSTATE:()HY000ER_VIEW_MULTIUPDATE消息:无法通过连接视图“%s。%s”修改多个基表错误:1394SQLSTATE:()HY000ER_VIEW_NO_INSERT_FIELD_LIST消息:无法插入连接视图'%s。%s'没有字段列表错误:1395SQLSTATE:()HY000ER_VIEW_DELETE_MERGE_VIEW消息:无法从联接视图'%s。%s'中删除错误:1396SQLSTATE:()HY000ER_CANNOT_USER消息:%s操作%s失败错误:1397SQLSTATE:()XAE04ER_XAER_NOTA消息:XAER_NOTA:未知的XID错误:1398SQLSTATE:()XAE05ER_XAER_INVAL消息:XAER_INVAL:无效的参数(或不支持的命令)错误:1399SQLSTATE:()XAE07ER_XAER_RMFAIL消息:XAER_RMFAIL:当全局事务处于%s状态时,命令无法执行错误:1400SQLSTATE:()XAE09ER_XAER_OUTSIDE消息:XAER_OUTSIDE:有些工作是在全局事务之外完成的错误:1401SQLSTATE:()XAE03ER_XAER_RMERR消息:XAER_RMERR:事务分支中发生致命错误-检查数据的一致性错误:1402SQLSTATE:()XA100ER_XA_RBROLLBACK消息:XA_RBROLLBACK:事务分支被回滚错误:1403SQLSTATE:()42000ER_NONEXISTING_PROC_GRANT消息:在例程'%s'的主机'%s'上没有为用户'%s'定义的此类授权。错误:1404SQLSTATE:()HY000ER_PROC_AUTO_GRANT_FAIL消息:无法授予EXECUTE和ALTERROUTINE权限错误:1405SQLSTATE:()HY000ER_PROC_AUTO_REVOKE_FAIL消息:无法撤销所有放弃例程的特权错误:1406SQLSTATE:()22001ER_DATA_TOO_LONG消息:行%1d处的列'%s'的数据太长错误:1407SQLSTATE:()42000ER_SP_BAD_SQLSTATE消息:错误的SQLSTATE:'%s'错误:1408SQLSTATE:()HY000ER_STARTUP消息:%s:准备好连接。版本:'%s'套接字:'%s'端口:%d%s错误:1409SQLSTATE:()HY000ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR消息:无法从具有固定大小的行的文件加载值到变量错误:1410SQLSTATE:()42000ER_CANT_CREATE_USER_WITH_GRANT消息:您不能使用GRANT创建用户错误:1411SQLSTATE:()HY000ER_WRONG_VALUE_FOR_TYPE消息:函数%s不正确的%s值:'%s'错误:1412SQLSTATE:()HY000ER_TABLE_DEF_CHANGED消息:表定义已更改,请重试事务错误:1413SQLSTATE:()42000ER_SP_DUP_HANDLER消息:在同一个块中声明的重复处理程序错误:1414SQLSTATE:()42000ER_SP_NOT_VAR_ARG消息:例程%s的OUT或INOUT参数%d不是BEFORE触发器中的变量或NEW伪变量错误:1415SQLSTATE:()0A000ER_SP_NO_RETSET消息:不允许从%s返回结果集错误:1416SQLSTATE:()22003ER_CANT_CREATE_GEOMETRY_OBJECT消息:无法从发送到GEOMETRY字段的数据获取几何对象错误:1417SQLSTATE:()HY000ER_FAILED_ROUTINE_BREAK_BINLOG消息:例程失败,在其声明中没有NOSQL和READSSQLDATA,二进制日志记录已启用;如果更新了非事务性表,那么二进制日志将会错过其更改错误:1418SQLSTATE:()HY000ER_BINLOG_UNSAFE_ROUTINE消息:此函数在其声明中没有DETERMINISTIC,NOSQL或READSSQLDATA,并且启用二进制日志记录(您可能希望使用不×××全的log_bin_trust_function_creators变量)错误:1419SQLSTATE:()HY000ER_BINLOG_CREATE_ROUTINE_NEED_SUPER消息:您没有SUPER权限并启用了二进制日志记录(您可能希望使用不×××全的log_bin_trust_function_creators变量)错误:1420SQLSTATE:()HY000ER_EXEC_STMT_WITH_OPEN_CURSOR消息:您不能执行一个打开的与其关联的光标的语句。重置语句以重新执行它。错误:1421SQLSTATE:()HY000ER_STMT_HAS_NO_OPEN_CURSOR消息:语句(%lu)没有打开的游标。错误:1422SQLSTATE:()HY000ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG消息:存储的函数或触发器中不允许显式或隐式提交。错误:1423SQLSTATE:()HY000ER_NO_DEFAULT_FOR_VIEW_FIELD消息:视图'%s。%s'的基础表没有默认值错误:1424SQLSTATE:()HY000ER_SP_NO_RECURSION消息:递归存储的函数和触发器是不允许的。错误:1425SQLSTATE:()42000ER_TOO_BIG_SCALE消息:为列'%s'指定了太大的比例%d。最大值是%lu。错误:1426SQLSTATE:()42000ER_TOO_BIG_PRECISION消息:为列'%s'指定的精确度%d太大。最大值是%lu。错误:1427SQLSTATE:()42000ER_M_BIGGER_THAN_D消息:对于浮点(M,D),双精度(M,D)或十进制(M,D),M必须>=D(列'%s')。错误:1428SQLSTATE:()HY000ER_WRONG_LOCK_OF_SYSTEM_TABLE消息:您不能将系统表的写入锁定与其他表或锁定类型组合在一起错误:1429SQLSTATE:()HY000ER_CONNECT_TO_FOREIGN_DATA_SOURCE消息:无法连接到外部数据源:%s错误:1430SQLSTATE:()HY000ER_QUERY_ON_FOREIGN_DATA_SOURCE消息:在处理外部数据源上的查询时出现问题。数据源错误:%s错误:1431SQLSTATE:()HY000ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST消息:您尝试引用的外部数据源不存在。数据源错误:%s错误:1432SQLSTATE:()HY000ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE消息:无法创建联合表。数据源连接字符串“%s”格式不正确错误:1433SQLSTATE:()HY000ER_FOREIGN_DATA_STRING_INVALID消息:数据源连接字符串“%s”格式不正确错误:1434SQLSTATE:()HY000ER_CANT_CREATE_FEDERATED_TABLE消息:无法创建联合表。国外数据src错误:%s错误:1435SQLSTATE:()HY000ER_TRG_IN_WRONG_SCHEMA消息:触发错误的模式错误:1436SQLSTATE:()HY000ER_STACK_OVERRUN_NEED_MORE消息:线程堆栈溢出:%ld字节堆栈使用%ld个字节,需要使用%ld个字节。使用'mysqld--thread_stack=#'指定一个更大的堆栈。错误:1437SQLSTATE:()42000ER_TOO_LONG_BODY消息:'%s'的例程太长错误:1438SQLSTATE:()HY000ER_WARN_CANT_DROP_DEFAULT_KEYCACHE消息:不能删除默认的keycache错误:1439SQLSTATE:()42000ER_TOO_BIG_DISPLAYWIDTH消息:列'%s'的显示宽度超出范围(最大=%lu)错误:1440SQLSTATE:()XAE08ER_XAER_DUPID消息:XAER_DUPID:XID已经存在错误:1441SQLSTATE:()22008ER_DATETIME_FUNCTION_OVERFLOW消息:日期时间函数:%s字段溢出错误:1442SQLSTATE:()HY000ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG消息:无法更新存储的函数/触发器中的表'%s',因为已经被调用此存储函数/触发器的语句使用。错误:1443SQLSTATE:()HY000ER_VIEW_PREVENT_UPDATE消息:表'%s'的定义阻止表'%s'上的操作%s。错误:1444SQLSTATE:()HY000ER_PS_NO_RECURSION消息:准备好的语句包含一个存储的例程调用,引用同一个语句。不能以这种递归的方式执行一个准备好的语句错误:1445SQLSTATE:()HY000ER_SP_CANT_SET_AUTOCOMMIT消息:不允许从存储的函数或触发器中设置自动提交错误:1446SQLSTATE:()HY000ER_MALFORMED_DEFINER消息:定义者不完全合格错误:1447SQLSTATE:()HY000ER_VIEW_FRM_NO_USER消息:查看“%s”,“%s”没有定义者信息(旧表格式)。当前用户被用作定义者。请重新创建视图!错误:1448SQLSTATE:()HY000ER_VIEW_OTHER_USER消息:您需要使用'%s'@'%s'定义者的创建视图的SUPER权限错误:1449SQLSTATE:()HY000ER_NO_SUCH_USER消息:指定为定义者('%s'@'%s')的用户不存在错误:1450SQLSTATE:()HY000ER_FORBID_SCHEMA_CHANGE消息:不允许将模式从“%s”更改为“%s”。错误:1451SQLSTATE:()23000ER_ROW_IS_REFERENCED_2消息:无法删除或更新父行:外键约束失败(%s)错误:1452SQLSTATE:()23000ER_NO_REFERENCED_ROW_2消息:无法添加或更新子行:外键约束失败(%s)错误:1453SQLSTATE:()42000ER_SP_BAD_VAR_SHADOW消息:变量'%s'必须用`...`引用,或者重命名错误:1454SQLSTATE:()HY000ER_TRG_NO_DEFINER消息:触发器'%s'没有定义者属性'%s'。触发器将在调用者的授权下被激活,其可能没有足够的权限。请重新创建触发器。错误:1455SQLSTATE:()HY000ER_OLD_FILE_FORMAT消息:'%s'具有旧格式,您应该重新创建'%s'对象错误:1456SQLSTATE:()HY000ER_SP_RECURSION_LIMIT消息:例程%s超出了递归限制%d(由max_sp_recursion_depth变量设置)错误:1457SQLSTATE:()HY000ER_SP_PROC_TABLE_CORRUPT消息:无法加载例程%s。表mysql.proc丢失,损坏或包含错误的数据(内部代码%d)错误:1458SQLSTATE:()42000ER_SP_WRONG_NAME消息:错误的例程名称'%s'错误:1459SQLSTATE:()HY000ER_TABLE_NEEDS_UPGRADE消息:需要进行表升级。请执行“REPAIRTABLE`%s`”或转储/重新加载来修复它!错误:1460SQLSTATE:()42000ER_SP_NO_AGGREGATE消息:AGGREGATE不支持存储的功能错误:1461SQLSTATE:()42000ER_MAX_PREPARED_STMT_COUNT_REACHED消息:无法创建超过max_prepared_stmt_count语句(当前值:%lu)错误:1462SQLSTATE:()HY000ER_VIEW_RECURSIVE消息:`%s`.`%s`包含视图递归错误:1463SQLSTATE:()42000ER_NON_GROUPING_FIELD_USED消息:在%s子句中使用非分组字段'%s'错误:1464SQLSTATE:()HY000ER_TABLE_CANT_HANDLE_SPKEYS消息:使用的表类型不支持SPATIAL索引错误:1465SQLSTATE:()HY000ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA消息:触发器不能在系统表上创建错误:1466SQLSTATE:()HY000ER_REMOVED_SPACES消息:从名称'%s'中删除前导空格错误:1467SQLSTATE:()HY000ER_AUTOINC_READ_FAILED消息:无法从存储引擎读取自动增量值错误:1468SQLSTATE:()HY000ER_USERNAME消息:用户名错误:1469SQLSTATE:()HY000ER_HOSTNAME消息:主机名称错误:1470SQLSTATE:()HY000ER_WRONG_STRING_LENGTH消息:字符串'%s'对%s来说太长了(应该不会超过%d)错误:1471SQLSTATE:()HY000ER_NON_INSERTABLE_TABLE消息:%s的目标表%s不可插入错误:1472SQLSTATE:()HY000ER_ADMIN_WRONG_MRG_TABLE消息:表'%s'是不同的定义或非MyISAM类型或不存在错误:1473SQLSTATE:()HY000ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT消息:选择的嵌套层级太高错误:1474SQLSTATE:()HY000ER_NAME_BECOMES_EMPTY讯息:名称'%s'已成为''错误:1475SQLSTATE:()HY000ER_AMBIGUOUS_FIELD_TERM消息:FIELDSTERMINATED字符串的第一个字符不明确;请使用非可选和非空的FIELDSENCLOSEDBY错误:1476SQLSTATE:()HY000ER_FOREIGN_SERVER_EXISTS消息:您尝试创建的外部服务器%s已经存在。错误:1477SQLSTATE:()HY000ER_FOREIGN_SERVER_DOESNT_EXIST消息:您试图引用的外部服务器名称不存在。数据源错误:%s错误:1478SQLSTATE:()HY000ER_ILLEGAL_HA_CREATE_OPTION消息:表存储引擎“%s”不支持创建选项“%s”错误:1479SQLSTATE:()HY000ER_PARTITION_REQUIRES_VALUES_ERROR消息:语法错误:%sPARTITIONING需要为每个分区定义VALUES%s错误:1480SQLSTATE:()HY000ER_PARTITION_WRONG_VALUES_ERROR消息:只有%sPARTITIONING可以在分区定义中使用VALUES%s错误:1481SQLSTATE:()HY000ER_PARTITION_MAXVALUE_ERROR消息:MAXVALUE只能在最后的分区定义中使用错误:1482SQLSTATE:()HY000ER_PARTITION_SUBPARTITION_ERROR消息:子分区只能是散列分区和密钥错误:1483SQLSTATE:()HY000ER_PARTITION_SUBPART_MIX_ERROR消息:如果在一个分区上,必须在所有分区上定义子分区错误:1484SQLSTATE:()HY000ER_PARTITION_WRONG_NO_PART_ERROR消息:定义的分区数量错误,与之前的设置不匹配错误:1485SQLSTATE:()HY000ER_PARTITION_WRONG_NO_SUBPART_ERROR消息:定义的子分区数量错误,与之前的设置不匹配错误:1486SQLSTATE:()HY000ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR消息:(子)分区函数中的常量,随机或时区相关表达式是不允许的错误:1487SQLSTATE:()HY000ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERROR消息:在RANGE/LISTVALUES中的表达式必须是常量错误:1488SQLSTATE:()HY000ER_FIELD_NOT_FOUND_PART_ERROR消息:在表中找不到分区函数的字段列表中的字段错误:1489SQLSTATE:()HY000ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERROR消息:字段列表只允许在KEY分区中使用错误:1490SQLSTATE:()HY000ER_INCONSISTENT_PARTITION_INFO_ERROR消息:frm文件中的分区信息与可以写入frm文件的内容不一致错误:1491SQLSTATE:()HY000ER_PARTITION_FUNC_NOT_ALLOWED_ERROR消息:%s函数返回错误的类型错误:1492SQLSTATE:()HY000ER_PARTITIONS_MUST_BE_DEFINED_ERROR消息:对于%s分区,必须定义每个分区错误:1493SQLSTATE:()HY000ER_RANGE_NOT_INCREASING_ERROR消息:值小于每个分区的值必须严格增加错误:1494SQLSTATE:()HY000ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR消息:VALUES的值必须与分区函数的类型相同错误:1495SQLSTATE:()HY000ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR消息:列表分区中的相同常量的多重定义错误:1496SQLSTATE:()HY000ER_PARTITION_ENTRY_ERROR消息:分区不能在查询中单独使用错误:1497SQLSTATE:()HY000ER_MIX_HANDLER_ERROR消息:在这个版本的MySQL中不允许混合分区中的处理程序错误:1498SQLSTATE:()HY000ER_PARTITION_NOT_DEFINED_ERROR消息:对于分区引擎,有必要定义所有的%s错误:1499SQLSTATE:()HY000ER_TOO_MANY_PARTITIONS_ERROR消息:定义了太多分区(包括子分区)错误:1500SQLSTATE:()HY000ER_SUBPARTITION_ERROR消息:只能将RANGE/LIST分区与HASH/KEY分区混合进行子分区错误:1501SQLSTATE:()HY000ER_CANT_CREATE_HANDLER_FILE消息:无法创建特定的处理程序文件错误:1502SQLSTATE:()HY000ER_BLOB_FIELD_IN_PART_FUNC_ERROR消息:分区函数中不允许有BLOB字段错误:1503SQLSTATE:()HY000ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF消息:%s必须包含表的分区函数中的所有列错误:1504SQLSTATE:()HY000ER_NO_PARTS_ERROR消息:%s=0的数量不是允许的值错误:1505SQLSTATE:()HY000ER_PARTITION_MGMT_ON_NONPARTITIONED消息:未分区表上的分区管理是不可能的错误:1506SQLSTATE:()HY000ER_FOREIGN_KEY_ON_PARTITIONED消息:外键子句还不支持与分区结合使用错误:1507SQLSTATE:()HY000ER_DROP_PARTITION_NON_EXISTENT消息:分区列表%s中出错错误:1508SQLSTATE:()HY000ER_DROP_LAST_PARTITION消息:无法删除所有分区,请使用DROPTABLE错误:1509SQLSTATE:()HY000ER_COALESCE_ONLY_ON_HASH_PARTITION消息:COALESCEPARTITION只能用于HASH/KEY分区错误:1510SQLSTATE:()HY000ER_REORG_HASH_ONLY_ON_SAME_NO消息:REORGANIZEPARTITION只能用于重新组织分区而不能更改其编号错误:1511SQLSTATE:()HY000ER_REORG_NO_PARAM_ERROR消息:不带参数的REORGANIZEPARTITION只能在使用HASHPARTITION的自动分区表上使用错误:1512SQLSTATE:()HY000ER_ONLY_ON_RANGE_LIST_PARTITION消息:%sPARTITION只能在RANGE/LIST分区上使用错误:1513SQLSTATE:()HY000ER_ADD_PARTITION_SUBPART_ERROR消息:尝试添加具有错误子分区数量的分区错误:1514SQLSTATE:()HY000ER_ADD_PARTITION_NO_NEW_PARTITION消息:至少必须添加一个分区错误:1515SQLSTATE:()HY000ER_COALESCE_PARTITION_NO_PARTITION消息:至少有一个分区必须合并错误:1516SQLSTATE:()HY000ER_REORG_PARTITION_NOT_EXIST消息:重新分区的分区数多于分区数错误:1517SQLSTATE:()HY000ER_SAME_NAME_PARTITION消息:重复分区名称%s错误:1518SQLSTATE:()HY000ER_NO_BINLOG_ERROR消息:这个命令不允许关闭binlog错误:1519SQLSTATE:()HY000ER_CONSECUTIVE_REORG_PARTITIONS消息:重新组织一组分区时,它们必须连续错误:1520SQLSTATE:()HY000ER_REORG_OUTSIDE_RANGE消息:范围分区的重组不能更改总范围,除了最后一个可以扩展范围的分区错误:1521SQLSTATE:()HY000ER_PARTITION_FUNCTION_FAILURE消息:该版本的处理程序不支持分区功能错误:1522SQLSTATE:()HY000ER_PART_STATE_ERROR消息:分区状态不能从CREATE/ALTERTABLE定义错误:1523SQLSTATE:()HY000ER_LIMITED_PART_RANGE消息:%s处理程序仅在VALUES中支持32位整数错误:1524SQLSTATE:()HY000ER_PLUGIN_IS_NOT_LOADED消息:插件“%s”未加载错误:1525SQLSTATE:()HY000ER_WRONG_VALUE消息:错误的%s值:'%s'错误:1526SQLSTATE:()HY000ER_NO_PARTITION_FOR_GIVEN_VALUE消息:表没有值%s的分区错误:1527SQLSTATE:()HY000ER_FILEGROUP_OPTION_ONLY_ONCE消息:不允许多次指定%s错误:1528SQLSTATE:()HY000ER_CREATE_FILEGROUP_FAILED消息:无法创建%s错误:1529SQLSTATE:()HY000ER_DROP_FILEGROUP_FAILED消息:无法删除%s错误:1530SQLSTATE:()HY000ER_TABLESPACE_AUTO_EXTEND_ERROR消息:处理程序不支持自动扩展表空间错误:1531SQLSTATE:()HY000ER_WRONG_SIZE_NUMBER消息:大小参数被错误地指定,无论是数字还是在表单10M上错误:1532SQLSTATE:()HY000ER_SIZE_OVERFLOW_ERROR信息:号码是正确的,但我们不允许数字部分超过20亿错误:1533SQLSTATE:()HY000ER_ALTER_FILEGROUP_FAILED消息:未能更改:%s错误:1534SQLSTATE:()HY000ER_BINLOG_ROW_LOGGING_FAILED消息:将一行写入基于行的二进制日志失败错误:1535SQLSTATE:()HY000ER_BINLOG_ROW_WRONG_TABLE_DEF消息:主站和从站的表定义不匹配:%s错误:1536SQLSTATE:()HY000ER_BINLOG_ROW_RBR_TO_SBR消息:使用--log-slave-updates运行的从站必须使用基于行的二进制日志记录才能复制基于行的二进制日志事件错误:1537SQLSTATE:()HY000ER_EVENT_ALREADY_EXISTS消息:事件'%s'已经存在错误:1538SQLSTATE:()HY000ER_EVENT_STORE_FAILED消息:无法存储事件%s。来自存储引擎的错误代码%d。错误:1539SQLSTATE:()HY000ER_EVENT_DOES_NOT_EXIST讯息:未知事件'%s'错误:1540SQLSTATE:()HY000ER_EVENT_CANT_ALTER消息:无法更改事件'%s'错误:1541SQLSTATE:()HY000ER_EVENT_DROP_FAILED消息:无法删除%s错误:1542SQLSTATE:()HY000ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG消息:INTERVAL不是正面的,就是太大错误:1543SQLSTATE:()HY000ER_EVENT_ENDS_BEFORE_STARTS消息:ENDS无效或在启动之前错误:1544SQLSTATE:()HY000ER_EVENT_EXEC_TIME_IN_THE_PAST消息:事件执行时间在过去。事件已被禁用错误:1545SQLSTATE:()HY000ER_EVENT_OPEN_TABLE_FAILED消息:无法打开mysql.event错误:1546SQLSTATE:()HY000ER_EVENT_NEITHER_M_EXPR_NOR_M_AT消息:没有提供日期表达式错误:1547SQLSTATE:()HY000ER_OBSOLETE_COL_COUNT_DOESNT_MATCH_CORRUPTED消息:mysql的列数。%s是错误的。预计%d,找到%d。该表可能已损坏错误:1548SQLSTATE:()HY000ER_OBSOLETE_CANNOT_LOAD_FROM_TABLE消息:无法从MySQL。%s加载。该表可能已损坏错误:1549SQLSTATE:()HY000ER_EVENT_CANNOT_DELETE消息:无法从mysql.event中删除事件错误:1550SQLSTATE:()HY000ER_EVENT_COMPILE_ERROR消息:编译事件正文时出错错误:1551SQLSTATE:()HY000ER_EVENT_SAME_NAME消息:相同的新旧事件名称错误:1552SQLSTATE:()HY000ER_EVENT_DATA_TOO_LONG消息:列'%s'的数据太长错误:1553SQLSTATE:()HY000ER_DROP_INDEX_FK消息:无法删除索引'%s':在外键约束中需要InnoDB当您尝试删除可强制执行特定参照约束的最后一个索引时报告此错误。对于DML语句的最佳性能,InnoDB需要一个索引上存在外键列,所以UPDATE和DELETE操作上的父表可以很容易地检查在是否存在相应的行子表。MySQL的创建或在需要时自动下降这样的索引,作为副作用CREATETABLE,CREATEINDEX和ALTERTABLE语句。删除索引时,InnoDB检查索引是否用于检查外键约束。如果有另外一个索引可以用来执行相同的约束,那么删除索引仍然可以。InnoDB阻止您放弃可以强制执行特定参照约束的最后一个索引。错误:1554SQLSTATE:()HY000ER_WARN_DEPRECATED_SYNTAX_WITH_VER消息:语法'%s'已被弃用,将在MySQL%s中被删除。请使用%s代替错误:1555SQLSTATE:()HY000ER_CANT_WRITE_LOCK_LOG_TABLE消息:您无法写入锁定日志表。只读取权限是可能的错误:1556SQLSTATE:()HY000ER_CANT_LOCK_LOG_TABLE消息:您不能将日志表与锁一起使用。错误:1557SQLSTATE:()23000ER_FOREIGN_DUPLICATE_KEY消息:维护表'%s'的外键约束,条目'%s',键%d将导致重复条目在5.6.4中:ER_FOREIGN_DUPLICATE_KEY被重命名为ER_FOREIGN_DUPLICATE_KEY_OLD_UNUSED。ER_FOREIGN_DUPLICATE_KEY在5.6.3之后被删除。错误:1557SQLSTATE:()23000ER_FOREIGN_DUPLICATE_KEY_OLD_UNUSED消息:维护表'%s'的外键约束,条目'%s',键%d将导致重复条目在5.6.4中:ER_FOREIGN_DUPLICATE_KEY被重命名为ER_FOREIGN_DUPLICATE_KEY_OLD_UNUSED。ER_FOREIGN_DUPLICATE_KEY_OLD_UNUSED在5.6.4中加入。错误:1558SQLSTATE:()HY000ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE消息:mysql的列数。%s是错误的。预计%d,找到%d。使用MySQL%d创建,现在正在运行%d。请使用mysql_upgrade来解决这个错误。错误:1559SQLSTATE:()HY000ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR消息:当会话打开临时表时,无法切换出基于行的二进制日志格式错误:1560SQLSTATE:()HY000ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_FORMAT消息:无法更改存储的函数或触发器中的二进制记录格式错误:1561SQLSTATE:()HY000ER_NDB_CANT_SWITCH_BINLOG_FORMAT消息:NDB群集引擎不支持即时更改二进制日志格式错误:1562SQLSTATE:()HY000ER_PARTITION_NO_TEMPORARY消息:无法使用分区创建临时表错误:1563SQLSTATE:()HY000ER_PARTITION_CONST_DOMAIN_ERROR消息:分区常量超出分区功能域错误:1564SQLSTATE:()HY000ER_PARTITION_FUNCTION_IS_NOT_ALLOWED消息:这个分区功能是不允许的错误:1565SQLSTATE:()HY000ER_DDL_LOG_ERROR消息:DDL日志中的错误错误:1566SQLSTATE:()HY000ER_NULL_IN_VALUES_LESS_THAN消息:不允许在VALUESLESSTHAN中使用NULL值错误:1567SQLSTATE:()HY000ER_WRONG_PARTITION_NAME消息:不正确的分区名称错误:1568SQLSTATE:()25001ER_CANT_CHANGE_TX_ISOLATION消息:事务处理正在进行时,事务隔离级别不能更改在5.6.5中:ER_CANT_CHANGE_TX_ISOLATION被重命名为ER_CANT_CHANGE_TX_CHARACTERISTICS。ER_CANT_CHANGE_TX_ISOLATION在5.6.4之后被删除。错误:1568SQLSTATE:()25001ER_CANT_CHANGE_TX_CHARACTERISTICS消息:事务正在进行时,事务特性无法更改在5.6.5中:ER_CANT_CHANGE_TX_ISOLATION被重命名为ER_CANT_CHANGE_TX_CHARACTERISTICS。ER_CANT_CHANGE_TX_CHARACTERISTICS在5.6.5中加入。错误:1569SQLSTATE:()HY000ER_DUP_ENTRY_AUTOINCREMENT_CASE消息:ALTERTABLE导致auto_increment重新排序,导致键'%s'重复条目'%s'错误:1570SQLSTATE:()HY000ER_EVENT_MODIFY_QUEUE_ERROR消息:内部调度程序错误%d错误:1571SQLSTATE:()HY000ER_EVENT_SET_VAR_ERROR消息:在启动/停止调度程序时出错。错误代码%u错误:1572SQLSTATE:()HY000ER_PARTITION_MERGE_ERROR消息:引擎不能在分区表中使用错误:1573SQLSTATE:()HY000ER_CANT_ACTIVATE_LOG消息:无法激活'%s'日志错误:1574SQLSTATE:()HY000ER_RBR_NOT_AVAILABLE消息:服务器未使用基于行的复制构建错误:1575SQLSTATE:()HY000ER_BASE64_DECODE_ERROR消息:base64字符串的解码失败错误:1576SQLSTATE:()HY000ER_EVENT_RECURSION_FORBIDDEN消息:当存在主体时,递归EVENTDDL语句被禁止错误:1577SQLSTATE:()HY000ER_EVENTS_DB_ERROR消息:由于事件调度程序使用的系统表在服务器启动时发现已损坏,因此无法继续要解决此问题,请尝试运行mysql_upgrade。错误:1578SQLSTATE:()HY000ER_ONLY_INTEGERS_ALLOWED消息:这里只允许以数字形式的整数错误:1579SQLSTATE:()HY000ER_UNSUPORTED_LOG_ENGINE消息:此存储引擎不能用于日志表“错误:1580SQLSTATE:()HY000ER_BAD_LOG_STATEMENT消息:如果启用了日志记录功能,则不能'%s'登录表错误:1581SQLSTATE:()HY000ER_CANT_RENAME_LOG_TABLE消息:无法重命名“%s”。启用日志记录时,重命名为/从日志表必须重命名两个表:日志表到归档表和另一个表回到'%s'错误:1582SQLSTATE:()42000ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT消息:调用本地函数“%s”时参数计数不正确错误:1583SQLSTATE:()42000ER_WRONG_PARAMETERS_TO_NATIVE_FCT消息:调用本机函数“%s”时参数不正确错误:1584SQLSTATE:()42000ER_WRONG_PARAMETERS_TO_STORED_FCT消息:调用存储函数'%s'时参数不正确错误:1585SQLSTATE:()HY000ER_NATIVE_FCT_NAME_COLLISION消息:这个函数'%s'与原生函数具有相同的名字错误:1586SQLSTATE:()23000ER_DUP_ENTRY_WITH_KEY_NAME消息:键'%s'的重复项'%s'此错误的格式字符串也用于ER_DUP_ENTRY。错误:1587SQLSTATE:()HY000ER_BINLOG_PURGE_EMFILE信息:打开的文件过多,请重新执行错误:1588SQLSTATE:()HY000ER_EVENT_CANNOT_CREATE_IN_THE_PAST消息:事件执行时间过去,并且设置了ONCOMPLETIONNOTPRESERVE。事件在创建后立即被丢弃。错误:1589SQLSTATE:()HY000ER_EVENT_CANNOT_ALTER_IN_THE_PAST消息:事件执行时间过去,并且设置了ONCOMPLETIONNOTPRESERVE。事件没有改变。指定将来的时间。错误:1590SQLSTATE:()HY000ER_SLAVE_INCIDENT消息:事件%s发生在主站上。消息:%s错误:1591SQLSTATE:()HY000ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT消息:对于某些现有值,表没有分区错误:1592SQLSTATE:()HY000ER_BINLOG_UNSAFE_STATEMENT消息:自从BINLOG_FORMAT=STATEMENT以来,使用语句格式写入二进制日志的不安全语句。%S错误:1593SQLSTATE:()HY000ER_SLAVE_FATAL_ERROR消息:致命错误:%s错误:1594SQLSTATE:()HY000ER_SLAVE_RELAY_LOG_READ_FAILURE消息:中继日志读取失败:%s错误:1595SQLSTATE:()HY000ER_SLAVE_RELAY_LOG_WRITE_FAILURE消息:中继日志写入失败:%s错误:1596SQLSTATE:()HY000ER_SLAVE_CREATE_EVENT_FAILURE消息:无法创建%s错误:1597SQLSTATE:()HY000ER_SLAVE_MASTER_COM_FAILURE消息:主控命令%s失败:%s错误:1598SQLSTATE:()HY000ER_BINLOG_LOGGING_IMPOSSIBLE消息:二进制日志记录不可能。消息:%s错误:1599SQLSTATE:()HY000ER_VIEW_NO_CREATION_CTX消息:查看`%s`.`%s`没有创建上下文错误:1600SQLSTATE:()HY000ER_VIEW_INVALID_CREATION_CTX消息:视图`%s`.`%s'的创建上下文无效错误:1601SQLSTATE:()HY000ER_SR_INVALID_CREATION_CTX消息:存储例程'%s`.`%s`的创建上下文无效错误:1602SQLSTATE:()HY000ER_TRG_CORRUPTED_FILE消息:损坏了表'%s`.`%s`的TRG文件错误:1603SQLSTATE:()HY000ER_TRG_NO_CREATION_CTX消息:表'%s`.`%s`的触发器没有创建上下文错误:1604SQLSTATE:()HY000ER_TRG_INVALID_CREATION_CTX消息:表'%s`.`%s`的触发器创建上下文无效错误:1605SQLSTATE:()HY000ER_EVENT_INVALID_CREATION_CTX消息:事件`%s`.`%s`的创建上下文无效错误:1606SQLSTATE:()HY000ER_TRG_CANT_OPEN_TABLE消息:无法为触发器'%s`.`%s`打开表格错误:1607SQLSTATE:()HY000ER_CANT_CREATE_SROUTINE消息:无法创建存储的例程`%s`。检查警告错误:1608SQLSTATE:()HY000ER_NEVER_USED消息:模糊的从属模式组合。%S错误:1609SQLSTATE:()HY000ER_NO_FORMAT_DESCRIPTION_EVENT_BEFORE_BINLOG_STATEMENT消息:`%s`类型的BINLOG语句没有使用格式描述BINLOG语句。错误:1610SQLSTATE:()HY000ER_SLAVE_CORRUPT_EVENT消息:检测到损坏的复制事件错误:1611SQLSTATE:()HY000ER_LOAD_DATA_INVALID_COLUMN消息:LOADDATA中的列引用无效(%s)错误:1612SQLSTATE:()HY000ER_LOG_PURGE_NO_FILE消息:正在清除日志%s未找到错误:1613SQLSTATE:()XA106ER_XA_RBTIMEOUT消息:XA_RBTIMEOUT:事务分支被回滚:花费太长时间错误:1614SQLSTATE:()XA102ER_XA_RBDEADLOCK消息:XA_RBDEADLOCK:事务分支回滚:检测到死锁错误:1615SQLSTATE:()HY000ER_NEED_REPREPARE信息:准备好的陈述需要重新准备错误:1616SQLSTATE:()HY000ER_DELAYED_NOT_SUPPORTED消息:DELAYED选项不支持表'%s'错误:1617SQLSTATE:()HY000WARN_NO_MASTER_INFO消息:主信息结构不存在错误:1618SQLSTATE:()HY000WARN_OPTION_IGNORED消息:<%s>选项被忽略错误:1619SQLSTATE:()HY000WARN_PLUGIN_DELETE_BUILTIN消息:内置的插件不能被删除错误:1620SQLSTATE:()HY000WARN_PLUGIN_BUSY消息:插件忙,将在关机时卸载错误:1621SQLSTATE:()HY000ER_VARIABLE_IS_READONLY消息:%s变量'%s'是只读的。使用SET%s来分配值错误:1622SQLSTATE:()HY000ER_WARN_ENGINE_TRANSACTION_ROLLBACK消息:存储引擎%s不支持此语句的回滚。事务回滚并且必须重新启动错误:1623SQLSTATE:()HY000ER_SLAVE_HEARTBEAT_FAILURE消息:意外的主人的心跳数据:%s错误:1624SQLSTATE:()HY000ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE消息:心跳周期的请求值为负值或超过允许的最大值(%s秒)。错误:1625SQLSTATE:()HY000ER_NDB_REPLICATION_SCHEMA_ERROR消息:对于mysql.ndb_replication表的错误模式。消息:%s错误:1626SQLSTATE:()HY000ER_CONFLICT_FN_PARSE_ERROR消息:解析冲突函数时出错。消息:%s错误:1627SQLSTATE:()HY000ER_EXCEPTIONS_WRITE_ERROR消息:写入异常表失败。消息:%s“错误:1628SQLSTATE:()HY000ER_TOO_LONG_TABLE_COMMENT消息:表'%s'的评论太长(max=%lu)错误:1629SQLSTATE:()HY000ER_TOO_LONG_FIELD_COMMENT消息:对“%s”字段的评论太长(max=%lu)错误:1630SQLSTATE:()42000ER_FUNC_INEXISTENT_NAME_COLLISION消息:FUNCTION%s不存在。检查参考手册中的“函数名称分析和解析”部分错误:1631SQLSTATE:()HY000ER_DATABASE_NAME消息:数据库错误:1632SQLSTATE:()HY000ER_TABLE_NAME消息:表错误:1633SQLSTATE:()HY000ER_PARTITION_NAME消息:分区错误:1634SQLSTATE:()HY000ER_SUBPARTITION_NAME消息:子分区错误:1635SQLSTATE:()HY000ER_TEMPORARY_NAME消息:临时错误:1636SQLSTATE:()HY000ER_RENAMED_NAME消息:重命名错误:1637SQLSTATE:()HY000ER_TOO_MANY_CONCURRENT_TRXS消息:活动并发事务太多错误:1638SQLSTATE:()HY000WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTED消息:不完全支持非ASCII分隔符参数错误:1639SQLSTATE:()HY000ER_DEBUG_SYNC_TIMEOUT消息:调试同步点等待超时错误:1640SQLSTATE:()HY000ER_DEBUG_SYNC_HIT_LIMIT消息:达到调试同步点命中限制错误:1641SQLSTATE:()42000ER_DUP_SIGNAL_SET消息:复制条件信息项'%s'错误:1642SQLSTATE:()01000ER_SIGNAL_WARN消息:未处理的用户定义的警告条件错误:1643SQLSTATE:()02000ER_SIGNAL_NOT_FOUND消息:未处理的用户定义未找到的条件错误:1644SQLSTATE:()HY000ER_SIGNAL_EXCEPTION消息:未处理的用户定义的异常情况错误:1645SQLSTATE:()0K000ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER消息:当处理程序不活动时RESIGNAL错误:1646SQLSTATE:()HY000ER_SIGNAL_BAD_CONDITION_TYPE消息:SIGNAL/RESIGNAL只能使用用SQLSTATE定义的CONDITION错误:1647SQLSTATE:()HY000WARN_COND_ITEM_TRUNCATED消息:条件项目'%s'的数据被截断错误:1648SQLSTATE:()HY000ER_COND_ITEM_TOO_LONG消息:条件项目'%s'的数据太长错误:1649SQLSTATE:()HY000ER_UNKNOWN_LOCALE消息:未知区域设置:'%s'错误:1650SQLSTATE:()HY000ER_SLAVE_IGNORE_SERVER_IDS消息:请求的服务器ID%d与从属启动选项--replicate-same-server-id冲突错误:1651SQLSTATE:()HY000ER_QUERY_CACHE_DISABLED消息:查询缓存被禁用;使用query_cache_type=1重新启动服务器以启用它错误:1652SQLSTATE:()HY000ER_SAME_NAME_PARTITION_FIELD消息:重复分区字段名称'%s'错误:1653SQLSTATE:()HY000ER_PARTITION_COLUMN_LIST_ERROR消息:使用列列表进行分区的不一致性错误:1654SQLSTATE:()HY000ER_WRONG_TYPE_COLUMN_VALUE_ERROR消息:错误类型的分区列值错误:1655SQLSTATE:()HY000ER_TOO_MANY_PARTITION_FUNC_FIELDS_ERROR消息:'%s'中的字段过多错误:1656SQLSTATE:()HY000ER_MAXVALUE_IN_VALUES_IN消息:无法将MAXVALUE用作VALUESIN中的值错误:1657SQLSTATE:()HY000ER_TOO_MANY_VALUES_ERROR消息:对于这种类型的%s分区,不能有多个值错误:1658SQLSTATE:()HY000ER_ROW_SINGLE_PARTITION_FIELD_ERROR消息:VALUESIN中的行表达式仅适用于多字段列分区错误:1659SQLSTATE:()HY000ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD消息:对于此类型的分区,字段'%s'是不允许的类型错误:1660SQLSTATE:()HY000ER_PARTITION_FIELDS_TOO_LONG消息:分区字段的总长度太大错误:1661SQLSTATE:()HY000ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINE消息:无法执行语句:无法写入二进制日志,因为涉及行不可行的引擎和无法引用语句的引擎。错误:1662SQLSTATE:()HY000ER_BINLOG_ROW_MODE_AND_STMT_ENGINE消息:无法执行语句:自BINLOG_FORMAT=ROW以来至少有一个表使用限制为基于语句的日志记录的存储引擎,因此无法写入二进制日志。错误:1663SQLSTATE:()HY000ER_BINLOG_UNSAFE_AND_STMT_ENGINE消息:无法执行语句:无法写入二进制日志,因为语句不安全,存储引擎仅限于基于语句的日志记录,而BINLOG_FORMAT=MIXED。%S错误:1664SQLSTATE:()HY000ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINE消息:无法执行语句:无法写入二进制日志,因为语句是行格式,并且至少有一个表使用限制为基于语句的日志记录的存储引擎。错误:1665SQLSTATE:()HY000ER_BINLOG_STMT_MODE_AND_ROW_ENGINE消息:无法执行语句:自从BINLOG_FORMAT=STATEMENT以来,无法写入二进制日志,并且至少有一个表使用限制为基于行的日志记录的存储引擎。错误:1666SQLSTATE:()HY000ER_BINLOG_ROW_INJECTION_AND_STMT_MODE消息:无法执行语句:由于语句是行格式和BINLOG_FORMAT=STATEMENT,因此无法写入二进制日志。错误:1667SQLSTATE:()HY000ER_BINLOG_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE消息:无法执行语句:由于涉及多个引擎,且至少有一个引擎是自我记录,因此无法写入二进制日志。错误:1668SQLSTATE:()HY000ER_BINLOG_UNSAFE_LIMIT消息:声明是不安全的,因为它使用LIMIT子句。这是不安全的,因为包含的行集不能被预测。错误:1669SQLSTATE:()HY000ER_BINLOG_UNSAFE_INSERT_DELAYED消息:声明是不安全的,因为它使用INSERTDELAYED。这是不安全的,因为插入行的时间是无法预测的。错误:1670SQLSTATE:()HY000ER_BINLOG_UNSAFE_SYSTEM_TABLE消息:该语句不安全,因为它使用常规日志,慢查询日志或performance_schema表。这是不安全的,因为系统表可能在从属上不同。错误:1671SQLSTATE:()HY000ER_BINLOG_UNSAFE_AUTOINC_COLUMNS消息:语句是不安全的,因为它会调用插入到AUTO_INCREMENT列的触发器或存储函数。插入的值不能正确记录。错误:1672SQLSTATE:()HY000ER_BINLOG_UNSAFE_UDF消息:语句是不安全的,因为它使用的UDF可能不会在从站上返回相同的值。错误:1673SQLSTATE:()HY000ER_BINLOG_UNSAFE_SYSTEM_VARIABLE消息:语句是不安全的,因为它使用的系统变量可能在从站上有不同的值。错误:1674SQLSTATE:()HY000ER_BINLOG_UNSAFE_SYSTEM_FUNCTION消息:语句是不安全的,因为它使用一个系统函数,可能在从站上返回一个不同的值。错误:1675SQLSTATE:()HY000ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS消息:语句是不安全的,因为它在访问同一事务中的事务表之后访问非事务表。错误:1676SQLSTATE:()HY000ER_MESSAGE_AND_STATEMENT消息:%s声明:%s错误:1677SQLSTATE:()HY000ER_SLAVE_CONVERSION_FAILED消息:表'%s。%s'的列%d不能从类型'%s'转换为类型'%s'错误:1678SQLSTATE:()HY000ER_SLAVE_CANT_CREATE_CONVERSION消息:无法为表'%s。%s'创建转换表错误:1679SQLSTATE:()HY000ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_FORMAT消息:无法修改事务内部的@@session.binlog_format错误:1680SQLSTATE:()HY000ER_PATH_LENGTH消息:为%s指定的路径太长。错误:1681SQLSTATE:()HY000ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT消息:'%s'已被弃用,并将在未来版本中删除。错误:1682SQLSTATE:()HY000ER_WRONG_NATIVE_TABLE_STRUCTURE消息:本地表'%s'。'%s'结构错误错误:1683SQLSTATE:()HY000ER_WRONG_PERFSCHEMA_USAGE消息:无效的performance_schema用法。错误:1684SQLSTATE:()HY000ER_WARN_I_S_SKIPPED_TABLE消息:表'%s'。'%s'被跳过,因为它的定义正在被并发的DDL语句修改错误:1685SQLSTATE:()HY000ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_DIRECT消息:无法修改事务内的@@session.binlog_direct_non_transactional_updates错误:1686SQLSTATE:()HY000ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_DIRECT消息:无法更改存储的函数或触发器中的二进制日志直接标志错误:1687SQLSTATE:()42000ER_SPATIAL_MUST_HAVE_GEOM_COL消息:SPATIAL索引可能只包含几何类型列错误:1688SQLSTATE:()HY000ER_TOO_LONG_INDEX_COMMENT消息:对索引“%s”的评论太长(max=%lu)错误:1689SQLSTATE:()HY000ER_LOCK_ABORTED消息:由于等待排他锁,等待锁定被中止错误:1690SQLSTATE:()22003ER_DATA_OUT_OF_RANGE消息:%s值超出'%s'范围错误:1691SQLSTATE:()HY000ER_WRONG_SPVAR_TYPE_IN_LIMIT消息:LIMIT子句中基于非整数类型的变量错误:1692SQLSTATE:()HY000ER_BINLOG_UNSAFE_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE消息:在一个语句中混合自我记录和非自我记录引擎是不安全的。错误:1693SQLSTATE:()HY000ER_BINLOG_UNSAFE_MIXED_STATEMENT消息:语句访问非事务表以及事务或临时表,并写入其中任何一个。错误:1694SQLSTATE:()HY000ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN消息:无法修改事务中的@@session.sql_log_bin错误:1695SQLSTATE:()HY000ER_STORED_FUNCTION_PREVENTS_SWITCH_SQL_LOG_BIN消息:无法更改存储的函数或触发器中的sql_log_bin错误:1696SQLSTATE:()HY000ER_FAILED_READ_FROM_PAR_FILE消息:无法从.par文件读取错误:1697SQLSTATE:()HY000ER_VALUES_IS_NOT_INT_TYPE_ERROR消息:分区'%s'的VALUES值必须具有INT类型ER_VALUES_IS_NOT_INT_TYPE_ERROR在5.6.1中加入。错误:1698SQLSTATE:()28000ER_ACCESS_DENIED_NO_PASSWORD_ERROR消息:拒绝访问用户'%s'@'%s'ER_ACCESS_DENIED_NO_PASSWORD_ERROR在5.6.1中加入。错误:1699SQLSTATE:()HY000ER_SET_PASSWORD_AUTH_PLUGIN消息:SETPASSWORD对于通过插件进行认证的用户没有意义ER_SET_PASSWORD_AUTH_PLUGIN在5.6.1中加入。错误:1700SQLSTATE:()HY000ER_GRANT_PLUGIN_USER_EXISTS消息:与IDENTIFIEDWITH授予是非法的,因为用户%-。*s已经存在ER_GRANT_PLUGIN_USER_EXISTS在5.6.1中加入。错误:1701SQLSTATE:()42000ER_TRUNCATE_ILLEGAL_FKMessage:Cannottruncateatablereferencedinaforeignkeyconstraint(%s)ER_TRUNCATE_ILLEGAL_FKwasaddedin5.6.1.Error:1702SQLSTATE:HY000(ER_PLUGIN_IS_PERMANENT)Message:Plugin'%s'isforce_plus_permanentandcannotbeunloadedER_PLUGIN_IS_PERMANENTwasaddedin5.6.1.Error:1703SQLSTATE:HY000(ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN)Message:Therequestedvaluefortheheartbeatperiodislessthan1millisecond.Thevalueisresetto0,meaningthatheartbeatingwilleffectivelybedisabled.ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MINwasaddedin5.6.1.Error:1704SQLSTATE:HY000(ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX)Message:Therequestedvaluefortheheartbeatperiodexceedsthevalueof`slave_net_timeout'seconds.Asensiblevaluefortheperiodshouldbelessthanthetimeout.ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAXwasaddedin5.6.1.Error:1705SQLSTATE:HY000(ER_STMT_CACHE_FULL)Message:Multi-rowstatementsrequiredmorethan'max_binlog_stmt_cache_size'bytesofstorage;increasethismysqldvariableandtryagainER_STMT_CACHE_FULLwasaddedin5.6.1.Error:1706SQLSTATE:HY000(ER_MULTI_UPDATE_KEY_CONFLICT)Message:Primarykey/partitionkeyupdateisnotallowedsincethetableisupdatedbothas'%s'and'%s'.ER_MULTI_UPDATE_KEY_CONFLICTwasaddedin5.6.2.Error:1707SQLSTATE:HY000(ER_TABLE_NEEDS_REBUILD)Message:Tablerebuildrequired.Pleasedo"ALTERTABLE`%s`FORCE"ordump/reloadtofixit!ER_TABLE_NEEDS_REBUILDwasaddedin5.6.3.Error:1708SQLSTATE:HY000(WARN_OPTION_BELOW_LIMIT)Message:Thevalueof'%s'shouldbenolessthanthevalueof'%s'WARN_OPTION_BELOW_LIMITwasaddedin5.6.3.Error:1709SQLSTATE:HY000(ER_INDEX_COLUMN_TOO_LONG)Message:Indexcolumnsizetoolarge.Themaximumcolumnsizeis%lubytes.ER_INDEX_COLUMN_TOO_LONGwasaddedin5.6.3.Error:1710SQLSTATE:HY000(ER_ERROR_IN_TRIGGER_BODY)Message:Trigger'%s'hasanerrorinitsbody:'%s'ER_ERROR_IN_TRIGGER_BODYwasaddedin5.6.3.Error:1711SQLSTATE:HY000(ER_ERROR_IN_UNKNOWN_TRIGGER_BODY)Message:Unknowntriggerhasanerrorinitsbody:'%s'ER_ERROR_IN_UNKNOWN_TRIGGER_BODYwasaddedin5.6.3.Error:1712SQLSTATE:HY000(ER_INDEX_CORRUPT)Message:Index%siscorruptedER_INDEX_CORRUPTwasaddedin5.6.3.Error:1713SQLSTATE:HY000(ER_UNDO_RECORD_TOO_BIG)Message:Undologrecordistoobig.ER_UNDO_RECORD_TOO_BIGwasaddedin5.6.4.Error:1714SQLSTATE:HY000(ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT)消息:INSERTIGNORE...SELECT是不安全的,因为SELECT检索行的顺序决定忽略哪些(如果有的话)行。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT在5.6.4中加入。错误:1715SQLSTATE:()HY000ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATE消息:INSERT...SELECT...ONDUPLICATEKEYUPDATE是不安全的,因为SELECT检索行的顺序决定更新哪些(如果有的话)行。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATE在5.6.4中加入。错误:1716SQLSTATE:()HY000ER_BINLOG_UNSAFE_REPLACE_SELECT消息:REPLACE...SELECT是不安全的,因为SELECT检索行的顺序决定了哪些(如果有的话)行被替换。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_REPLACE_SELECT在5.6.4中加入。错误:1717SQLSTATE:()HY000ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECT消息:CREATE...IGNORESELECT是不安全的,因为SELECT检索行的顺序决定忽略哪些(如果有的话)行。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECT在5.6.4中加入。错误:1718SQLSTATE:()HY000ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECT消息:CREATE...REPLACESELECT是不安全的,因为SELECT检索行的顺序决定了哪些(如果有的话)行被替换。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECT在5.6.4中加入。错误:1719SQLSTATE:()HY000ER_BINLOG_UNSAFE_UPDATE_IGNORE消息:UPDATEIGNORE是不安全的,因为行更新的顺序决定忽略哪些(如果有的话)行。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_UPDATE_IGNORE在5.6.4中加入。错误:1720SQLSTATE:()HY000ER_PLUGIN_NO_UNINSTALL消息:插件“%s”被标记为不可动态卸载。你必须停止服务器来卸载它。ER_PLUGIN_NO_UNINSTALL在5.6.4中加入。错误:1721SQLSTATE:()HY000ER_CANT_LOCK_RPL_INFO_TABLE消息:您不能使用rpl信息表的锁。ER_CANT_LOCK_RPL_INFO_TABLE在5.6.1中加入,在5.6.3后除去。错误:1721SQLSTATE:()HY000ER_PLUGIN_NO_INSTALL消息:插件“%s”被标记为不可动态安装。您必须停止服务器来安装它。ER_PLUGIN_NO_INSTALL在5.6.4中加入。错误:1722SQLSTATE:()HY000ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT消息:在从另一个表中选择后,使用自动增量列写入表的语句是不安全的,因为检索行的顺序决定了将要写入的行(如果有)。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT在5.6.5中加入。错误:1723SQLSTATE:()HY000ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINC消息:在具有自动增量列的表上的CREATETABLE...SELECT是不安全的,因为SELECT检索行的顺序决定插入哪些(如果有)行。这个顺序不能被预测,并且可能在主控和从属上有所不同。ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINC在5.6.5中加入。错误:1724SQLSTATE:()HY000ER_BINLOG_UNSAFE_INSERT_TWO_KEYS消息:对具有多个UNIQUEKEY的表上的INSERT...ONDUPLICATEKEYUPDATE是不安全的ER_BINLOG_UNSAFE_INSERT_TWO_KEYS在5.6.6中加入。错误:1725SQLSTATE:()HY000ER_TABLE_IN_FK_CHECK消息:表正在用于外键检查。ER_TABLE_IN_FK_CHECK在5.6.6中加入。错误:1726SQLSTATE:()HY000ER_UNSUPPORTED_ENGINE消息:存储引擎“%s”不支持系统表。[%S%S]ER_UNSUPPORTED_ENGINE在5.6.6中加入。错误:1727SQLSTATE:()HY000ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST消息:插入到不是组合主键中的第一部分的自动增量字段是不安全的。ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST在5.6.6中加入。错误:1728SQLSTATE:()HY000ER_CANNOT_LOAD_FROM_TABLE_V2消息:无法从%s。%s加载。该表可能已损坏错误:1729SQLSTATE:()HY000ER_NO_SUCH_PARTITION消息:分区'%s'不存在ER_NO_SUCH_PARTITION在5.6.2中加入,在5.6.5后除去。错误:1729SQLSTATE:()HY000ER_MASTER_DELAY_VALUE_OUT_OF_RANGE消息:主延迟的请求值%s超过最大值%u错误:1730SQLSTATE:()HY000ER_ONLY_FD_AND_RBR_EVENTS_ALLOWED_IN_BINLOG_STATEMENT消息:在BINLOG语句中只允许使用Format_description_log_event和行事件(但提供了%s)错误:1731SQLSTATE:()HY000ER_PARTITION_EXCHANGE_DIFFERENT_OPTION消息:分区和表之间的属性'%s'不匹配错误:1732SQLSTATE:()HY000ER_PARTITION_EXCHANGE_PART_TABLE消息:与分区交换的表被分区:'%s'错误:1733SQLSTATE:()HY000ER_PARTITION_EXCHANGE_TEMP_TABLE消息:与分区交换的表是暂时的:'%s'错误:1734SQLSTATE:()HY000ER_PARTITION_INSTEAD_OF_SUBPARTITION消息:子分区表,使用子分区而不是分区错误:1735SQLSTATE:()HY000ER_UNKNOWN_PARTITION消息:表'%s'中的未知分区“%s”错误:1736SQLSTATE:()HY000ER_TABLES_DIFFERENT_METADATA消息:表具有不同的定义错误:1737SQLSTATE:()HY000ER_ROW_DOES_NOT_MATCH_PARTITION消息:找到与分区不匹配的行错误:1738SQLSTATE:()HY000ER_BINLOG_CACHE_SIZE_GREATER_THAN_MAX消息:选项binlog_cache_size(%lu)大于max_binlog_cache_size(%lu);设置binlog_cache_size等于max_binlog_cache_size。ER_BINLOG_CACHE_SIZE_GREATER_THAN_MAX在5.6.1中加入。错误:1739SQLSTATE:()HY000ER_WARN_INDEX_NOT_APPLICABLE消息:由于字段'%s'上的类型或排序规则转换,无法对索引'%s'使用%s访问ER_WARN_INDEX_NOT_APPLICABLE在5.6.1中加入。错误:1740SQLSTATE:()HY000ER_PARTITION_EXCHANGE_FOREIGN_KEY消息:与分区交换的表具有外键引用:'%s'ER_PARTITION_EXCHANGE_FOREIGN_KEY在5.6.1中加入。错误:1741SQLSTATE:()HY000ER_NO_SUCH_KEY_VALUE消息:表'%s。%s'中未找到键值“%s”ER_NO_SUCH_KEY_VALUE在5.6.1中加入。错误:1742SQLSTATE:()HY000ER_RPL_INFO_DATA_TOO_LONG消息:列'%s'的数据太长ER_RPL_INFO_DATA_TOO_LONG在5.6.1中加入。错误:1743SQLSTATE:()HY000ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE消息:从网络读取时复制事件校验和验证失败。ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE在5.6.1中加入。错误:1744SQLSTATE:()HY000ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE消息:从日志文件读取时复制事件校验和验证失败。ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE在5.6.1中加入。错误:1745SQLSTATE:()HY000ER_BINLOG_STMT_CACHE_SIZE_GREATER_THAN_MAX消息:选项binlog_stmt_cache_size(%lu)大于max_binlog_stmt_cache_size(%lu);设置binlog_stmt_cache_size等于max_binlog_stmt_cache_size。ER_BINLOG_STMT_CACHE_SIZE_GREATER_THAN_MAX在5.6.1中加入。错误:1746SQLSTATE:()HY000ER_CANT_UPDATE_TABLE_IN_CREATE_TABLE_SELECT消息:正在创建'%s'时无法更新表'%s'。ER_CANT_UPDATE_TABLE_IN_CREATE_TABLE_SELECT在5.6.2中加入。错误:1747SQLSTATE:()HY000ER_PARTITION_CLAUSE_ON_NONPARTITIONED消息:非分区表上的PARTITION()子句ER_PARTITION_CLAUSE_ON_NONPARTITIONED在5.6.2中加入。错误:1748SQLSTATE:()HY000ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET消息:发现一行不匹配给定的分区集ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET在5.6.2中加入。错误:1749SQLSTATE:()HY000ER_NO_SUCH_PARTITION__UNUSED消息:分区'%s'不存在ER_NO_SUCH_PARTITION__UNUSED在5.6.6中加入。错误:1750SQLSTATE:()HY000ER_CHANGE_RPL_INFO_REPOSITORY_FAILURE消息:更改复制存储库的类型时失败:%s。ER_CHANGE_RPL_INFO_REPOSITORY_FAILURE在5.6.3中加入。错误:1751SQLSTATE:()HY000ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_CREATED_TEMP_TABLE消息:一些临时表的创建无法回滚。ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_CREATED_TEMP_TABLE在5.6.3中加入。错误:1752SQLSTATE:()HY000ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_DROPPED_TEMP_TABLE消息:一些临时表已被删除,但这些操作无法回滚。ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_DROPPED_TEMP_TABLE在5.6.3中加入。错误:1753SQLSTATE:()HY000ER_MTS_FEATURE_IS_NOT_SUPPORTED消息:多线程从模式不支持%s。%SER_MTS_FEATURE_IS_NOT_SUPPORTED在5.6.3中加入。错误:1754SQLSTATE:()HY000ER_MTS_UPDATED_DBS_GREATER_MAX消息:修改的数据库数量超过最大值%d;数据库名称将不会包含在复制事件元数据中。ER_MTS_UPDATED_DBS_GREATER_MAX在5.6.3中加入。错误:1755SQLSTATE:()HY000ER_MTS_CANT_PARALLEL消息:无法在并行模式下执行当前事件组。遇到事件%s,中继日志名称%s,位置%s,它阻止以并行模式执行此事件组。原因:%s。ER_MTS_CANT_PARALLEL在5.6.3中加入。错误:1756SQLSTATE:()HY000ER_MTS_INCONSISTENT_DATA消息:%sER_MTS_INCONSISTENT_DATA在5.6.3中加入。错误:1757SQLSTATE:()HY000ER_FULLTEXT_NOT_SUPPORTED_WITH_PARTITIONING消息:分区表不支持FULLTEXT索引。ER_FULLTEXT_NOT_SUPPORTED_WITH_PARTITIONING在5.6.4中加入。错误:1758SQLSTATE:()35000ER_DA_INVALID_CONDITION_NUMBER消息:条件编号无效ER_DA_INVALID_CONDITION_NUMBER在5.6.4中加入。错误:1759SQLSTATE:()HY000ER_INSECURE_PLAIN_TEXT消息:以纯文本方式发送不带SSL/TLS的密码是非常不安全的。ER_INSECURE_PLAIN_TEXT在5.6.4中加入。错误:1760SQLSTATE:()HY000ER_INSECURE_CHANGE_MASTER消息:将MySQL用户名或密码信息存储在主信息库中是不安全的,因此不推荐使用。请考虑使用STARTSLAVE的USER和PASSWORD连接选项;请参阅MySQL手册中的“STARTSLAVESyntax”以获取更多信息。ER_INSECURE_CHANGE_MASTER在5.6.4中加入。错误:1761SQLSTATE:()23000ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO消息:表'%s'的外键约束,记录'%s'将导致表'%s'中的重复条目,键'%s'ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO在5.6.4中加入。错误:1762SQLSTATE:()23000ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO消息:表'%s'的外键约束,记录'%s'将导致子表中的重复条目ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO在5.6.4中加入。错误:1763SQLSTATE:()HY000ER_SQLTHREAD_WITH_SECURE_SLAVE消息:仅启动从SQLSQL线程时,无法设置身份验证选项。ER_SQLTHREAD_WITH_SECURE_SLAVE在5.6.4中加入。错误:1764SQLSTATE:()HY000ER_TABLE_HAS_NO_FT消息:该表没有FULLTEXT索引来支持此查询ER_TABLE_HAS_NO_FT在5.6.4中加入。错误:1765SQLSTATE:()HY000ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER消息:系统变量%s不能在存储函数或触发器中设置。ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER在5.6.5中加入。错误:1766SQLSTATE:()HY000ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION消息:当存在正在进行的事务时,系统变量%s不能被设置。ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION在5.6.5中加入。错误:1767SQLSTATE:()HY000ER_GTID_NEXT_IS_NOT_IN_GTID_NEXT_LIST消息:系统变量@@SESSION.GTID_NEXT的值为%s,未在@@SESSION.GTID_NEXT_LIST中列出。ER_GTID_NEXT_IS_NOT_IN_GTID_NEXT_LIST在5.6.5中加入。错误:1768SQLSTATE:()HY000ER_CANT_CHANGE_GTID_NEXT_IN_TRANSACTION_WHEN_GTID_NEXT_LIST_IS_NULL消息:系统变量@@SESSION.GTID_NEXT不能在事务内部更改。ER_CANT_CHANGE_GTID_NEXT_IN_TRANSACTION_WHEN_GTID_NEXT_LIST_IS_NULL在5.6.5中加入。错误:1769SQLSTATE:()HY000ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION消息:语句'SET%s'不能调用存储的函数。ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION在5.6.5中加入。错误:1770SQLSTATE:()HY000ER_GTID_NEXT_CANT_BE_AUTOMATIC_IF_GTID_NEXT_LIST_IS_NON_NULL消息:当@@SESSION.GTID_NEXT_LIST为非NULL时,系统变量@@SESSION.GTID_NEXT不能为“AUTOMATIC”。ER_GTID_NEXT_CANT_BE_AUTOMATIC_IF_GTID_NEXT_LIST_IS_NON_NULL在5.6.5中加入。错误:1771SQLSTATE:()HY000ER_SKIPPING_LOGGED_TRANSACTION消息:跳过事务%s,因为它已经被执行和记录。ER_SKIPPING_LOGGED_TRANSACTION在5.6.5中加入。错误:1772SQLSTATE:()HY000ER_MALFORMED_GTID_SET_SPECIFICATION消息:格式错误的GTID设置规范'%s'。ER_MALFORMED_GTID_SET_SPECIFICATION在5.6.5中加入。错误:1773SQLSTATE:()HY000ER_MALFORMED_GTID_SET_ENCODING消息:格式不正确的GTID集合编码。ER_MALFORMED_GTID_SET_ENCODING在5.6.5中加入。错误:1774SQLSTATE:()HY000ER_MALFORMED_GTID_SPECIFICATION消息:格式错误的GTID规范'%s'。ER_MALFORMED_GTID_SPECIFICATION在5.6.5中加入。错误:1775SQLSTATE:()HY000ER_GNO_EXHAUSTED消息:不可能产生全局事务标识符:整数分量达到最大值。用新的server_uuid重新启动服务器。ER_GNO_EXHAUSTED在5.6.5中加入。错误:1776SQLSTATE:()HY000ER_BAD_SLAVE_AUTO_POSITION消息:当MASTER_AUTO_POSITION处于活动状态时,不能设置参数MASTER_LOG_FILE,MASTER_LOG_POS,RELAY_LOG_FILE和RELAY_LOG_POS。ER_BAD_SLAVE_AUTO_POSITION在5.6.5中加入。错误:1777SQLSTATE:()HY000ER_AUTO_POSITION_REQUIRES_GTID_MODE_ON消息:只有在@@GLOBAL.GTID_MODE=ON时才能执行MASTER_AUTO_POSITIONCHANGEMASTER=1。ER_AUTO_POSITION_REQUIRES_GTID_MODE_ON在5.6.5中加入。错误:1778SQLSTATE:()HY000ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET消息:当@@SESSION.GTID_NEXT!=AUTOMATIC时,不能在事务内执行具有隐式提交的语句。ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET在5.6.5中加入。错误:1779SQLSTATE:()HY000ER_GTID_MODE_2_OR_3_REQUIRES_DISABLE_GTID_UNSAFE_STATEMENTS_ON消息:GTID_MODE=ON或GTID_MODE=UPGRADE_STEP_2需要DISABLE_GTID_UNSAFE_STATEMENTS=1。在5.6.9中:ER_GTID_MODE_2_OR_3_REQUIRES_DISABLE_GTID_UNSAFE_STATEMENTS_ON被重命名为ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON。ER_GTID_MODE_2_OR_3_REQUIRES_DISABLE_GTID_UNSAFE_STATEMENTS_ON在5.6.5中加入,在5.6.8后除去。错误:1779SQLSTATE:()HY000ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON消息:@@GLOBAL.GTID_MODE=ON或UPGRADE_STEP_2要求@@GLOBAL.ENFORCE_GTID_CONSISTENCY=1。在5.6.9中:ER_GTID_MODE_2_OR_3_REQUIRES_DISABLE_GTID_UNSAFE_STATEMENTS_ON被重命名为ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON。ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON在5.6.9中加入。错误:1780SQLSTATE:()HY000ER_GTID_MODE_REQUIRES_BINLOG消息:@@GLOBAL.GTID_MODE=ON或UPGRADE_STEP_1或UPGRADE_STEP_2需要--log-bin和--log-slave-updates。ER_GTID_MODE_REQUIRES_BINLOG在5.6.5中加入。错误:1781SQLSTATE:()HY000ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF消息:当@@GLOBAL.GTID_MODE=OFF时,不能将@@SESSION.GTID_NEXT设置为UUID:NUMBER。ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF在5.6.5中加入。错误:1782SQLSTATE:()HY000ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON消息:@@GLOBAL.GTID_MODE=ON时,@@SESSION.GTID_NEXT不能设置为匿名。ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON在5.6.5中加入。错误:1783SQLSTATE:()HY000ER_CANT_SET_GTID_NEXT_LIST_TO_NON_NULL_WHEN_GTID_MODE_IS_OFF消息:@@GLOBAL.GTID_MODE=OFF时,不能将@@SESSION.GTID_NEXT_LIST设置为非NULL值。ER_CANT_SET_GTID_NEXT_LIST_TO_NON_NULL_WHEN_GTID_MODE_IS_OFF在5.6.5中加入。错误:1784SQLSTATE:()HY000ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF消息:@@GLOBAL.GTID_MODE=OFF时,找到Gtid_log_event或Previous_gtids_log_event。ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF在5.6.5中加入。错误:1785SQLSTATE:()HY000ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE消息:当@@GLOBAL.ENFORCE_GTID_CONSISTENCY=1时,对非事务表的更新只能在自动提交语句或单语句事务中完成,而不能在与事务表更新相同的语句中完成。ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE在5.6.5中加入。错误:1786SQLSTATE:()HY000ER_GTID_UNSAFE_CREATE_SELECT消息:当@@GLOBAL.ENFORCE_GTID_CONSISTENCY=1时,CREATETABLE...SELECT被禁止。ER_GTID_UNSAFE_CREATE_SELECT在5.6.5中加入。错误:1787SQLSTATE:()HY000ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION消息:当@@GLOBAL.ENFORCE_GTID_CONSISTENCY=1时,语句CREATETEMPORARYTABLE和DROPTEMPORARYTABLE只能在非事务性上下文中执行,并且要求AUTOCOMMIT=1。这些语句在函数或触发器中也是不允许的,因为函数和触发器也被认为是多语句事务。ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION在5.6.5中加入。错误:1788SQLSTATE:()HY000ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME消息:@@GLOBAL.GTID_MODE的值一次只能更改一个步骤:OFF<->UPGRADE_STEP_1<->UPGRADE_STEP_2<->ON。另外请注意,这个值必须在所有服务器上同时增加或减少。有关说明,请参阅手册。ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME在5.6.5中加入。错误:1789SQLSTATE:()HY000ER_MASTER_HAS_PURGED_REQUIRED_GTIDS消息:从站正在使用CHANGEMASTERTOMASTER_AUTO_POSITION=1进行连接,但主站已清除包含从站需要的GTID的二进制日志。ER_MASTER_HAS_PURGED_REQUIRED_GTIDS在5.6.5中加入。错误:1790SQLSTATE:()HY000ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID消息:@@SESSION.GTID_NEXT不能由拥有GTID的客户端更改。客户拥有%s。所有权在COMMIT或ROLLBACK上发布。ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID在5.6.5中加入。错误:1791SQLSTATE:()HY000ER_UNKNOWN_EXPLAIN_FORMAT消息:未知的EXPLAIN格式名称:'%s'ER_UNKNOWN_EXPLAIN_FORMAT在5.6.5中加入。错误:1792SQLSTATE:()25006ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION消息:不能在READONLY事务中执行语句。ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION在5.6.5中加入。错误:1793SQLSTATE:()HY000ER_TOO_LONG_TABLE_PARTITION_COMMENT消息:对表分区'%s'的评论太长(max=%lu)ER_TOO_LONG_TABLE_PARTITION_COMMENT在5.6.6中加入。错误:1794SQLSTATE:()HY000ER_SLAVE_CONFIGURATION消息:从站未配置或无法正确初始化。您必须至少设置-服务器标识以启用主服务器或从服务器。其他错误信息可以在MySQL错误日志中找到。ER_SLAVE_CONFIGURATION在5.6.6中加入。错误:1795SQLSTATE:()HY000ER_INNODB_FT_LIMIT消息:InnoDB目前支持一次创建一个FULLTEXT索引ER_INNODB_FT_LIMIT在5.6.4中加入。错误:1796SQLSTATE:()HY000ER_INNODB_NO_FT_TEMP_TABLE消息:无法在临时InnoDB表上创建FULLTEXT索引ER_INNODB_NO_FT_TEMP_TABLE在5.6.4中加入。错误:1797SQLSTATE:()HY000ER_INNODB_FT_WRONG_DOCID_COLUMN消息:对于InnoDBFULLTEXT索引,列'%s'的类型是错误的ER_INNODB_FT_WRONG_DOCID_COLUMN在5.6.6中加入。错误:1798SQLSTATE:()HY000ER_INNODB_FT_WRONG_DOCID_INDEX消息:索引'%s'对于InnoDBFULLTEXT索引是错误的类型ER_INNODB_FT_WRONG_DOCID_INDEX在5.6.6中加入。错误:1799SQLSTATE:()HY000ER_INNODB_ONLINE_LOG_TOO_BIG消息:创建索引'%s'比修改日志的'innodb_online_alter_log_max_size'字节多。请再试一次。ER_INNODB_ONLINE_LOG_TOO_BIG在5.6.6中加入。错误:1800SQLSTATE:()HY000ER_UNKNOWN_ALTER_ALGORITHM消息:未知的算法'%s'ER_UNKNOWN_ALTER_ALGORITHM在5.6.6中加入。错误:1801SQLSTATE:()HY000ER_UNKNOWN_ALTER_LOCK消息:未知LOCK类型“%s”ER_UNKNOWN_ALTER_LOCK在5.6.6中加入。错误:1802SQLSTATE:()HY000ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS消息:当从站在MTS模式下被错误停止或死亡时,CHANGEMASTER不能被执行。考虑使用RESETSLAVE或STARTSLAVEUNTIL。ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS在5.6.6中加入。错误:1803SQLSTATE:()HY000ER_MTS_RECOVERY_FAILURE消息:SLAVE在并行执行模式下出错后无法恢复。其他错误信息可以在MySQL错误日志中找到。ER_MTS_RECOVERY_FAILURE在5.6.6中加入。错误:1804SQLSTATE:()HY000ER_MTS_RESET_WORKERS消息:无法清理工人信息表。其他错误信息可以在MySQL错误日志中找到。ER_MTS_RESET_WORKERS在5.6.6中加入。错误:1805SQLSTATE:()HY000ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2消息:%s。%s的列数是错误的。预计%d,找到%d。该表可能已损坏错误:1806SQLSTATE:()HY000ER_SLAVE_SILENT_RETRY_TRANSACTION消息:奴隶必须默默地重试当前交易ER_SLAVE_SILENT_RETRY_TRANSACTION在5.6.6中加入。错误:1807SQLSTATE:()HY000ER_DISCARD_FK_CHECKS_RUNNING消息:在表'%s'上运行外键检查。不能丢弃表格。ER_DISCARD_FK_CHECKS_RUNNING在5.6.6中加入。错误:1808SQLSTATE:()HY000ER_TABLE_SCHEMA_MISMATCH消息:模式不匹配(%s)ER_TABLE_SCHEMA_MISMATCH在5.6.6中加入。错误:1809SQLSTATE:()HY000ER_TABLE_IN_SYSTEM_TABLESPACE消息:系统表空间中的表'%s'ER_TABLE_IN_SYSTEM_TABLESPACE在5.6.6中加入。错误:1810SQLSTATE:()HY000ER_IO_READ_ERROR消息:IO读取错误:(%lu,%s)%sER_IO_READ_ERROR在5.6.6中加入。错误:1811SQLSTATE:()HY000ER_IO_WRITE_ERROR消息:IO写入错误:(%lu,%s)%sER_IO_WRITE_ERROR在5.6.6中加入。错误:1812SQLSTATE:()HY000ER_TABLESPACE_MISSING消息:表'%s'缺少表空间ER_TABLESPACE_MISSING在5.6.6中加入。错误:1813SQLSTATE:()HY000ER_TABLESPACE_EXISTS消息:表'%s'的表空间存在。请在IMPORT之前丢弃表空间。ER_TABLESPACE_EXISTS在5.6.6中加入。错误:1814SQLSTATE:()HY000ER_TABLESPACE_DISCARDED消息:表'%s'的表空间已被丢弃ER_TABLESPACE_DISCARDED在5.6.6中加入。错误:1815SQLSTATE:()HY000ER_INTERNAL_ERROR消息:内部错误:%sER_INTERNAL_ERROR在5.6.6中加入。错误:1816SQLSTATE:()HY000ER_INNODB_IMPORT_ERROR消息:ALTERTABLE'%s'IMPORTTABLESPACE失败,错误为%lu:'%s'ER_INNODB_IMPORT_ERROR在5.6.6中加入。错误:1817SQLSTATE:()HY000ER_INNODB_INDEX_CORRUPT消息:索引损坏:%sER_INNODB_INDEX_CORRUPT在5.6.6中加入。错误:1818SQLSTATE:()HY000ER_INVALID_YEAR_COLUMN_LENGTH消息:YEAR(%lu)列类型已被弃用。改为创建YEAR(4)列。ER_INVALID_YEAR_COLUMN_LENGTH在5.6.6中加入。错误:1819SQLSTATE:()HY000ER_NOT_VALID_PASSWORD信息:您的密码不符合当前的政策要求ER_NOT_VALID_PASSWORD在5.6.6中加入。错误:1820SQLSTATE:()HY000ER_MUST_CHANGE_PASSWORD消息:执行此语句之前,必须先设置密码ER_MUST_CHANGE_PASSWORD在5.6.6中加入。错误:1821SQLSTATE:()HY000ER_FK_NO_INDEX_CHILD消息:无法添加外键约束。在外表'%s'中缺少约束'%s'的索引ER_FK_NO_INDEX_CHILD在5.6.6中加入。错误:1822SQLSTATE:()HY000ER_FK_NO_INDEX_PARENTMessage:Failedtoaddtheforeignkeyconstaint.Missingindexforconstraint'%s'inthereferencedtable'%s'ER_FK_NO_INDEX_PARENTwasaddedin5.6.6.Error:1823SQLSTATE:HY000(ER_FK_FAIL_ADD_SYSTEM)Message:Failedtoaddtheforeignkeyconstraint'%s'tosystemtablesER_FK_FAIL_ADD_SYSTEMwasaddedin5.6.6.Error:1824SQLSTATE:HY000(ER_FK_CANNOT_OPEN_PARENT)Message:Failedtoopenthereferencedtable'%s'ER_FK_CANNOT_OPEN_PARENTwasaddedin5.6.6.Error:1825SQLSTATE:HY000(ER_FK_INCORRECT_OPTION)Message:Failedtoaddtheforeignkeyconstraintontable'%s'.IncorrectoptionsinFOREIGNKEYconstraint'%s'ER_FK_INCORRECT_OPTIONwasaddedin5.6.6.Error:1826SQLSTATE:HY000(ER_FK_DUP_NAME)Message:Duplicateforeignkeyconstraintname'%s'ER_FK_DUP_NAMEwasaddedin5.6.6.Error:1827SQLSTATE:HY000(ER_PASSWORD_FORMAT)Message:Thepasswordhashdoesn'thavetheexpectedformat.CheckifthecorrectpasswordalgorithmisbeingusedwiththePASSWORD()function.ER_PASSWORD_FORMATwasaddedin5.6.6.Error:1828SQLSTATE:HY000(ER_FK_COLUMN_CANNOT_DROP)消息:无法删除列'%s':需要在外键约束'%s'ER_FK_COLUMN_CANNOT_DROP在5.6.6中加入。错误:1829SQLSTATE:()HY000ER_FK_COLUMN_CANNOT_DROP_CHILD消息:无法删除表'%s'的外键约束'%s'中所需的列'%s':ER_FK_COLUMN_CANNOT_DROP_CHILD在5.6.6中加入。错误:1830SQLSTATE:()HY000ER_FK_COLUMN_NOT_NULL消息:列'%s'不能是NOTNULL:在外键约束'%s'中需要SETNULLER_FK_COLUMN_NOT_NULL在5.6.6中加入。错误:1831SQLSTATE:()HY000ER_DUP_INDEX消息:表'%s。%s'上定义的重复索引'%s'。这已被弃用,并将在未来的版本中被禁止。ER_DUP_INDEX在5.6.7中加入。错误:1832SQLSTATE:()HY000ER_FK_COLUMN_CANNOT_CHANGE消息:无法更改列'%s':用于外键约束'%s'ER_FK_COLUMN_CANNOT_CHANGE在5.6.7中加入。错误:1833SQLSTATE:()HY000ER_FK_COLUMN_CANNOT_CHANGE_CHILD消息:无法更改列'%s':用于表'%s'的外键约束'%s'ER_FK_COLUMN_CANNOT_CHANGE_CHILD在5.6.7中加入。错误:1834SQLSTATE:()HY000ER_FK_CANNOT_DELETE_PARENT消息:无法从表'%s'的外键约束'%s'中的父表中删除行,ER_FK_CANNOT_DELETE_PARENT在5.6.7中加入。错误:1835SQLSTATE:()HY000ER_MALFORMED_PACKET消息:格式错误的通信数据包。ER_MALFORMED_PACKET在5.6.7中加入。错误:1836SQLSTATE:()HY000ER_READ_ONLY_MODE消息:以只读模式运行ER_READ_ONLY_MODE在5.6.8中加入。错误:1837SQLSTATE:()HY000ER_GTID_NEXT_TYPE_UNDEFINED_GROUP消息:将@@SESSION.GTID_NEXT设置为GTID时,必须在COMMIT或ROLLBACK后将其明确设置为不同的值。请查看GTID_NEXT变量手册页以获取详细说明。目前@@SESSION.GTID_NEXT是'%s'。ER_GTID_NEXT_TYPE_UNDEFINED_GROUP在5.6.9中加入。错误:1838SQLSTATE:()HY000ER_VARIABLE_NOT_SETTABLE_IN_SP消息:系统变量%s不能在存储过程中设置。ER_VARIABLE_NOT_SETTABLE_IN_SP在5.6.9中加入。错误:1839SQLSTATE:()HY000ER_CANT_SET_GTID_PURGED_WHEN_GTID_MODE_IS_OFF消息:@@GLOBAL.GTID_PURGED只能在@@GLOBAL.GTID_MODE=ON时设置。ER_CANT_SET_GTID_PURGED_WHEN_GTID_MODE_IS_OFF在5.6.9中加入。错误:1840SQLSTATE:()HY000ER_CANT_SET_GTID_PURGED_WHEN_GTID_EXECUTED_IS_NOT_EMPTY消息:@@GLOBAL.GTID_PURGED只能在@@GLOBAL.GTID_EXECUTED为空时设置。ER_CANT_SET_GTID_PURGED_WHEN_GTID_EXECUTED_IS_NOT_EMPTY在5.6.9中加入。错误:1841SQLSTATE:()HY000ER_CANT_SET_GTID_PURGED_WHEN_OWNED_GTIDS_IS_NOT_EMPTY消息:@@GLOBAL.GTID_PURGED只能在没有正在进行的交易时设置(甚至不在其他客户端中)。ER_CANT_SET_GTID_PURGED_WHEN_OWNED_GTIDS_IS_NOT_EMPTY在5.6.9中加入。错误:1842SQLSTATE:()HY000ER_GTID_PURGED_WAS_CHANGED消息:@@GLOBAL.GTID_PURGED已从“%s”更改为“%s”。ER_GTID_PURGED_WAS_CHANGED在5.6.9中加入。错误:1843SQLSTATE:()HY000ER_GTID_EXECUTED_WAS_CHANGED消息:@@GLOBAL.GTID_EXECUTED已从“%s”更改为“%s”。ER_GTID_EXECUTED_WAS_CHANGED在5.6.9中加入。错误:1844SQLSTATE:()HY000ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES消息:无法执行语句:自从BINLOG_FORMAT=STATEMENT以及写入复制和非复制表都无法写入二进制日志。ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES在5.6.9中加入。错误:1845SQLSTATE:()0A000ER_ALTER_OPERATION_NOT_SUPPORTED消息:此操作不支持%s。尝试%s。ER_ALTER_OPERATION_NOT_SUPPORTED在5.6.10中加入。错误:1846SQLSTATE:()0A000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON消息:%s不受支持。原因:%s。尝试%s。ER_ALTER_OPERATION_NOT_SUPPORTED_REASON在5.6.10中加入。错误:1847SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COPY消息:COPY算法需要一个锁ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COPY在5.6.10中加入。错误:1848SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION消息:特定于分区的操作不支持LOCK/ALGORITHMER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION在5.6.10中加入。错误:1849SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME消息:参与外键的列被重命名ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME在5.6.10中加入。错误:1850SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE消息:不能更改列类型INPLACEER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE在5.6.10中加入。错误:1851SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK消息:添加外键需要foreign_key_checks=OFFER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK在5.6.10中加入。错误:1852SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE消息:使用IGNORE创建唯一索引需要使用COPY算法删除重复的行ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE在5.6.10中加入。错误:1853SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK消息:如果不添加主键,则不允许删除主键ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK在5.6.10中加入。错误:1854SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC消息:添加自动增量列需要锁定ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC在5.6.10中加入。错误:1855SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS消息:无法用隐藏的FTS_DOC_ID替换用户可见的FTS_DOC_IDER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS在5.6.10中加入。错误:1856SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS消息:不能删除或重命名FTS_DOC_IDER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS在5.6.10中加入。错误:1857SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS消息:创建全文索引需要锁定ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS在5.6.10中加入。错误:1858SQLSTATE:()HY000ER_SQL_SLAVE_SKIP_COUNTER_NOT_SETTABLE_IN_GTID_MODE消息:当服务器运行@@GLOBAL.GTID_MODE=ON时,不能设置sql_slave_skip_counter。相反,对于您要跳过的每个事务,使用与事务相同的GTID生成一个空事务ER_SQL_SLAVE_SKIP_COUNTER_NOT_SETTABLE_IN_GTID_MODE在5.6.10中加入。错误:1859SQLSTATE:()23000ER_DUP_UNKNOWN_IN_INDEX消息:键'%s'的重复项ER_DUP_UNKNOWN_IN_INDEX在5.6.10中加入。错误:1860SQLSTATE:()HY000ER_IDENT_CAUSES_TOO_LONG_PATH消息:对象的长数据库名称和标识符导致路径长度超过%d个字符。路径:'%s'。ER_IDENT_CAUSES_TOO_LONG_PATH在5.6.10中加入。错误:1861SQLSTATE:()HY000ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL消息:无法按照此SQL_MODE中的要求悄悄地转换NULL值ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL在5.6.10中加入。错误:1862SQLSTATE:()HY000ER_MUST_CHANGE_PASSWORD_LOGIN讯息:您的密码已过期。要登录,您必须使用支持过期密码的客户端进行更改。ER_MUST_CHANGE_PASSWORD_LOGIN在5.6.11中加入。错误:1863SQLSTATE:()HY000ER_ROW_IN_WRONG_PARTITION消息:在错误的分区%s中找到了一行ER_ROW_IN_WRONG_PARTITION在5.6.11中加入。错误:1864SQLSTATE:()HY000ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX消息:无法将事件%s,中继日志名称%s,位置%s安排到工作线程,因为它的大小%lu超过了slave_pending_jobs_size_max的%lu。ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX在5.6.12中加入。错误:1865SQLSTATE:()HY000ER_INNODB_NO_FT_USES_PARSER消息:无法在InnoDB表上创建带PARSER的FULLTEXTINDEXER_INNODB_NO_FT_USES_PARSER在5.6.12中加入。错误:1866SQLSTATE:()HY000ER_BINLOG_LOGICAL_CORRUPTION消息:二进制日志文件'%s'逻辑上已损坏:%sER_BINLOG_LOGICAL_CORRUPTION在5.6.12中加入。错误:1867SQLSTATE:()HY000ER_WARN_PURGE_LOG_IN_USE消息:文件%s没有被清除,因为它被%d个线程读取,仅被%d个文件清除%d。ER_WARN_PURGE_LOG_IN_USE在5.6.12中加入。错误:1868SQLSTATE:()HY000ER_WARN_PURGE_LOG_IS_ACTIVE消息:文件%s未被清除,因为它是活动日志文件。ER_WARN_PURGE_LOG_IS_ACTIVE在5.6.12中加入。错误:1869SQLSTATE:()HY000ER_AUTO_INCREMENT_CONFLICT消息:自动增加UPDATE中的值与内部生成的值冲突ER_AUTO_INCREMENT_CONFLICT在5.6.12中加入。错误:1870SQLSTATE:()HY000WARN_ON_BLOCKHOLE_IN_RBR消息:行事件不记录用于以行格式修改BLACKHOLE表的%s语句。表格:'%s'WARN_ON_BLOCKHOLE_IN_RBR在5.6.12中加入。错误:1871SQLSTATE:()HY000ER_SLAVE_MI_INIT_REPOSITORY消息:从站无法从存储库初始化主信息结构ER_SLAVE_MI_INIT_REPOSITORY在5.6.12中加入。错误:1872SQLSTATE:()HY000ER_SLAVE_RLI_INIT_REPOSITORY消息:从站无法从存储库初始化中继日志信息结构ER_SLAVE_RLI_INIT_REPOSITORY在5.6.12中加入。错误:1873SQLSTATE:()28000ER_ACCESS_DENIED_CHANGE_USER_ERROR消息:访问被拒绝尝试更改为用户'%s'@'%s'(使用密码:%s)。断开。ER_ACCESS_DENIED_CHANGE_USER_ERROR在5.6.13中加入。错误:1874SQLSTATE:()HY000ER_INNODB_READ_ONLY消息:InnoDB处于只读模式。ER_INNODB_READ_ONLY在5.6.13中加入。错误:1875SQLSTATE:()HY000ER_STOP_SLAVE_SQL_THREAD_TIMEOUT消息:STOPSLAVE命令执行不完整:从属SQL线程获得停止信号,线程繁忙,一旦当前任务完成,SQL线程将停止。ER_STOP_SLAVE_SQL_THREAD_TIMEOUT在5.6.13中加入。错误:1876SQLSTATE:()HY000ER_STOP_SLAVE_IO_THREAD_TIMEOUT消息:STOPSLAVE命令执行不完整:从IO线程得到停止信号,线程忙,当前任务完成后IO线程停止。ER_STOP_SLAVE_IO_THREAD_TIMEOUT在5.6.13中加入。错误:1877SQLSTATE:()HY000ER_TABLE_CORRUPT消息:操作无法执行。表'%s。%s'丢失,损坏或包含错误的数据。ER_TABLE_CORRUPT在5.6.14中加入。错误:1878SQLSTATE:()HY000ER_TEMP_FILE_WRITE_FAILURE消息:临时文件写入失败。ER_TEMP_FILE_WRITE_FAILURE在5.6.15中加入。错误:1879SQLSTATE:()HY000ER_INNODB_FT_AUX_NOT_HEX_ID消息:升级索引名称失败,请使用createindex(altertable)算法复制重建索引。ER_INNODB_FT_AUX_NOT_HEX_ID在5.6.16中加入。错误:1880SQLSTATE:()HY000ER_OLD_TEMPORALS_UPGRADED消息:旧格式的TIME/TIMESTAMP/DATETIME列已升级为新格式。ER_OLD_TEMPORALS_UPGRADED在5.6.16中加入。错误:1881SQLSTATE:()HY000ER_INNODB_FORCED_RECOVERY消息:当innodb_forced_recovery>0时不允许操作。ER_INNODB_FORCED_RECOVERY在5.6.16中加入。错误:1882SQLSTATE:()HY000ER_AES_INVALID_IV消息:提供给%s的初始化向量太短。必须至少有%d个字节的长度ER_AES_INVALID_IV在5.6.17中加入。错误:1883SQLSTATE:()HY000ER_PLUGIN_CANNOT_BE_UNINSTALLED消息:插件'%s'现在不能被卸载。%SER_PLUGIN_CANNOT_BE_UNINSTALLED在5.6.20中加入。错误:1884SQLSTATE:()HY000ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP消息:无法执行语句,因为它需要以多个语句的形式写入二进制日志,当@@SESSION.GTID_NEXT=='UUID:NUMBER'时,这是不允许的。ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP在5.6.20中加入。错误:1885SQLSTATE:()HY000ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER消息:使用主设备的SERVER_UUID,从设备拥有比主设备更多的GTID。这可能表明二进制日志的末尾被截断,或者最后一个二进制日志文件丢失,例如在sync_binlog!=1时发生电源或磁盘故障之后。主服务器可能已经回滚了已经被复制的事务对奴隶。建议复制主设备从从设备回滚到主设备的任何事务,和/或在主设备上提交空事务以处理已在主设备上提交但未包含在GTID_EXECUTED中的事务。ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER在5.6.23中加入。B.4客户端错误代码和消息客户端错误信息来自以下源文件:错误值和括号中的符号对应于include/errmsg.hMySQL源文件中的定义。消息值对应于libmysql/errmsg.c文件中列出的错误消息。%d并分别%s代表数字和字符串,它们在被显示时被代入消息中。由于更新频繁,这些文件可能会包含其他错误信息,这里没有列出。错误:2000(CR_UNKNOWN_ERROR)消息:未知的MySQL错误错误:2001(CR_SOCKET_CREATE_ERROR)消息:无法创建UNIX套接字(%d)错误:2002(CR_CONNECTION_ERROR)消息:无法通过套接字'%s'连接到本地MySQL服务器(%d)错误:2003(CR_CONN_HOST_ERROR)消息:无法连接到'%s'上的MySQL服务器(%d)错误:2004(CR_IPSOCK_ERROR)消息:无法创建TCP/IP套接字(%d)错误:2005(CR_UNKNOWN_HOST)消息:未知的MySQL服务器主机'%s'(%d)错误:2006(CR_SERVER_GONE_ERROR)消息:MySQL服务器已经消失错误:2007(CR_VERSION_ERROR)消息:协议不匹配;服务器版本=%d,客户端版本=%d错误:2008(CR_OUT_OF_MEMORY)消息:MySQL客户端内存不足错误:2009(CR_WRONG_HOST_INFO)消息:错误的主机信息错误:2010(CR_LOCALHOST_CONNECTION)消息:通过UNIX套接字的本地主机错误:2011(CR_TCP_CONNECTION)消息:通过TCP/IP的%s错误:2012(CR_SERVER_HANDSHAKE_ERR)消息:服务器握手错误错误:2013(CR_SERVER_LOST)消息:在查询过程中丢失与MySQL服务器的连接错误:2014(CR_COMMANDS_OUT_OF_SYNC)消息:命令不同步;你现在不能运行这个命令错误:2015(CR_NAMEDPIPE_CONNECTION)消息:命名管道:%s错误:2016(CR_NAMEDPIPEWAIT_ERROR)消息:不能等待命名管道托管:%s管道:%s(%lu)错误:2017(CR_NAMEDPIPEOPEN_ERROR)消息:无法打开命名管道到主机:%s管道:%s(%lu)错误:2018(CR_NAMEDPIPESETSTATE_ERROR)消息:无法将命名管道的状态设置为主机:%s管道:%s(%lu)错误:2019(CR_CANT_READ_CHARSET)消息:无法初始化字符集%s(路径:%s)错误:2020(CR_NET_PACKET_TOO_LARGE)消息:得到的分组大于'max_allowed_packet'字节错误:2021(CR_EMBEDDED_CONNECTION)消息:嵌入式服务器错误:2022(CR_PROBE_SLAVE_STATUS)消息:SHOWSLAVESTATUS出错:错误:2023(CR_PROBE_SLAVE_HOSTS)消息:SHOWSLAVEHOSTS出错:错误:2024(CR_PROBE_SLAVE_CONNECT)消息:连接到从站时出错:错误:2025(CR_PROBE_MASTER_CONNECT)消息:连接到主设备时出错:错误:2026(CR_SSL_CONNECTION_ERROR)消息:SSL连接错误:%s错误:2027(CR_MALFORMED_PACKET)消息:格式错误的数据包错误:2028(CR_WRONG_LICENSE)消息:此客户端库仅许可用于具有“%s”许可证的MySQL服务器错误:2029(CR_NULL_POINTER)消息:空指针的使用无效错误:2030(CR_NO_PREPARE_STMT)信息:没有准备好陈述错误:2031(CR_PARAMS_NOT_BOUND)消息:在准备好的语句中没有提供参数的数据错误:2032(CR_DATA_TRUNCATED)消息:数据被截断错误:2033(CR_NO_PARAMETERS_EXISTS)消息:语句中不存在任何参数错误:2034(CR_INVALID_PARAMETER_NO)消息:无效的参数号码列号为mysql_stmt_fetch_column()无效。参数号为mysql_stmt_send_long_data()无效。从5.6.6开始:密钥名称为空或连接属性数据量mysql_options4()超过64KB限制。错误:2035(CR_INVALID_BUFFER_USE)消息:无法发送非字符串/非二进制数据类型的长数据(参数:%d)错误:2036(CR_UNSUPPORTED_PARAM_TYPE)消息:使用不受支持的缓冲区类型:%d(参数:%d)错误:2037(CR_SHARED_MEMORY_CONNECTION)消息:共享内存:%s错误:2038(CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR)消息:无法打开共享内存;客户端无法创建请求事件(%lu)错误:2039(CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR)消息:无法打开共享内存;没有从服务器接收到应答事件(%lu)错误:2040(CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR)消息:无法打开共享内存;服务器无法分配文件映射(%lu)错误:2041(CR_SHARED_MEMORY_CONNECT_MAP_ERROR)消息:无法打开共享内存;服务器无法获得指向文件映射的指针(%lu)错误:2042(CR_SHARED_MEMORY_FILE_MAP_ERROR)消息:无法打开共享内存;客户端无法分配文件映射(%lu)错误:2043(CR_SHARED_MEMORY_MAP_ERROR)消息:无法打开共享内存;客户端无法获取指向文件映射的指针(%lu)错误:2044(CR_SHARED_MEMORY_EVENT_ERROR)消息:无法打开共享内存;客户端无法创建%s事件(%lu)错误:2045(CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR)消息:无法打开共享内存;没有来自服务器的答案(%lu)错误:2046(CR_SHARED_MEMORY_CONNECT_SET_ERROR)消息:无法打开共享内存;无法将请求事件发送到服务器(%lu)错误:2047(CR_CONN_UNKNOW_PROTOCOL)消息:错误或未知的协议错误:2048(CR_INVALID_CONN_HANDLE)消息:无效的连接句柄错误:2049(CR_SECURE_AUTH)消息:使用旧的(pre-4.1.1)认证协议拒绝连接(启用客户机选项“secure_auth”)错误:2050(CR_FETCH_CANCELED)消息:行检索被mysql_stmt_close()调用取消错误:2051(CR_NO_DATA)消息:尝试在没有提前取行的情况下读取列错误:2052(CR_NO_STMT_METADATA)消息:准备好的语句不包含元数据错误:2053(CR_NO_RESULT_SET)消息:尝试读取一行,但没有与该语句关联的结果集错误:2054(CR_NOT_IMPLEMENTED)消息:此功能尚未实施错误:2055(CR_SERVER_LOST_EXTENDED)消息:在'%s'处丢失了与MySQL服务器的连接,系统错误:%d错误:2056(CR_STMT_CLOSED)消息:由于前面的%s()调用间接关闭了语句错误:2057(CR_NEW_STMT_METADATA)消息:结果集中的列数与绑定缓冲区的数量不同。您必须重置语句,重新绑定结果集列,然后再次执行语句错误:2058(CR_ALREADY_CONNECTED)消息:该句柄已经连接。为每个连接使用一个单独的句柄。错误:2059(CR_AUTH_PLUGIN_CANNOT_LOAD)消息:身份验证插件“%s”无法加载:%sCR_AUTH_PLUGIN_CANNOT_LOAD在5.6.1中加入。错误:2060(CR_DUPLICATE_CONNECTION_ATTR)消息:已经有一个同名的属性从5.6.6开始:指定了重复的连接属性名称mysql_options4()。CR_DUPLICATE_CONNECTION_ATTR在5.6.6中加入。错误:2061(CR_AUTH_PLUGIN_ERR)消息:身份验证插件'%s'报告错误:%sCR_AUTH_PLUGIN_ERR在5.6.10中加入。

上述就是小编为大家分享的mysql5.6错误代码都有哪些了,如果刚好有类似的疑惑,不妨参照上述分析进行理解。如果想知道更多相关知识,欢迎关注亿速云行业资讯频道。