Voici la liste des erreurs que vous pouvez rencontrer lorsque
vous utilisez MySQL sur un serveur ayant le support de la langue locale.
Les colonnes
|
Nom
|
Code d'erreur
|
SQLSTATE
|
| ER_HASHCHK |
1000 |
HY000
|
| ER_NISAMCHK |
1001 |
HY000
|
| ER_NO |
1002 |
HY000
|
| ER_YES |
1003 |
HY000
|
| ER_CANT_CREATE_FILE |
1004 |
HY000
|
| ER_CANT_CREATE_TABLE |
1005 |
HY000
|
| ER_CANT_CREATE_DB |
1006 |
HY000
|
| ER_DB_CREATE_EXISTS |
1007 |
HY000
|
| ER_DB_DROP_EXISTS |
1008 |
HY000
|
| ER_DB_DROP_DELETE |
1009 |
HY000
|
| ER_DB_DROP_RMDIR |
1010 |
HY000
|
| ER_CANT_DELETE_FILE |
1011 |
HY000
|
| ER_CANT_FIND_SYSTEM_REC |
1012 |
HY000
|
| ER_CANT_GET_STAT |
1013 |
HY000
|
| ER_CANT_GET_WD |
1014 |
HY000
|
| ER_CANT_LOCK |
1015 |
HY000
|
| ER_CANT_OPEN_FILE |
1016 |
HY000
|
| ER_FILE_NOT_FOUND |
1017 |
HY000
|
| ER_CANT_READ_DIR |
1018 |
HY000
|
| ER_CANT_SET_WD |
1019 |
HY000
|
| ER_CHECKREAD |
1020 |
HY000
|
| ER_DISK_FULL |
1021 |
HY000
|
| ER_DUP_KEY |
1022 |
23000
|
| ER_ERROR_ON_CLOSE |
1023 |
HY000
|
| ER_ERROR_ON_READ |
1024 |
HY000
|
| ER_ERROR_ON_RENAME |
1025 |
HY000
|
| ER_ERROR_ON_WRITE |
1026 |
HY000
|
| ER_FILE_USED |
1027 |
HY000
|
| ER_FILSORT_ABORT |
1028 |
HY000
|
| ER_FORM_NOT_FOUND |
1029 |
HY000
|
| ER_GET_ERRNO |
1030 |
HY000
|
| ER_ILLEGAL_HA |
1031 |
HY000
|
| ER_KEY_NOT_FOUND |
1032 |
HY000
|
| ER_NOT_FORM_FILE |
1033 |
HY000
|
| ER_NOT_KEYFILE |
1034 |
HY000
|
| ER_OLD_KEYFILE |
1035 |
HY000
|
| ER_OPEN_AS_READONLY |
1036 |
HY000
|
| ER_OUTOFMEMORY |
1037 |
HY001
|
| ER_OUT_OF_SORTMEMORY |
1038 |
HY001
|
| ER_UNEXPECTED_EOF |
1039 |
HY000
|
| ER_CON_COUNT_ERROR |
1040 |
08004
|
| ER_OUT_OF_RESOURCES |
1041 |
08004
|
| ER_BAD_HOST_ERROR |
1042 |
08S01
|
| ER_HANDSHAKE_ERROR |
1043 |
08S01
|
| ER_DBACCESS_DENIED_ERROR |
1044 |
42000
|
| ER_ACCESS_DENIED_ERROR |
1045 |
42000
|
| ER_NO_DB_ERROR |
1046 |
42000
|
| ER_UNKNOWN_COM_ERROR |
1047 |
08S01
|
| ER_BAD_NULL_ERROR |
1048 |
23000
|
| ER_BAD_DB_ERROR |
1049 |
42000
|
| ER_TABLE_EXISTS_ERROR |
1050 |
42S01
|
| ER_BAD_TABLE_ERROR |
1051 |
42S02
|
| ER_NON_UNIQ_ERROR |
1052 |
23000
|
| ER_SERVER_SHUTDOWN |
1053 |
08S01
|
| ER_BAD_FIELD_ERROR |
1054 |
42S22
|
| ER_WRONG_FIELD_WITH_GROUP |
1055 |
42000
|
| ER_WRONG_GROUP_FIELD |
1056 |
42000
|
| ER_WRONG_SUM_SELECT |
1057 |
42000
|
| ER_WRONG_VALUE_COUNT |
1058 |
21S01
|
| ER_TOO_LONG_IDENT |
1059 |
42000
|
| ER_DUP_FIELDNAME |
1060 |
42S21
|
| ER_DUP_KEYNAME |
1061 |
42000
|
| ER_DUP_ENTRY |
1062 |
23000
|
| ER_WRONG_FIELD_SPEC |
1063 |
42000
|
| ER_PARSE_ERROR |
1064 |
42000
|
| ER_EMPTY_QUERY |
1065 |
42000
|
| ER_NONUNIQ_TABLE |
1066 |
42000
|
| ER_INVALID_DEFAULT |
1067 |
42000
|
| ER_MULTIPLE_PRI_KEY |
1068 |
42000
|
| ER_TOO_MANY_KEYS |
1069 |
42000
|
| ER_TOO_MANY_KEY_PARTS |
1070 |
42000
|
| ER_TOO_LONG_KEY |
1071 |
42000
|
| ER_KEY_COLUMN_DOES_NOT_EXITS |
1072 |
42000
|
| ER_BLOB_USED_AS_KEY |
1073 |
42000
|
| ER_TOO_BIG_FIELDLENGTH |
1074 |
42000
|
| ER_WRONG_AUTO_KEY |
1075 |
42000
|
| ER_READY |
1076 |
00000
|
| ER_NORMAL_SHUTDOWN |
1077 |
00000
|
| ER_GOT_SIGNAL |
1078 |
00000
|
| ER_SHUTDOWN_COMPLETE |
1079 |
00000
|
| ER_FORCING_CLOSE |
1080 |
08S01
|
| ER_IPSOCK_ERROR |
1081 |
08S01
|
| ER_NO_SUCH_INDEX |
1082 |
42S12
|
| ER_WRONG_FIELD_TERMINATORS |
1083 |
42000
|
| ER_BLOBS_AND_NO_TERMINATED |
1084 |
42000
|
| ER_TEXTFILE_NOT_READABLE |
1085 |
HY000
|
| ER_FILE_EXISTS_ERROR |
1086 |
HY000
|
| ER_LOAD_INFO |
1087 |
HY000
|
| ER_ALTER_INFO |
1088 |
HY000
|
| ER_WRONG_SUB_KEY |
1089 |
HY000
|
| ER_CANT_REMOVE_ALL_FIELDS |
1090 |
42000
|
| ER_CANT_DROP_FIELD_OR_KEY |
1091 |
42000
|
| ER_INSERT_INFO |
1092 |
HY000
|
| ER_UPDATE_TABLE_USED |
1093 |
HY000
|
| ER_NO_SUCH_THREAD |
1094 |
HY000
|
| ER_KILL_DENIED_ERROR |
1095 |
HY000
|
| ER_NO_TABLES_USED |
1096 |
HY000
|
| ER_TOO_BIG_SET |
1097 |
HY000
|
| ER_NO_UNIQUE_LOGFILE |
1098 |
HY000
|
| ER_TABLE_NOT_LOCKED_FOR_WRITE |
1099 |
HY000
|
| ER_TABLE_NOT_LOCKED |
1100 |
HY000
|
| ER_BLOB_CANT_HAVE_DEFAULT |
1101 |
42000
|
| ER_WRONG_DB_NAME |
1102 |
42000
|
| ER_WRONG_TABLE_NAME |
1103 |
42000
|
| ER_TOO_BIG_SELECT |
1104 |
42000
|
| ER_UNKNOWN_ERROR |
1105 |
HY000
|
| ER_UNKNOWN_PROCEDURE |
1106 |
42000
|
| ER_WRONG_PARAMCOUNT_TO_PROCEDURE |
1107 |
42000
|
| ER_WRONG_PARAMETERS_TO_PROCEDURE |
1108 |
HY000
|
| ER_UNKNOWN_TABLE |
1109 |
42S02
|
| ER_FIELD_SPECIFIED_TWICE |
1110 |
42000
|
| ER_INVALID_GROUP_FUNC_USE |
1111 |
42000
|
| ER_UNSUPPORTED_EXTENSION |
1112 |
42000
|
| ER_TABLE_MUST_HAVE_COLUMNS |
1113 |
42000
|
| ER_RECORD_FILE_FULL |
1114 |
HY000
|
| ER_UNKNOWN_CHARACTER_SET |
1115 |
42000
|
| ER_TOO_MANY_TABLES |
1116 |
HY000
|
| ER_TOO_MANY_FIELDS |
1117 |
HY000
|
| ER_TOO_BIG_ROWSIZE |
1118 |
42000
|
| ER_STACK_OVERRUN |
1119 |
HY000
|
| ER_WRONG_OUTER_JOIN |
1120 |
42000
|
| ER_NULL_COLUMN_IN_INDEX |
1121 |
42000
|
| ER_CANT_FIND_UDF |
1122 |
HY000
|
| ER_CANT_INITIALIZE_UDF |
1123 |
HY000
|
| ER_UDF_NO_PATHS |
1124 |
HY000
|
| ER_UDF_EXISTS |
1125 |
HY000
|
| ER_CANT_OPEN_LIBRARY |
1126 |
HY000
|
| ER_CANT_FIND_DL_ENTRY |
1127 |
HY000
|
| ER_FUNCTION_NOT_DEFINED |
1128 |
HY000
|
| ER_HOST_IS_BLOCKED |
1129 |
HY000
|
| ER_HOST_NOT_PRIVILEGED |
1130 |
HY000
|
| ER_PASSWORD_ANONYMOUS_USER |
1131 |
42000
|
| ER_PASSWORD_NOT_ALLOWED |
1132 |
42000
|
| ER_PASSWORD_NO_MATCH |
1133 |
42000
|
| ER_UPDATE_INFO |
1134 |
HY000
|
| ER_CANT_CREATE_THREAD |
1135 |
HY000
|
| ER_WRONG_VALUE_COUNT_ON_ROW |
1136 |
21S01
|
| ER_CANT_REOPEN_TABLE |
1137 |
HY000
|
| ER_INVALID_USE_OF_NULL |
1138 |
42000
|
| ER_REGEXP_ERROR |
1139 |
42000
|
| ER_MIX_OF_GROUP_FUNC_AND_FIELDS |
1140 |
42000
|
| ER_NONEXISTING_GRANT |
1141 |
42000
|
| ER_TABLEACCESS_DENIED_ERROR |
1142 |
42000
|
| ER_COLUMNACCESS_DENIED_ERROR |
1143 |
42000
|
| ER_ILLEGAL_GRANT_FOR_TABLE |
1144 |
42000
|
| ER_GRANT_WRONG_HOST_OR_USER |
1145 |
42000
|
| ER_NO_SUCH_TABLE |
1146 |
42S02
|
| ER_NONEXISTING_TABLE_GRANT |
1147 |
42000
|
| ER_NOT_ALLOWED_COMMAND |
1148 |
42000
|
| ER_SYNTAX_ERROR |
1149 |
42000
|
| ER_DELAYED_CANT_CHANGE_LOCK |
1150 |
HY000
|
| ER_TOO_MANY_DELAYED_THREADS |
1151 |
HY000
|
| ER_ABORTING_CONNECTION |
1152 |
08S01
|
| ER_NET_PACKET_TOO_LARGE |
1153 |
08S01
|
| ER_NET_READ_ERROR_FROM_PIPE |
1154 |
08S01
|
| ER_NET_FCNTL_ERROR |
1155 |
08S01
|
| ER_NET_PACKETS_OUT_OF_ORDER |
1156 |
08S01
|
| ER_NET_UNCOMPRESS_ERROR |
1157 |
08S01
|
| ER_NET_READ_ERROR |
1158 |
08S01
|
| ER_NET_READ_INTERRUPTED |
1159 |
08S01
|
| ER_NET_ERROR_ON_WRITE |
1160 |
08S01
|
| ER_NET_WRITE_INTERRUPTED |
1161 |
08S01
|
| ER_TOO_LONG_STRING |
1162 |
42000
|
| ER_TABLE_CANT_HANDLE_BLOB |
1163 |
42000
|
| ER_TABLE_CANT_HANDLE_AUTO_INCREMENT |
1164 |
42000
|
| ER_DELAYED_INSERT_TABLE_LOCKED |
1165 |
HY000
|
| ER_WRONG_COLUMN_NAME |
1166 |
42000
|
| ER_WRONG_KEY_COLUMN |
1167 |
42000
|
| ER_WRONG_MRG_TABLE |
1168 |
HY000
|
| ER_DUP_UNIQUE |
1169 |
23000
|
| ER_BLOB_KEY_WITHOUT_LENGTH |
1170 |
42000
|
| ER_PRIMARY_CANT_HAVE_NULL |
1171 |
42000
|
| ER_TOO_MANY_ROWS |
1172 |
42000
|
| ER_REQUIRES_PRIMARY_KEY |
1173 |
42000
|
| ER_NO_RAID_COMPILED |
1174 |
HY000
|
| ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE |
1175 |
HY000
|
| ER_KEY_DOES_NOT_EXITS |
1176 |
HY000
|
| ER_CHECK_NO_SUCH_TABLE |
1177 |
42000
|
| ER_CHECK_NOT_IMPLEMENTED |
1178 |
42000
|
| ER_CANT_DO_THIS_DURING_AN_TRANSACTION |
1179 |
25000
|
| ER_ERROR_DURING_COMMIT |
1180 |
HY000
|
| ER_ERROR_DURING_ROLLBACK |
1181 |
HY000
|
| ER_ERROR_DURING_FLUSH_LOGS |
1182 |
HY000
|
| ER_ERROR_DURING_CHECKPOINT |
1183 |
HY000
|
| ER_NEW_ABORTING_CONNECTION |
1184 |
08S01
|
| ER_DUMP_NOT_IMPLEMENTED |
1185 |
HY000
|
| ER_FLUSH_MASTER_BINLOG_CLOSED |
1186 |
HY000
|
| ER_INDEX_REBUILD |
1187 |
HY000
|
| ER_MASTER |
1188 |
HY000
|
| ER_MASTER_NET_READ |
1189 |
08S01
|
| ER_MASTER_NET_WRITE |
1190 |
08S01
|
| ER_FT_MATCHING_KEY_NOT_FOUND |
1191 |
HY000
|
| ER_LOCK_OR_ACTIVE_TRANSACTION |
1192 |
HY000
|
| ER_UNKNOWN_SYSTEM_VARIABLE |
1193 |
HY000
|
| ER_CRASHED_ON_USAGE |
1194 |
HY000
|
| ER_CRASHED_ON_REPAIR |
1195 |
HY000
|
| ER_WARNING_NOT_COMPLETE_ROLLBACK |
1196 |
HY000
|
| ER_TRANS_CACHE_FULL |
1197 |
HY000
|
| ER_SLAVE_MUST_STOP |
1198 |
HY000
|
| ER_SLAVE_NOT_RUNNING |
1199 |
HY000
|
| ER_BAD_SLAVE |
1200 |
HY000
|
| ER_MASTER_INFO |
1201 |
HY000
|
| ER_SLAVE_THREAD |
1202 |
HY000
|
| ER_TOO_MANY_USER_CONNECTIONS |
1203 |
42000
|
| ER_SET_CONSTANTS_ONLY |
1204 |
HY000
|
| ER_LOCK_WAIT_TIMEOUT |
1205 |
HY000
|
| ER_LOCK_TABLE_FULL |
1206 |
HY000
|
| ER_READ_ONLY_TRANSACTION |
1207 |
25000
|
| ER_DROP_DB_WITH_READ_LOCK |
1208 |
HY000
|
| ER_CREATE_DB_WITH_READ_LOCK |
1209 |
HY000
|
| ER_WRONG_ARGUMENTS |
1210 |
HY000
|
| ER_NO_PERMISSION_TO_CREATE_USER |
1211 |
42000
|
| ER_UNION_TABLES_IN_DIFFERENT_DIR |
1212 |
HY000
|
| ER_LOCK_DEADLOCK |
1213 |
40001
|
| ER_TABLE_CANT_HANDLE_FULLTEXT |
1214 |
HY000
|
| ER_CANNOT_ADD_FOREIGN |
1215 |
HY000
|
| ER_NO_REFERENCED_ROW |
1216 |
23000
|
| ER_ROW_IS_REFERENCED |
1217 |
23000
|
| ER_CONNECT_TO_MASTER |
1218 |
08S01
|
| ER_QUERY_ON_MASTER |
1219 |
HY000
|
| ER_ERROR_WHEN_EXECUTING_COMMAND |
1220 |
HY000
|
| ER_WRONG_USAGE |
1221 |
HY000
|
| ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT |
1222 |
21000
|
| ER_CANT_UPDATE_WITH_READLOCK |
1223 |
HY000
|
| ER_MIXING_NOT_ALLOWED |
1224 |
HY000
|
| ER_DUP_ARGUMENT |
1225 |
HY000
|
| ER_USER_LIMIT_REACHED |
1226 |
42000
|
| ER_SPECIFIC_ACCESS_DENIED_ERROR |
1227 |
HY000
|
| ER_LOCAL_VARIABLE |
1228 |
HY000
|
| ER_GLOBAL_VARIABLE |
1229 |
HY000
|
| ER_NO_DEFAULT |
1230 |
42000
|
| ER_WRONG_VALUE_FOR_VAR |
1231 |
42000
|
| ER_WRONG_TYPE_FOR_VAR |
1232 |
42000
|
| ER_VAR_CANT_BE_READ |
1233 |
HY000
|
| ER_CANT_USE_OPTION_HERE |
1234 |
42000
|
| ER_NOT_SUPPORTED_YET |
1235 |
42000
|
| ER_MASTER_FATAL_ERROR_READING_BINLOG |
1236 |
HY000
|
| ER_SLAVE_IGNORED_TABLE |
1237 |
HY000
|
| ER_WRONG_FK_DEF |
1238 |
42000
|
| ER_KEY_REF_DO_NOT_MATCH_TABLE_REF |
1239 |
HY000
|
| ER_CARDINALITY_COL |
1240 |
21000
|
| ER_SUBSELECT_NO_1_ROW |
1241 |
21000
|
| ER_UNKNOWN_STMT_HANDLER |
1242 |
HY000
|
| ER_CORRUPT_HELP_DB |
1243 |
HY000
|
| ER_CYCLIC_REFERENCE |
1244 |
HY000
|
| ER_AUTO_CONVERT |
1245 |
HY000
|
| ER_ILLEGAL_REFERENCE |
1246 |
42S22
|
| ER_DERIVED_MUST_HAVE_ALIAS |
1247 |
42000
|
| ER_SELECT_REDUCED |
1248 |
01000
|
| ER_TABLENAME_NOT_ALLOWED_HERE |
1249 |
42000
|
| ER_NOT_SUPPORTED_AUTH_MODE |
1250 |
08004
|
| ER_SPATIAL_CANT_HAVE_NULL |
1251 |
42000
|
| ER_COLLATION_CHARSET_MISMATCH |
1252 |
42000
|
| ER_SLAVE_WAS_RUNNING |
1253 |
HY000
|
| ER_SLAVE_WAS_NOT_RUNNING |
1254 |
HY000
|
| ER_TOO_BIG_FOR_UNCOMPRESS |
1255 |
HY000
|
| ER_ZLIB_Z_MEM_ERROR |
1256 |
HY000
|
| ER_ZLIB_Z_BUF_ERROR |
1257 |
HY000
|
| ER_ZLIB_Z_DATA_ERROR |
1258 |
HY000
|
| ER_CUT_VALUE_GROUP_CONCAT |
1259 |
HY000
|
| ER_WARN_TOO_FEW_RECORDS |
1260 |
01000
|
| ER_WARN_TOO_MANY_RECORDS |
1261 |
01000
|
| ER_WARN_NULL_TO_NOTNULL |
1262 |
01000
|
| ER_WARN_DATA_OUT_OF_RANGE |
1263 |
01000
|
| ER_WARN_DATA_TRUNCATED |
1264 |
01000
|
| ER_WARN_USING_OTHER_HANDLER |
1265 |
01000
|
| ER_CANT_AGGREGATE_COLLATIONS |
1266 |
42000
|
| ER_DROP_USER |
1267 |
42000
|
| ER_REVOKE_GRANTS |
1268 |
42000
|
| ER_CANT_AGGREGATE_3COLLATIONS |
1269 |
42000
|
| ER_CANT_AGGREGATE_NCOLLATIONS |
1270 |
42000
|
| ER_VARIABLE_IS_NOT_STRUCT |
1271 |
HY000
|
| ER_UNKNOWN_COLLATION |
1272 |
HY000
|
| ER_SLAVE_IGNORED_SSL_PARAMS |
1273 |
HY000
|
| ER_SERVER_IS_IN_SECURE_AUTH_MODE |
1274 |
HY000
|
| ER_WARN_FIELD_RESOLVED |
1275 |
HY000
|
| ER_BAD_SLAVE_UNTIL_COND |
1276 |
HY000
|
| ER_MISSING_SKIP_SLAVE |
1277 |
HY000
|
| ER_UNTIL_COND_IGNORED |
1278 |
HY000 |