《Mysql错误代码大全.docx》由会员分享,可在线阅读,更多相关《Mysql错误代码大全.docx(27页珍藏版)》请在三一办公上搜索。
1、Mysql错误代码大全Mysql错误代码大全 Mysql错误代码 Mysql错误代码分为两部分,老版本一部分,4.1版本为新的部分 第一部分: mysql的出错代码表,根据mysql的头文件mysql/include/mysqld_error.h整理而成 1005:创建表失败 1006:创建数据库失败 1007:数据库已存在,创建数据库失败 1008:数据库不存在,删除数据库失败 1009:不能删除数据库文件导致删除数据库失败 1010:不能删除数据目录导致删除数据库失败 1011:删除数据库文件失败 1012:不能读取系统表中的记录 1020:记录已被其他用户修改 1021:硬盘剩余空间不足
2、,请加大硬盘可用空间 1022:关键字重复,更改记录失败 1023:关闭时发生错误 1024:读文件错误 1025:更改名字时发生错误 1026:写文件错误 1032:记录不存在 1036:数据表是只读的,不能对它进行修改 1037:系统内存不足,请重启数据库或重启服务器 1038:用于排序的内存不足,请增大排序缓冲区 1040:已到达数据库的最大连接数,请加大数据库可用连接数 1041:系统内存不足 1042:无效的主机名 1043:无效连接 1044:当前用户没有访问数据库的权限 1045:不能连接数据库,用户名或密码错误 1048:字段不能为空 1049:数据库不存在 1050:数据表已
3、存在 1051:数据表不存在 1054:字段不存在 1065:无效的SQL语句,SQL语句为空 1081:不能建立Socket连接 1114:数据表已满,不能容纳任何记录 1116:打开的数据表太多 1129:数据库出现异常,请重启数据库 1130:连接数据库失败,没有连接数据库的权限 1133:数据库用户不存在 1141:当前用户无权访问数据库 1142:当前用户无权访问数据表 1143:当前用户无权访问数据表中的字段 1146:数据表不存在 1147:未定义用户对数据表的访问权限 1149:SQL语句语法错误 1158:网络错误,出现读错误,请检查网络连接状况 1159:网络错误,读超时,
4、请检查网络连接状况 1160:网络错误,出现写错误,请检查网络连接状况 1161:网络错误,写超时,请检查网络连接状况 1062:字段值重复,入库失败 1169:字段值重复,更新记录失败 1177:打开数据表失败 1180:提交事务失败 1181:回滚事务失败 1203:当前用户和数据库建立的连接已到达数据库的最大连接数,请增大可用的数据库连接数或重启数据库 1205:加锁超时 1211:当前用户没有创建用户的权限 1216:外键约束检查失败,更新子表记录失败 1217:外键约束检查失败,删除或修改主表记录失败 1226:当前用户使用的资源已超过所允许的资源,请重启数据库或重启服务器 1227
5、:权限不足,您无权进行此操作 1235:MySQL版本过低,不具有本功能 第二部分 新4.1.11,摘自DOCSmysqld_error.txt character-set=utf-8 isher补充 #define ER_HASHCHK 1000 hashchk, #define ER_NISAMCHK 1001 isamchk, #define ER_NO 1002 NO, #define ER_YES 1003 YES, #define ER_CANT_CREATE_FILE 1004 Cant create file %-.64s (errno: %d), #define ER_CAN
6、T_CREATE_TABLE 1005 Cant create table %-.64s (errno: %d), #define ER_CANT_CREATE_DB 1006 Cant create database %-.64s (errno: %d), #define ER_DB_CREATE_EXISTS 1007 Cant create database %-.64s; database exists, #define ER_DB_DROP_EXISTS 1008 Cant drop database %-.64s; database doesnt exist, #define ER
7、_DB_DROP_DELETE 1009 Error dropping database (cant delete %-.64s, errno: %d), #define ER_DB_DROP_RMDIR 1010 Error dropping database (cant rmdir %-.64s, errno: %d), #define ER_CANT_DELETE_FILE 1011 Error on delete of %-.64s (errno: %d), #define ER_CANT_FIND_SYSTEM_REC 1012 Cant read record in system
8、table, #define ER_CANT_GET_STAT 1013 Cant get status of %-.64s (errno: %d), #define ER_CANT_GET_WD 1014 Cant get working directory (errno: %d), #define ER_CANT_LOCK 1015 Cant lock file (errno: %d), #define ER_CANT_OPEN_FILE 1016 Cant open file: %-.64s (errno: %d), #define ER_FILE_NOT_FOUND 1017 Cant
9、 find file: %-.64s (errno: %d), #define ER_CANT_READ_DIR 1018 Cant read dir of %-.64s (errno: %d), #define ER_CANT_SET_WD 1019 Cant change dir to %-.64s (errno: %d), #define ER_CHECKREAD 1020 Record has changed since last read in table %-.64s, #define ER_DISK_FULL 1021 Disk full (%s). Waiting for so
10、meone to free some space., #define ER_DUP_KEY 1022 Cant write, duplicate key in table %-.64s, #define ER_ERROR_ON_CLOSE 1023 Error on close of %-.64s (errno: %d), #define ER_ERROR_ON_READ 1024 Error reading file %-.64s (errno: %d), #define ER_ERROR_ON_RENAME 1025 Error on rename of %-.64s to %-.64s
11、(errno: %d), #define ER_ERROR_ON_WRITE 1026 Error writing file %-.64s (errno: %d), #define ER_FILE_USED 1027 %-.64s is locked against change, #define ER_FILSORT_ABORT 1028 So瘀牡?剕?o鸞?rt aborted, #define ER_FORM_NOT_FOUND 1029 View %-.64s doesnt exist for %-.64s, #define ER_GET_ERRNO 1030 Got error %d
12、 from storage engine, #define ER_ILLEGAL_HA 1031 Table storage engine for %-.64s doesnt have this option, #define ER_KEY_NOT_FOUND 1032 Cant find record in %-.64s, #define ER_NOT_FORM_FILE 1033 Incorrect information in file: %-.64s, #define ER_NOT_KEYFILE 1034 Incorrect key file for table: %-.64s; t
13、ry to repair it, #define ER_OLD_KEYFILE 1035 Old key file for table %-.64s; repair it!, #define ER_OPEN_AS_READONLY 1036 Table %-.64s is read only, #define ER_OUTOFMEMORY 1037 Out of memory. Restart daemon and try again (needed %d bytes), #define ER_OUT_OF_SORTMEMORY 1038 Out of sort memory. Increas
14、e daemon sort buffer size, #define ER_UNEXPECTED_EOF 1039 Unexpected eof found when reading file %-.64s (errno: %d), #define ER_CON_COUNT_ERROR 1040 Too many connections, #define ER_OUT_OF_RESOURCES 1041 Out of memory; Check if mysqld or some other process uses all available memory. If not you may h
15、ave to use ulimit to allow mysqld to use more memory or you can add more swap space, #define ER_BAD_HOST_ERROR 1042 Cant get hostname for your address, #define ER_HANDSHAKE_ERROR 1043 Bad handshake, #define ER_DBACCESS_DENIED_ERROR 1044 Access denied for user: email=%-.32s%-.64s/email to database %-
16、.64s, #define ER_ACCESS_DENIED_ERROR 1045 Access denied for user: email=%-.32s%-.64s/email (Using password: %s), #define ER_NO_DB_ERROR 1046 No Database Selected, #define ER_UNKNOWN_COM_ERROR 1047 Unknown command, #define ER_BAD_NULL_ERROR 1048 Column %-.64s cannot be null, #define ER_BAD_DB_ERROR 1
17、049 Unknown database %-.64s, #define ER_TABLE_EXISTS_ERROR 1050 Table %-.64s already exists, #define ER_BAD_TABLE_ERROR 1051 Unknown table %-.64s, #define ER_NON_UNIQ_ERROR 1052 Column: %-.64s in %-.64s is ambiguous, #define ER_SERVER_SHUTDOWN 1053 Server shutdown in progress, #define ER_BAD_FIELD_E
18、RROR 1瘀牡?剕?o鸞?054 Unknown column %-.64s in %-.64s, #define ER_WRONG_FIELD_WITH_GROUP 1055 %-.64s isnt in GROUP BY, #define ER_WRONG_GROUP_FIELD 1056 Cant group on %-.64s, #define ER_WRONG_SUM_SELECT 1057 Statement has sum functions and columns in same statement, #define ER_WRONG_VALUE_COUNT 1058 Col
19、umn count doesnt match value count, #define ER_TOO_LONG_IDENT 1059 Identifier name %-.100s is too long, #define ER_DUP_FIELDNAME 1060 Duplicate column name %-.64s, #define ER_DUP_KEYNAME 1061 Duplicate key name %-.64s, #define ER_DUP_ENTRY 1062 Duplicate entry %-.64s for key %d, #define ER_WRONG_FIE
20、LD_SPEC 1063 Incorrect column specifier for column %-.64s, #define ER_PARSE_ERROR 1064 %s near %-.80s at line %d, #define ER_EMPTY_QUERY 1065 Query was empty, #define ER_NONUNIQ_TABLE 1066 Not unique table/alias: %-.64s, #define ER_INVALID_DEFAULT 1067 Invalid default value for %-.64s, #define ER_MU
21、LTIPLE_PRI_KEY 1068 Multiple primary key defined, #define ER_TOO_MANY_KEYS 1069 Too many keys specified; max %d keys allowed, #define ER_TOO_MANY_KEY_PARTS 1070 Too many key parts specified. Max %d parts allowed, #define ER_TOO_LONG_KEY 1071 Specified key was too long; max key length is %d bytes, #d
22、efine ER_KEY_COLUMN_DOES_NOT_EXITS 1072 Key column %-.64s doesnt exist in table, #define ER_BLOB_USED_AS_KEY 1073 BLOB column %-.64s cant be used in key specification with the used table type, #define ER_TOO_BIG_FIELDLENGTH 1074 Too big column length for column %-.64s (max = %d). Use BLOB instead, #
23、define ER_WRONG_AUTO_KEY 1075 Incorrect table definition; There can only be one auto column and it must be defined as a key, #define ER_READY 1076 %s: ready for connections. Version: %s socket: %s port: %d , #define ER_NORMAL_SHUTDOWN 1077 %s: Normal shutdown , #define ER_GOT_SIGNAL 1078 %s: Got sig
24、nal %d. Aborting! , #define ER_SHUTDOWN_COMPLETE 1079 %s: Shutdown Complete , #define ER_FORCING_CLOSE 1080 %s: 瘀牡?剕?o鸞?Forcing close of thread %ld user: %-.32s , #define ER_IPSOCK_ERROR 1081 Cant create IP socket, #define ER_NO_SUCH_INDEX 1082 Table %-.64s has no index like the one used in CREATE I
25、NDEX. Recreate the table, #define ER_WRONG_FIELD_TERMINATORS 1083 Field separator argument is not what is expected. Check the manual, #define ER_BLOBS_AND_NO_TERMINATED 1084 You cant use fixed rowlength with BLOBs. Please use fields terminated by, #define ER_TEXTFILE_NOT_READABLE 1085 The file %-.64
26、s must be in the database directory or be readable by all, #define ER_FILE_EXISTS_ERROR 1086 File %-.80s already exists, #define ER_LOAD_INFO 1087 Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld, #define ER_ALTER_INFO 1088 Records: %ld Duplicates: %ld, #define ER_WRONG_SUB_KEY 1089 Incorrect su
27、b part key. The used key part isnt a string, the used length is longer than the key part or the storage engine doesnt support unique sub keys, #define ER_CANT_REMOVE_ALL_FIELDS 1090 You cant delete all columns with ALTER TABLE. Use DROP TABLE instead, #define ER_CANT_DROP_FIELD_OR_KEY 1091 Cant DROP
28、 %-.64s. Check that column/key exists, #define ER_INSERT_INFO 1092 Records: %ld Duplicates: %ld Warnings: %ld, #define ER_UPDATE_TABLE_USED 1093 You cant specify target table %-.64s for update in FROM clause, #define ER_NO_SUCH_THREAD 1094 Unknown thread id: %lu, #define ER_KILL_DENIED_ERROR 1095 Yo
29、u are not owner of thread %lu, #define ER_NO_TABLES_USED 1096 No tables used, #define ER_TOO_BIG_SET 1097 Too many strings for column %-.64s and SET, #define ER_NO_UNIQUE_LOGFILE 1098 Cant generate a unique log-filename %-.64s.(1-999) , #define ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 Table %-.64s was loc
30、ked with a READ lock and cant be updated, #define ER_TABLE_NOT_LOCKED 1100 Table %-.64s was not locked with LOCK TABLES, #define ER_BLOB_CANT_HAVE_DEFAULT 1101 BLOB/TEXT column %-.64s cant have a default value, #define ER_WRONG_DB_NAME 1102 Incorre瘀牡?剕?o鸞?ct database name %-.100s, #define ER_WRONG_T
31、ABLE_NAME 1103 Incorrect table name %-.100s, #define ER_TOO_BIG_SELECT 1104 The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE= # if the SELECT is ok, #define ER_UNKNOWN_ERROR 1105 Unknown error, #define ER_UNKNOWN_PROCEDURE
32、 1106 Unknown procedure %-.64s, #define ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107 Incorrect parameter count to procedure %-.64s, #define ER_WRONG_PARAMETERS_TO_PROCEDURE 1108 Incorrect parameters to procedure %-.64s, #define ER_UNKNOWN_TABLE 1109 Unknown table %-.64s in %-.32s, #define ER_FIELD_SPECIFIE
33、D_TWICE 1110 Column %-.64s specified twice, #define ER_INVALID_GROUP_FUNC_USE 1111 Invalid use of group function, #define ER_UNSUPPORTED_EXTENSION 1112 Table %-.64s uses an extension that doesnt exist in this MySQL version, #define ER_TABLE_MUST_HAVE_COLUMNS 1113 A table must have at least 1 column,
34、 #define ER_RECORD_FILE_FULL 1114 The table %-.64s is full, #define ER_UNKNOWN_CHARACTER_SET 1115 Unknown character set: %-.64s, #define ER_TOO_MANY_TABLES 1116 Too many tables. MySQL can only use %d tables in a join, #define ER_TOO_MANY_FIELDS 1117 Too many columns, #define ER_TOO_BIG_ROWSIZE 1118
35、Too big row size. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some fields to TEXT or BLOBs, #define ER_STACK_OVERRUN 1119 Thread stack overrun: Used: %ld of a %ld stack. Use mysqld -O thread_stack= # to specify a bigger stack if needed, #define ER_WRO
36、NG_OUTER_JOIN 1120 Cross dependency found in OUTER JOIN. Examine your ON conditions, #define ER_NULL_COLUMN_IN_INDEX 1121 Column %-.64s is used with UNIQUE or INDEX but is not defined as NOT NULL, #define ER_CANT_FIND_UDF 1122 Cant load function %-.64s, #define ER_CANT_INITIALIZE_UDF 1123 Cant initi
37、alize function %-.64s; %-.80s, #define ER_UDF_NO_PATHS 1124 No paths allowed for shared瘀牡?剕?o鸞? library, #define ER_UDF_EXISTS 1125 Function %-.64s already exist, #define ER_CANT_OPEN_LIBRARY 1126 Cant open shared library %-.64s (errno: %d %-.64s), #define ER_CANT_FIND_DL_ENTRY 1127 Cant find functi
38、on %-.64s in library, #define ER_FUNCTION_NOT_DEFINED 1128 Function %-.64s is not defined, #define ER_HOST_IS_BLOCKED 1129 Host %-.64s is blocked because of many connection errors. Unblock with mysqladmin flush-hosts, #define ER_HOST_NOT_PRIVILEGED 1130 Host %-.64s is not allowed to connect to this
39、MySQL server, #define ER_PASSWORD_ANONYMOUS_USER 1131 You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords, #define ER_PASSWORD_NOT_ALLOWED 1132 You must have privileges to update tables in the mysql database to be able to change passwords for others, #de
40、fine ER_PASSWORD_NO_MATCH 1133 Cant find any matching row in the user table, #define ER_UPDATE_INFO 1134 Rows matched: %ld Changed: %ld Warnings: %ld, #define ER_CANT_CREATE_THREAD 1135 Cant create a new thread (errno %d). If you are not out of available memory, you can consult the manual for a poss
41、ible OS-dependent bug, #define ER_WRONG_VALUE_COUNT_ON_ROW 1136 Column count doesnt match value count at row %ld, #define ER_CANT_REOPEN_TABLE 1137 Cant reopen table: %-.64s, #define ER_INVALID_USE_OF_NULL 1138 Invalid use of NULL value, #define ER_REGEXP_ERROR 1139 Got error %-.64s from regexp, #de
42、fine ER_MIX_OF_GROUP_FUNC_AND_FIELDS 1140 Mixing of GROUP columns (MIN,MAX,COUNT.) with no GROUP columns is illegal if there is no GROUP BY clause, #define ER_NONEXISTING_GRANT 1141 There is no such grant defined for user %-.32s on host %-.64s, #define ER_TABLEACCESS_DENIED_ERROR 1142 %-.16s command
43、 denied to user: email=%-.32s%-.64s/email for table %-.64s, #define ER_COLUMNACCESS_DENIED_ERROR 1143 %-.16s command denied to user: email=%-.32s%-.64s/email for column %-.64s in table %-.64s, #define ER_ILLEGAL_GRANT_FOR_TABLE 1144 I瘀牡?剕?o鸞?llegal GRANT/REVOKE command. Please consult the manual whi
44、ch privileges can be used, #define ER_GRANT_WRONG_HOST_OR_USER 1145 The host or user argument to GRANT is too long, #define ER_NO_SUCH_TABLE 1146 Table %-.64s.%-.64s doesnt exist, #define ER_NONEXISTING_TABLE_GRANT 1147 There is no such grant defined for user %-.32s on host %-.64s on table %-.64s, #
45、define ER_NOT_ALLOWED_COMMAND 1148 The used command is not allowed with this MySQL version, #define ER_SYNTAX_ERROR 1149 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use, #define ER_DELAYED_CANT_CHANGE_LOCK 1150 Delayed insert thread couldnt get requested lock for table %-.64s, #define ER_TOO_MANY_DELAYED_THREADS 1151 Too many delayed threads in use, #define ER_ABORTING_CONNECTION 1152 Aborted connection %ld to db:
链接地址:https://www.31ppt.com/p-3161907.html