Skip navigation links
21.3.5 Connector/J Notes and Tips »
Section Navigation      [Toggle]

21.3.4.7. Mapping MySQL Error Numbers to SQLStates

The table below provides a mapping of the MySQL Error Numbers to SQL States

Table 21.3. Mapping of MySQL Error Numbers to SQLStates

MySQL Error Number MySQL Error Name Legacy (X/Open) SQLState SQL Standard SQLState
1022 ER_DUP_KEY S1000 23000
1037 ER_OUTOFMEMORY S1001 HY001
1038 ER_OUT_OF_SORTMEMORY S1001 HY001
1040 ER_CON_COUNT_ERROR 08004 08004
1042 ER_BAD_HOST_ERROR 08004 08S01
1043 ER_HANDSHAKE_ERROR 08004 08S01
1044 ER_DBACCESS_DENIED_ERROR S1000 42000
1045 ER_ACCESS_DENIED_ERROR 28000 28000
1047 ER_UNKNOWN_COM_ERROR 08S01 HY000
1050 ER_TABLE_EXISTS_ERROR S1000 42S01
1051 ER_BAD_TABLE_ERROR 42S02 42S02
1052 ER_NON_UNIQ_ERROR S1000 23000
1053 ER_SERVER_SHUTDOWN S1000 08S01
1054 ER_BAD_FIELD_ERROR S0022 42S22
1055 ER_WRONG_FIELD_WITH_GROUP S1009 42000
1056 ER_WRONG_GROUP_FIELD S1009 42000
1057 ER_WRONG_SUM_SELECT S1009 42000
1058 ER_WRONG_VALUE_COUNT 21S01 21S01
1059 ER_TOO_LONG_IDENT S1009 42000
1060 ER_DUP_FIELDNAME S1009 42S21
1061 ER_DUP_KEYNAME S1009 42000
1062 ER_DUP_ENTRY S1009 23000
1063 ER_WRONG_FIELD_SPEC S1009 42000
1064 ER_PARSE_ERROR 42000 42000
1065 ER_EMPTY_QUERY 42000 42000
1066 ER_NONUNIQ_TABLE S1009 42000
1067 ER_INVALID_DEFAULT S1009 42000
1068 ER_MULTIPLE_PRI_KEY S1009 42000
1069 ER_TOO_MANY_KEYS S1009 42000
1070 ER_TOO_MANY_KEY_PARTS S1009 42000
1071 ER_TOO_LONG_KEY S1009 42000
1072 ER_KEY_COLUMN_DOES_NOT_EXITS S1009 42000
1073 ER_BLOB_USED_AS_KEY S1009 42000
1074 ER_TOO_BIG_FIELDLENGTH S1009 42000
1075 ER_WRONG_AUTO_KEY S1009 42000
1080 ER_FORCING_CLOSE S1000 08S01
1081 ER_IPSOCK_ERROR 08S01 08S01
1082 ER_NO_SUCH_INDEX S1009 42S12
1083 ER_WRONG_FIELD_TERMINATORS S1009 42000
1084 ER_BLOBS_AND_NO_TERMINATED S1009 42000
1090 ER_CANT_REMOVE_ALL_FIELDS S1000 42000
1091 ER_CANT_DROP_FIELD_OR_KEY S1000 42000
1101 ER_BLOB_CANT_HAVE_DEFAULT S1000 42000
1102 ER_WRONG_DB_NAME S1000 42000
1103 ER_WRONG_TABLE_NAME S1000 42000
1104 ER_TOO_BIG_SELECT S1000 42000
1106 ER_UNKNOWN_PROCEDURE S1000 42000
1107 ER_WRONG_PARAMCOUNT_TO_PROCEDURE S1000 42000
1109 ER_UNKNOWN_TABLE S1000 42S02
1110 ER_FIELD_SPECIFIED_TWICE S1000 42000
1112 ER_UNSUPPORTED_EXTENSION S1000 42000
1113 ER_TABLE_MUST_HAVE_COLUMNS S1000 42000
1115 ER_UNKNOWN_CHARACTER_SET S1000 42000
1118 ER_TOO_BIG_ROWSIZE S1000 42000
1120 ER_WRONG_OUTER_JOIN S1000 42000
1121 ER_NULL_COLUMN_IN_INDEX S1000 42000
1129 ER_HOST_IS_BLOCKED 08004 HY000
1130 ER_HOST_NOT_PRIVILEGED 08004 HY000
1131 ER_PASSWORD_ANONYMOUS_USER S1000 42000
1132 ER_PASSWORD_NOT_ALLOWED S1000 42000
1133 ER_PASSWORD_NO_MATCH S1000 42000
1136 ER_WRONG_VALUE_COUNT_ON_ROW S1000 21S01
1138 ER_INVALID_USE_OF_NULL S1000 42000
1139 ER_REGEXP_ERROR S1000 42000
1140 ER_MIX_OF_GROUP_FUNC_AND_FIELDS S1000 42000
1141 ER_NONEXISTING_GRANT S1000 42000
1142 ER_TABLEACCESS_DENIED_ERROR S1000 42000
1143 ER_COLUMNACCESS_DENIED_ERROR S1000 42000
1144 ER_ILLEGAL_GRANT_FOR_TABLE S1000 42000
1145 ER_GRANT_WRONG_HOST_OR_USER S1000 42000
1146 ER_NO_SUCH_TABLE S1000 42S02
1147 ER_NONEXISTING_TABLE_GRANT S1000 42000
1148 ER_NOT_ALLOWED_COMMAND S1000 42000
1149 ER_SYNTAX_ERROR S1000 42000
1152 ER_ABORTING_CONNECTION S1000 08S01
1153 ER_NET_PACKET_TOO_LARGE S1000 08S01
1154 ER_NET_READ_ERROR_FROM_PIPE S1000 08S01
1155 ER_NET_FCNTL_ERROR S1000 08S01
1156 ER_NET_PACKETS_OUT_OF_ORDER S1000 08S01
1157 ER_NET_UNCOMPRESS_ERROR S1000 08S01
1158 ER_NET_READ_ERROR S1000 08S01
1159 ER_NET_READ_INTERRUPTED S1000 08S01
1160 ER_NET_ERROR_ON_WRITE S1000 08S01
1161 ER_NET_WRITE_INTERRUPTED S1000 08S01
1162 ER_TOO_LONG_STRING S1000 42000
1163 ER_TABLE_CANT_HANDLE_BLOB S1000 42000
1164 ER_TABLE_CANT_HANDLE_AUTO_INCREMENT S1000 42000
1166 ER_WRONG_COLUMN_NAME S1000 42000
1167 ER_WRONG_KEY_COLUMN S1000 42000
1169 ER_DUP_UNIQUE S1000 23000
1170 ER_BLOB_KEY_WITHOUT_LENGTH S1000 42000
1171 ER_PRIMARY_CANT_HAVE_NULL S1000 42000
1172 ER_TOO_MANY_ROWS S1000 42000
1173 ER_REQUIRES_PRIMARY_KEY S1000 42000
1177 ER_CHECK_NO_SUCH_TABLE S1000 42000
1178 ER_CHECK_NOT_IMPLEMENTED S1000 42000
1179 ER_CANT_DO_THIS_DURING_AN_TRANSACTION S1000 25000
1184 ER_NEW_ABORTING_CONNECTION S1000 08S01
1189 ER_MASTER_NET_READ S1000 08S01
1190 ER_MASTER_NET_WRITE S1000 08S01
1203 ER_TOO_MANY_USER_CONNECTIONS S1000 42000
1205 ER_LOCK_WAIT_TIMEOUT 41000 41000
1207 ER_READ_ONLY_TRANSACTION S1000 25000
1211 ER_NO_PERMISSION_TO_CREATE_USER S1000 42000
1213 ER_LOCK_DEADLOCK 41000 40001
1216 ER_NO_REFERENCED_ROW S1000 23000
1217 ER_ROW_IS_REFERENCED S1000 23000
1218 ER_CONNECT_TO_MASTER S1000 08S01
1222 ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT S1000 21000
1226 ER_USER_LIMIT_REACHED S1000 42000
1230 ER_NO_DEFAULT S1000 42000
1231 ER_WRONG_VALUE_FOR_VAR S1000 42000
1232 ER_WRONG_TYPE_FOR_VAR S1000 42000
1234 ER_CANT_USE_OPTION_HERE S1000 42000
1235 ER_NOT_SUPPORTED_YET S1000 42000
1239 ER_WRONG_FK_DEF S1000 42000
1241 ER_OPERAND_COLUMNS S1000 21000
1242 ER_SUBQUERY_NO_1_ROW S1000 21000
1247 ER_ILLEGAL_REFERENCE S1000 42S22
1248 ER_DERIVED_MUST_HAVE_ALIAS S1000 42000
1249 ER_SELECT_REDUCED S1000 01000
1250 ER_TABLENAME_NOT_ALLOWED_HERE S1000 42000
1251 ER_NOT_SUPPORTED_AUTH_MODE S1000 08004
1252 ER_SPATIAL_CANT_HAVE_NULL S1000 42000
1253 ER_COLLATION_CHARSET_MISMATCH S1000 42000
1261 ER_WARN_TOO_FEW_RECORDS S1000 01000
1262 ER_WARN_TOO_MANY_RECORDS S1000 01000
1263 ER_WARN_NULL_TO_NOTNULL S1000 01000
1264 ER_WARN_DATA_OUT_OF_RANGE S1000 01000
1265 ER_WARN_DATA_TRUNCATED S1000 01000
1280 ER_WRONG_NAME_FOR_INDEX S1000 42000
1281 ER_WRONG_NAME_FOR_CATALOG S1000 42000
1286 ER_UNKNOWN_STORAGE_ENGINE S1000 42000