mysql错误代码.txt

mysql的出错代码表

#define ER_NO_SUCH_INDEX 1082 
"Table '%-.64s' has no index like the one used in CREATE INDEX. 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 can't use fixed rowlength with BLOBs. Please use 'fields terminated by'", 

#define ER_TEXTFILE_NOT_READABLE 1085 
"The file '%-.64s' 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 sub part key. The used key part isn't a string, the used length is longer than the key part or the storage engine doesn't support unique sub keys", 

#define ER_CANT_REMOVE_ALL_FIELDS 1090 
"You can't delete all columns with ALTER TABLE. Use DROP TABLE instead", 

#define ER_CANT_DROP_FIELD_OR_KEY 1091 
"Can't DROP '%-.64s'. Check that column/key exists", 

#define ER_INSERT_INFO 1092 
"Records: %ld Duplicates: %ld Warnings: %ld", 

#define ER_UPDATE_TABLE_USED 1093 
"You can't 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 
"You 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 
"Can't generate a unique log-filename %-.64s.(1-999) 
", 

#define ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 
"Table '%-.64s' was locked with a READ lock and can't 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' can't have a default value", 

#define ER_WRONG_DB_NAME 1102 
"Incorre瘀牡?剕 ????o鸞? ct database name '%-.100s'", 

#define ER_WRONG_TABLE_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 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_SPECIFIED_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 doesn't exist in this MySQL version", 

#define ER_TABLE_MUST_HAVE_COLUMNS 1113 
"A table must have at least 1 column", 

#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 
"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_WRONG_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 
"Can't load function '%-.64s'", 

#define ER_CANT_INITIALIZE_UDF 1123 
"Can't initialize 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 
"Can't open shared library '%-.64s' (errno: %d %-.64s)", 

#define ER_CANT_FIND_DL_ENTRY 1127 
"Can't find function '%-.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 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", 

#define ER_PASSWORD_NO_MATCH 1133 
"Can't 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 
"Can't create a new thread (errno %d). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug", 

#define ER_WRONG_VALUE_COUNT_ON_ROW 1136 
"Column count doesn't match value count at row %ld", 

#define ER_CANT_REOPEN_TABLE 1137 
"Can't 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", 

#define 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 denied to user: '%-.32s'@'%-.64s' for table '%-.64s'", 

#define ER_COLUMNACCESS_DENIED_ERROR 1143 
"%-.16s command denied to user: '%-.32s'@'%-.64s' for column '%-.64s' in table '%-.64s'", 

#define ER_ILLEGAL_GRANT_FOR_TABLE 1144 
"I瘀牡?剕 ????o鸞? llegal GRANT/REVOKE command. Please consult the manual which 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' doesn't exist", 

#define ER_NONEXISTING_TABLE_GRANT 1147 
"There is no such grant defined for user '%-.32s' on host '%-.64s' on table '%-.64s'", 

#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 couldn't 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: '%-.64s' user: '%-.32s' (%-.64s)", 

#define ER_NET_PACKET_TOO_LARGE 1153 
"Got a packet bigger than 'max_allowed_packet'", 

#define ER_NET_READ_ERROR_FROM_PIPE 1154 
"Got a read error from the connection pipe", 

#define ER_NET_FCNTL_ERROR 1155 
"Got an error from fcntl()", 

#define ER_NET_PACKETS_OUT_OF_ORDER 1156 
"Got packets out of order", 

#define ER_NET_UNCOMPRESS_ERROR 1157 
"Couldn't uncompress communication packet", 

#define ER_NET_READ_ERROR 1158 
"Got an error reading communication packets", 

#define ER_NET_READ_INTERRUPTED 1159 
"Got timeout reading communication packets", 

#define ER_NET_ERROR_ON_WRITE 1160 
"Got an error writing communication packets", 

#define ER_NET_WRITE_INTERRUPTED 1161 
"Got timeout writing communication packets", 

#define ER_TOO_LONG_STRING 1162 
"Result string is longer than max_allowed_packet", 

#define ER_TABLE_CANT_HANDLE_BLOB 1163 
"The used table type doesn't support BLOB/TEXT columns", 

#define ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164 
"The used table type doesn't support AUTO_INCREMENT columns", 

#define ER_DELAYED_INSERT_TABLE_LOCKED 1165 
"INSERT DELAYED can't be used with table '%-.64s瘀牡?剕 ????o鸞? ' because it is locked with LOCK TABLES", 

#define ER_WRONG_COLUMN_NAME 1166 
"Incorrect column name '%-.100s'", 

#define ER_WRONG_KEY_COLUMN 1167 
"The used storage engine can't index column '%-.64s'", 

#define ER_WRONG_MRG_TABLE 1168 
"All tables in the MERGE table are not identically defined", 

#define ER_DUP_UNIQUE 1169 
"Can't write, because of unique constraint, to table '%-.64s'", 

#define ER_BLOB_KEY_WITHOUT_LENGTH 1170 
"BLOB/TEXT column '%-.64s' used in key specification without a key length", 

#define ER_PRIMARY_CANT_HAVE_NULL 1171 
"All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead", 

#define ER_TOO_MANY_ROWS 1172 
"Result consisted of more than one row", 

#define ER_REQUIRES_PRIMARY_KEY 1173 
"This table type requires a primary key", 

#define ER_NO_RAID_COMPILED 1174 
"This version of MySQL is not compiled with RAID support", 

#define ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE 1175 
"You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column", 

#define ER_KEY_DOES_NOT_EXITS 1176 
"Key '%-.64s' doesn't exist in table '%-.64s'", 

#define ER_CHECK_NO_SUCH_TABLE 1177 
"Can't open table", 

#define ER_CHECK_NOT_IMPLEMENTED 1178 
"The storage engine for the table doesn't support %s", 

#define ER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179 
"You are not allowed to execute this command in a transaction", 

#define ER_ERROR_DURING_COMMIT 1180 
"Got error %d during COMMIT", 

#define ER_ERROR_DURING_ROLLBACK 1181 
"Got error %d during ROLLBACK", 

#define ER_ERROR_DURING_FLUSH_LOGS 1182 
"Got error %d during FLUSH_LOGS", 

#define ER_ERROR_DURING_CHECKPOINT 1183 
"Got error %d during CHECKPOINT", 

#define ER_NEW_ABORTING_CONNECTION 1184 
"Aborted connection %ld to db: '%-.64s' user: '%-.32s' host: `%-.64s' (%-.64s)", 

#define ER_DUMP_NOT_IMPLEMENTED 1185 
"The storage engine for the table does not support binary table dump", 

#define ER_FLUSH_MASTER_BINLOG_CLOSED 1186 
"Binlog closed, cannot RESET MASTER", 

#define ER_INDEX_REBUILD 1187 
"Faile瘀牡?剕 ????o鸞? d rebuilding the index of dumped table '%-.64s'", 

#define ER_MASTER 1188 
"Error from master: '%-.64s'",