MySQL error number and JDBC corresponding SQL number corresponding to the list

Mapping MySQL Error Numbers to JDBC SQLState Codes

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	8004	8004
1042	Er_bad_host_error	8004	08s01
1043	Er_handshake_error	8004	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	2370W
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	8004	HY000
1130	Er_host_not_privileged	8004	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	2370W
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	2370W
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	1000
1250	Er_tablename_not_allowed_here	S1000	42000
1251	Er_not_supported_auth_mode	S1000	8004
1252	Er_spatial_cant_have_null	S1000	42000
1253	Er_collation_charset_mismatch	S1000	42000
1261	Er_warn_too_few_records	S1000	1000
1262	Er_warn_too_many_records	S1000	1000
1263	Er_warn_null_to_notnull	S1000	1000
1264	Er_warn_data_out_of_range	S1000	1000
1265	er_warn_data_truncated	S1000	1000
1280	Er_wrong_name_for_index	S1000	42000
1281	Er_wrong_name_for_catalog	S1000	42000
1286	Er_unknown_storage_engine	S1000	42000

MySQL error number and JDBC corresponding SQL number corresponding to the list