发布日期:2016-01-08 14:55:22

收集一下MySQL的错误代码以及名称:

 

MySQL Error Number

MySQL Error Name

Legacy (X/Open) SQLState

SQL Standard SQLState

1022

ER_DUP_KEY

23000

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

42000

42000

1045

ER_ACCESS_DENIED_ERROR

28000

28000

1046

ER_NO_DB_ERROR

3D000

3D000

1047

ER_UNKNOWN_COM_ERROR

08S01

08S01

1048

ER_BAD_NULL_ERROR

23000

23000

1049

ER_BAD_DB_ERROR

42000

42000

1050

ER_TABLE_EXISTS_ERROR

42S01

42S01

1051

ER_BAD_TABLE_ERROR

42S02

42S02

1052

ER_NON_UNIQ_ERROR

23000

23000

1053

ER_SERVER_SHUTDOWN

08S01

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

08S01

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

42000

42000

1091

ER_CANT_DROP_FIELD_OR_KEY

42000

42000

1101

ER_BLOB_CANT_HAVE_DEFAULT

42000

42000

1102

ER_WRONG_DB_NAME

42000

42000

1103

ER_WRONG_TABLE_NAME

42000

42000

1104

ER_TOO_BIG_SELECT

42000

42000

1106

ER_UNKNOWN_PROCEDURE

42000

42000

1107

ER_WRONG_PARAMCOUNT_TO_PROCEDURE

42000

42000

1109

ER_UNKNOWN_TABLE

42S02

42S02

1110

ER_FIELD_SPECIFIED_TWICE

42000

42000

1112

ER_UNSUPPORTED_EXTENSION

42000

42000

1113

ER_TABLE_MUST_HAVE_COLUMNS

42000

42000

1115

ER_UNKNOWN_CHARACTER_SET

42000

42000

1118

ER_TOO_BIG_ROWSIZE

42000

42000

1120

ER_WRONG_OUTER_JOIN

42000

42000

1121

ER_NULL_COLUMN_IN_INDEX

42000

42000

1129

ER_HOST_IS_BLOCKED

08004

HY000

1130

ER_HOST_NOT_PRIVILEGED

08004

HY000

1131

ER_PASSWORD_ANONYMOUS_USER

42000

42000

1132

ER_PASSWORD_NOT_ALLOWED

42000

42000

1133

ER_PASSWORD_NO_MATCH

42000

42000

1136

ER_WRONG_VALUE_COUNT_ON_ROW

21S01

21S01

1138

ER_INVALID_USE_OF_NULL

S1000

42000

1139

ER_REGEXP_ERROR

42000

42000

1140

ER_MIX_OF_GROUP_FUNC_AND_FIELDS

42000

42000

1141

ER_NONEXISTING_GRANT

42000

42000

1142

ER_TABLEACCESS_DENIED_ERROR

42000

42000

1143

ER_COLUMNACCESS_DENIED_ERROR

42000

42000

1144

ER_ILLEGAL_GRANT_FOR_TABLE

42000

42000

1145

ER_GRANT_WRONG_HOST_OR_USER

42000

42000

1146

ER_NO_SUCH_TABLE

42S02

42S02

1147

ER_NONEXISTING_TABLE_GRANT

42000

42000

1148

ER_NOT_ALLOWED_COMMAND

42000

42000

1149

ER_SYNTAX_ERROR

42000

42000

1152

ER_ABORTING_CONNECTION

08S01

08S01

1153

ER_NET_PACKET_TOO_LARGE

08S01

08S01

1154

ER_NET_READ_ERROR_FROM_PIPE

08S01

08S01

1155

ER_NET_FCNTL_ERROR

08S01

08S01

1156

ER_NET_PACKETS_OUT_OF_ORDER

08S01

08S01

1157

ER_NET_UNCOMPRESS_ERROR

08S01

08S01

1158

ER_NET_READ_ERROR

08S01

08S01

1159

ER_NET_READ_INTERRUPTED

08S01

08S01

1160

ER_NET_ERROR_ON_WRITE

08S01

08S01

1161

ER_NET_WRITE_INTERRUPTED

08S01

08S01

1162

ER_TOO_LONG_STRING

42000

42000

1163

ER_TABLE_CANT_HANDLE_BLOB

42000

42000

1164

ER_TABLE_CANT_HANDLE_AUTO_INCREMENT

42000

42000

1166

ER_WRONG_COLUMN_NAME

42000

42000

1167

ER_WRONG_KEY_COLUMN

42000

42000

1169

ER_DUP_UNIQUE

23000

23000

1170

ER_BLOB_KEY_WITHOUT_LENGTH

42000

42000

1171

ER_PRIMARY_CANT_HAVE_NULL

42000

42000

1172

ER_TOO_MANY_ROWS

42000

42000

1173

ER_REQUIRES_PRIMARY_KEY

42000

42000

1176

ER_KEY_DOES_NOT_EXITS

42000

42000

1177

ER_CHECK_NO_SUCH_TABLE

42000

42000

1178

ER_CHECK_NOT_IMPLEMENTED

42000

42000

1179

ER_CANT_DO_THIS_DURING_AN_TRANSACTION

25000

25000

1184

ER_NEW_ABORTING_CONNECTION

08S01

08S01

1189

ER_MASTER_NET_READ

08S01

08S01

1190

ER_MASTER_NET_WRITE

08S01

08S01

1203

ER_TOO_MANY_USER_CONNECTIONS

42000

42000

1205

ER_LOCK_WAIT_TIMEOUT

40001

40001

1207

ER_READ_ONLY_TRANSACTION

25000

25000

1211

ER_NO_PERMISSION_TO_CREATE_USER

42000

42000

1213

ER_LOCK_DEADLOCK

40001

40001

1216

ER_NO_REFERENCED_ROW

23000

23000

1217

ER_ROW_IS_REFERENCED

23000

23000

1218

ER_CONNECT_TO_MASTER

08S01

08S01

1222

ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT

21000

21000

1226

ER_USER_LIMIT_REACHED

42000

42000

1227

ER_SPECIFIC_ACCESS_DENIED_ERROR

42000

42000

1230

ER_NO_DEFAULT

42000

42000

1231

ER_WRONG_VALUE_FOR_VAR

42000

42000

1232

ER_WRONG_TYPE_FOR_VAR

42000

42000

1234

ER_CANT_USE_OPTION_HERE

42000

42000

1235

ER_NOT_SUPPORTED_YET

42000

42000

1239

ER_WRONG_FK_DEF

42000

42000

1241

ER_OPERAND_COLUMNS

21000

21000

1242

ER_SUBQUERY_NO_1_ROW

21000

21000

1247

ER_ILLEGAL_REFERENCE

42S22

42S22

1248

ER_DERIVED_MUST_HAVE_ALIAS

42000

42000

1249

ER_SELECT_REDUCED

01000

01000

1250

ER_TABLENAME_NOT_ALLOWED_HERE

42000

42000

1251

ER_NOT_SUPPORTED_AUTH_MODE

08004

08004

1252

ER_SPATIAL_CANT_HAVE_NULL

42000

42000

1253

ER_COLLATION_CHARSET_MISMATCH

42000

42000

1261

ER_WARN_TOO_FEW_RECORDS

01000

01000

1262

ER_WARN_TOO_MANY_RECORDS

01000

01000

1263

ER_WARN_NULL_TO_NOTNULL

S1000

01000

1264

ER_WARN_DATA_OUT_OF_RANGE

01000

01000

1265

ER_WARN_DATA_TRUNCATED

01000

01000

1280

ER_WRONG_NAME_FOR_INDEX

42000

42000

1281

ER_WRONG_NAME_FOR_CATALOG

42000

42000

1286

ER_UNKNOWN_STORAGE_ENGINE

42000

42000

1292

ER_TRUNCATED_WRONG_VALUE

22007

22007

1303

ER_SP_NO_RECURSIVE_CREATE

S1000

2F003

1304

ER_SP_ALREADY_EXISTS

42000

42000

1305

ER_SP_DOES_NOT_EXIST

42000

42000

1308

ER_SP_LILABEL_MISMATCH

42000

42000

1309

ER_SP_LABEL_REDEFINE

42000

42000

1310

ER_SP_LABEL_MISMATCH

42000

42000

1311

ER_SP_UNINIT_VAR

01000

01000

1312

ER_SP_BADSELECT

0A000

0A000

1313

ER_SP_BADRETURN

42000

42000

1314

ER_SP_BADSTATEMENT

0A000

0A000

1315

ER_UPDATE_LOG_DEPRECATED_IGNORED

42000

42000

1316

ER_UPDATE_LOG_DEPRECATED_TRANSLATED

42000

42000

1317

ER_QUERY_INTERRUPTED

S1000

70100

1318

ER_SP_WRONG_NO_OF_ARGS

42000

42000

1319

ER_SP_COND_MISMATCH

42000

42000

1320

ER_SP_NORETURN

42000

42000

1321

ER_SP_NORETURNEND

S1000

2F005

1322

ER_SP_BAD_CURSOR_QUERY

42000

42000

1323

ER_SP_BAD_CURSOR_SELECT

42000

42000

1324

ER_SP_CURSOR_MISMATCH

42000

42000

1325

ER_SP_CURSOR_ALREADY_OPEN

24000

24000

1326

ER_SP_CURSOR_NOT_OPEN

24000

24000

1327

ER_SP_UNDECLARED_VAR

42000

42000

1329

ER_SP_FETCH_NO_DATA

S1000

02000

1330

ER_SP_DUP_PARAM

42000

42000

1331

ER_SP_DUP_VAR

42000

42000

1332

ER_SP_DUP_COND

42000

42000

1333

ER_SP_DUP_CURS

42000

42000

1335

ER_SP_SUBSELECT_NYI

0A000

0A000

1336

ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG

0A000

0A000

1337

ER_SP_VARCOND_AFTER_CURSHNDLR

42000

42000

1338

ER_SP_CURSOR_AFTER_HANDLER

42000

42000

1339

ER_SP_CASE_NOT_FOUND

S1000

20000

1365

ER_DIVISION_BY_ZERO

22012

22012

1367

ER_ILLEGAL_VALUE_FOR_TYPE

22007

22007

1370

ER_PROCACCESS_DENIED_ERROR

42000

42000

1397

ER_XAER_NOTA

S1000

XAE04

1398

ER_XAER_INVAL

S1000

XAE05

1399

ER_XAER_RMFAIL

S1000

XAE07

1400

ER_XAER_OUTSIDE

S1000

XAE09

1401

ER_XA_RMERR

S1000

XAE03

1402

ER_XA_RBROLLBACK

S1000

XA100

1403

ER_NONEXISTING_PROC_GRANT

42000

42000

1406

ER_DATA_TOO_LONG

22001

22001

1407

ER_SP_BAD_SQLSTATE

42000

42000

1410

ER_CANT_CREATE_USER_WITH_GRANT

42000

42000

1413

ER_SP_DUP_HANDLER

42000

42000

1414

ER_SP_NOT_VAR_ARG

42000

42000

1415

ER_SP_NO_RETSET

0A000

0A000

1416

ER_CANT_CREATE_GEOMETRY_OBJECT

22003

22003

1425

ER_TOO_BIG_SCALE

42000

42000

1426

ER_TOO_BIG_PRECISION

42000

42000

1427

ER_M_BIGGER_THAN_D

42000

42000

1437

ER_TOO_LONG_BODY

42000

42000

1439

ER_TOO_BIG_DISPLAYWIDTH

42000

42000

1440

ER_XAER_DUPID

S1000

XAE08

1441

ER_DATETIME_FUNCTION_OVERFLOW

22008

22008

1451

ER_ROW_IS_REFERENCED_2

23000

23000

1452

ER_NO_REFERENCED_ROW_2

23000

23000

1453

ER_SP_BAD_VAR_SHADOW

42000

42000

1458

ER_SP_WRONG_NAME

42000

42000

1460

ER_SP_NO_AGGREGATE

42000

42000

1461

ER_MAX_PREPARED_STMT_COUNT_REACHED

42000

42000

1463

ER_NON_GROUPING_FIELD_USED

42000

42000

1557

ER_FOREIGN_DUPLICATE_KEY

23000

23000

1568

ER_CANT_CHANGE_TX_ISOLATION

S1000

25001

1582

ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT

42000

42000

1583

ER_WRONG_PARAMETERS_TO_NATIVE_FCT

42000

42000

1584

ER_WRONG_PARAMETERS_TO_STORED_FCT

42000

42000

1586

ER_DUP_ENTRY_WITH_KEY_NAME

23000

23000

1613

ER_XA_RBTIMEOUT

S1000

XA106

1614

ER_XA_RBDEADLOCK

S1000

XA102

1630

ER_FUNC_INEXISTENT_NAME_COLLISION

42000

42000

1641

ER_DUP_SIGNAL_SET

42000

42000

1642

ER_SIGNAL_WARN

01000

01000

1643

ER_SIGNAL_NOT_FOUND

S1000

02000

1645

ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER

S1000

0K000

1687

ER_SPATIAL_MUST_HAVE_GEOM_COL

42000

42000

1690

ER_DATA_OUT_OF_RANGE

22003

22003

1698

ER_ACCESS_DENIED_NO_PASSWORD_ERROR

28000

28000

1701

ER_TRUNCATE_ILLEGAL_FK

42000

42000

1758

ER_DA_INVALID_CONDITION_NUMBER

35000

35000

1761

ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO

23000

23000

1762

ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO

23000

23000

1792

ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION

S1000

25006

1845

ER_ALTER_OPERATION_NOT_SUPPORTED

0A000

0A000

1846

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON

0A000

0A000

1859

ER_DUP_UNKNOWN_IN_INDEX

23000

23000

1873

ER_ACCESS_DENIED_CHANGE_USER_ERROR

28000

28000

1887

ER_GET_STACKED_DA_WITHOUT_ACTIVE_HANDLER

S1000

0Z002

1903

ER_INVALID_ARGUMENT_FOR_LOGARITHM

S1000

2201E

发表评论