mysql中常见错误代码汇总

我们操作mysql的时候经常会遇到一些错误并给出错误的代码,很难知道它是什么意思,下面给出常见的错误代码,方便查阅:

1005：创建表失败

1006：创建数据库失败

1007：数据库已存在，创建数据库失败

1008：数据库不存在，删除数据库失败

1009：不能删除数据库文件导致删除数据库失败

1010：不能删除数据目录导致删除数据库失败

1011：删除数据库文件失败

1012：不能读取系统表中的记录

1016错误：文件无法打开，使用后台修复或者使用phpmyadmin进行修复。

1020：记录已被其他用户修改

1021：硬盘剩余空间不足，请加大硬盘可用空间

1022：关键字重复，更改记录失败

1023：关闭时发生错误

1024：读文件错误

1025：更改名字时发生错误

1026：写文件错误

1032：记录不存在

1036：数据表是只读的，不能对它进行修改

1037：系统内存不足，请重启数据库或重启服务器

1038：用于排序的内存不足，请增大排序缓冲区

1040：已到达数据库的最大连接数，请加大数据库可用连接数

1041：系统内存不足

1042：无效的主机名

1043：无效连接

1044错误：数据库用户权限不足，请联系空间商解决

1045错误：数据库服务器/数据库用户名/数据库名/数据库密码错误，请联系空间商检查帐户。

1048：字段不能为空

1049：数据库不存在

1050：数据表已存在

1051：数据表不存在

1054错误：程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖。

1065：无效的SQL语句，SQL语句为空

1081：不能建立Socket连接

1114：数据表已满，不能容纳任何记录

1116：打开的数据表太多

1129：数据库l连接数过大，请重启数据库

1130：连接数据库失败，没有连接数据库的权限

1133：数据库用户不存在

1141：当前用户无权访问数据库

1142：当前用户无权访问数据表

1143：当前用户无权访问数据表中的字段

1146：数据表缺失,请恢复备份数据.

1147：未定义用户对数据表的访问权限

1149：SQL语句语法错误

1158：网络错误，出现读错误，请检查网络连接状况

1159：网络错误，读超时，请检查网络连接状况

1160：网络错误，出现写错误，请检查网络连接状况

1161：网络错误，写超时，请检查网络连接状况

1062：字段值重复，入库失败

1169：字段值重复，更新记录失败

1177：打开数据表失败

1180：提交事务失败

1181：回滚事务失败

1203：当前用户和数据库建立的连接已到达数据库的最大连接数，请增大可用的数据库连接数或重启数据库

1205：加锁超时

1211：当前用户没有创建用户的权限

1216：外键约束检查失败，更新子表记录失败

1217：外键约束检查失败，删除或修改主表记录失败

1226：当前用户使用的资源已超过所允许的资源，请重启数据库或重启服务器

1227：权限不足，您无权进行此操作

1235：MySQL版本过低，不具有本功能

2002：Can't connect to...通常意味着没有一个MySQL服务器运行在系统上或当试图连接mysqld服务器时，你正在使用一个错误的套接字文件或TCP/IP端口。

说明：以上只是常见错误号，并且解决办法也不一定肯定管用！具体请参考MYSQL手册（各大下载站均有下载）

更多详细错误代码

错误名称/错误代码SQL状态

ER_HASHCHK1000HY000

ER_NISAMCHK1001HY000

ER_NO1002HY000

ER_YES1003HY000

ER_CANT_Create_FILE1004HY000

ER_CANT_Create_TABLE1005HY000

ER_CANT_Create_DB1006HY000

ER_DB_Create_EXISTS1007HY000

ER_DB_Drop_EXISTS1008HY000

ER_DB_Drop_Delete1009HY000

ER_DB_Drop_RMDIR1010HY000

ER_CANT_Delete_FILE1011HY000

ER_CANT_FIND_SYSTEM_REC1012HY000

ER_CANT_GET_STAT1013HY000

ER_CANT_GET_WD1014HY000

ER_CANT_LOCK1015HY000

ER_CANT_OPEN_FILE1016HY000

ER_FILE_NOT_FOUND1017HY000

ER_CANT_READ_DIR1018HY000

ER_CANT_SET_WD1019HY000

ER_CHECKREAD1020HY000

ER_DISK_FULL1021HY000

ER_DUP_KEY102223000

ER_ERROR_ON_CLOSE1023HY000

ER_ERROR_ON_READ1024HY000

ER_ERROR_ON_RENAME1025HY000

ER_ERROR_ON_WRITE1026HY000

ER_FILE_USED1027HY000

ER_FILSORT_ABORT1028HY000

ER_FORM_NOT_FOUND1029HY000

ER_GET_ERRNO1030HY000

ER_ILLEGAL_HA1031HY000

ER_KEY_NOT_FOUND1032HY000

ER_NOT_FORM_FILE1033HY000

ER_NOT_KEYFILE1034HY000

ER_OLD_KEYFILE1035HY000

ER_OPEN_AS_READONLY1036HY000

ER_OUTOFMEMORY1037HY001

ER_OUT_OF_SORTMEMORY1038HY001

ER_UNEXPECTED_EOF1039HY000

ER_CON_COUNT_ERROR104008004

ER_OUT_OF_RESOURCES104108004

ER_BAD_HOST_ERROR104208S01

ER_HANDSHAKE_ERROR104308S01

ER_DBACCESS_DENIED_ERROR104442000

ER_ACCESS_DENIED_ERROR104542000

ER_NO_DB_ERROR104642000

ER_UNKNOWN_COM_ERROR104708S01

ER_BAD_NULL_ERROR104823000

ER_BAD_DB_ERROR104942000

ER_TABLE_EXISTS_ERROR105042S01

ER_BAD_TABLE_ERROR105142S02

ER_NON_UNIQ_ERROR105223000

ER_SERVER_SHUTDOWN105308S01

ER_BAD_FIELD_ERROR105442S22

ER_WRONG_FIELD_WITH_GROUP105542000

ER_WRONG_GROUP_FIELD105642000

ER_WRONG_SUM_Select105742000

ER_WRONG_VALUE_COUNT105821S01

ER_TOO_LONG_IDENT105942000

ER_DUP_FIELDNAME106042S21

ER_DUP_KEYNAME106142000

ER_DUP_ENTRY106223000

ER_WRONG_FIELD_SPEC106342000

ER_PARSE_ERROR106442000

ER_EMPTY_QUERY106542000

ER_NONUNIQ_TABLE106642000

ER_INVALID_DEFAULT106742000

ER_MULTIPLE_PRI_KEY106842000

ER_TOO_MANY_KEYS106942000

ER_TOO_MANY_KEY_PARTS107042000

ER_TOO_LONG_KEY107142000

ER_KEY_COLUMN_DOES_NOT_EXITS107242000

ER_BLOB_USED_AS_KEY107342000

ER_TOO_BIG_FIELDLENGTH107442000

ER_WRONG_AUTO_KEY107542000

ER_READY107600000

ER_NORMAL_SHUTDOWN107700000

ER_GOT_SIGNAL107800000

ER_SHUTDOWN_COMPLETE107900000

ER_FORCING_CLOSE108008S01

ER_IPSOCK_ERROR108108S01

ER_NO_SUCH_INDEX108242S12

ER_WRONG_FIELD_TERMINATORS108342000

ER_BLOBS_AND_NO_TERMINATED108442000

ER_TEXTFILE_NOT_READABLE1085HY000

ER_FILE_EXISTS_ERROR1086HY000

ER_LOAD_INFO1087HY000

ER_Alter_INFO1088HY000

ER_WRONG_SUB_KEY1089HY000

ER_CANT_REMOVE_ALL_FIELDS109042000

ER_CANT_Drop_FIELD_OR_KEY109142000

ER_Insert_INFO1092HY000

ER_Update_TABLE_USED1093HY000

ER_NO_SUCH_THREAD1094HY000

ER_KILL_DENIED_ERROR1095HY000

ER_NO_TABLES_USED1096HY000

ER_TOO_BIG_SET1097HY000

ER_NO_UNIQUE_LOGFILE1098HY000

ER_TABLE_NOT_LOCKED_FOR_WRITE1099HY000

ER_TABLE_NOT_LOCKED1100HY000

ER_BLOB_CANT_HAVE_DEFAULT110142000

ER_WRONG_DB_NAME110242000

ER_WRONG_TABLE_NAME110342000

ER_TOO_BIG_Select110442000

ER_UNKNOWN_ERROR1105HY000

ER_UNKNOWN_PROCEDURE110642000

ER_WRONG_PARAMCOUNT_TO_PROCEDURE110742000

ER_WRONG_PARAMETERS_TO_PROCEDURE1108HY000

ER_UNKNOWN_TABLE110942S02

ER_FIELD_SPECIFIED_TWICE111042000

ER_INVALID_GROUP_FUNC_USE111142000

ER_UNSUPPORTED_EXTENSION111242000

ER_TABLE_MUST_HAVE_COLUMNS111342000

ER_RECORD_FILE_FULL1114HY000

ER_UNKNOWN_CHARACTER_SET111542000

ER_TOO_MANY_TABLES1116HY000

ER_TOO_MANY_FIELDS1117HY000

ER_TOO_BIG_ROWSIZE111842000

ER_STACK_OVERRUN1119HY000

ER_WRONG_OUTER_JOIN112042000

ER_NULL_COLUMN_IN_INDEX112142000

ER_CANT_FIND_UDF1122HY000

ER_CANT_INITIALIZE_UDF1123HY000

ER_UDF_NO_PATHS1124HY000

ER_UDF_EXISTS1125HY000

ER_CANT_OPEN_LIBRARY1126HY000

ER_CANT_FIND_DL_ENTRY1127HY000

ER_FUNCTION_NOT_DEFINED1128HY000

ER_HOST_IS_BLOCKED1129HY000

ER_HOST_NOT_PRIVILEGED1130HY000

ER_PASSWORD_ANONYMOUS_USER113142000

ER_PASSWORD_NOT_ALLOWED113242000

ER_PASSWORD_NO_MATCH113342000

ER_Update_INFO1134HY000

ER_CANT_Create_THREAD1135HY000

ER_WRONG_VALUE_COUNT_ON_ROW113621S01

ER_CANT_REOPEN_TABLE1137HY000

ER_INVALID_USE_OF_NULL113842000

ER_REGEXP_ERROR113942000

ER_MIX_OF_GROUP_FUNC_AND_FIELDS114042000

ER_NONEXISTING_GRANT114142000

ER_TABLEACCESS_DENIED_ERROR114242000

ER_COLUMNACCESS_DENIED_ERROR114342000

ER_ILLEGAL_GRANT_FOR_TABLE114442000

ER_GRANT_WRONG_HOST_OR_USER114542000

ER_NO_SUCH_TABLE114642S02

ER_NONEXISTING_TABLE_GRANT114742000

ER_NOT_ALLOWED_COMMAND114842000

ER_SYNTAX_ERROR114942000

ER_DELAYED_CANT_CHANGE_LOCK1150HY000

ER_TOO_MANY_DELAYED_THREADS1151HY000

ER_ABORTING_CONNECTION115208S01

ER_NET_PACKET_TOO_LARGE115308S01

ER_NET_READ_ERROR_FROM_PIPE115408S01

ER_NET_FCNTL_ERROR115508S01

ER_NET_PACKETS_OUT_OF_ORDER115608S01

ER_NET_UNCOMPRESS_ERROR115708S01

ER_NET_READ_ERROR115808S01

ER_NET_READ_INTERRUPTED115908S01

ER_NET_ERROR_ON_WRITE116008S01

ER_NET_WRITE_INTERRUPTED116108S01

ER_TOO_LONG_STRING116242000

ER_TABLE_CANT_HANDLE_BLOB116342000

ER_TABLE_CANT_HANDLE_AUTO_INCREMENT116442000

ER_DELAYED_Insert_TABLE_LOCKED1165HY000

ER_WRONG_COLUMN_NAME116642000

ER_WRONG_KEY_COLUMN116742000

ER_WRONG_MRG_TABLE1168HY000

ER_DUP_UNIQUE116923000

ER_BLOB_KEY_WITHOUT_LENGTH117042000

ER_PRIMARY_CANT_HAVE_NULL117142000

ER_TOO_MANY_ROWS117242000

ER_REQUIRES_PRIMARY_KEY117342000

ER_NO_RAID_COMPILED1174HY000

ER_Update_WITHOUT_KEY_IN_SAFE_MODE1175HY000

ER_KEY_DOES_NOT_EXITS1176HY000

ER_CHECK_NO_SUCH_TABLE117742000

ER_CHECK_NOT_IMPLEMENTED117842000

ER_CANT_DO_THIS_DURING_AN_TRANSACTION117925000

ER_ERROR_DURING_COMMIT1180HY000

ER_ERROR_DURING_ROLLBACK1181HY000

ER_ERROR_DURING_FLUSH_LOGS1182HY000

ER_ERROR_DURING_CHECKPOINT1183HY000

ER_NEW_ABORTING_CONNECTION118408S01

ER_DUMP_NOT_IMPLEMENTED1185HY000

ER_FLUSH_MASTER_BINLOG_CLOSED1186HY000

ER_INDEX_REBUILD1187HY000

ER_MASTER1188HY000

ER_MASTER_NET_READ118908S01

ER_MASTER_NET_WRITE119008S01

ER_FT_MATCHING_KEY_NOT_FOUND1191HY000

ER_LOCK_OR_ACTIVE_TRANSACTION1192HY000

ER_UNKNOWN_SYSTEM_VARIABLE1193HY000

ER_CRASHED_ON_USAGE1194HY000

ER_CRASHED_ON_REPAIR1195HY000

ER_WARNING_NOT_COMPLETE_ROLLBACK1196HY000

ER_TRANS_CACHE_FULL1197HY000

ER_SLAVE_MUST_STOP1198HY000

ER_SLAVE_NOT_RUNNING1199HY000

ER_BAD_SLAVE1200HY000

ER_MASTER_INFO1201HY000

ER_SLAVE_THREAD1202HY000

ER_TOO_MANY_USER_CONNECTIONS120342000

ER_SET_CONSTANTS_ONLY1204HY000

ER_LOCK_WAIT_TIMEOUT1205HY000

ER_LOCK_TABLE_FULL1206HY000

ER_READ_ONLY_TRANSACTION120725000

ER_Drop_DB_WITH_READ_LOCK1208HY000

ER_Create_DB_WITH_READ_LOCK1209HY000

ER_WRONG_ARGUMENTS1210HY000

ER_NO_PERMISSION_TO_Create_USER121142000

ER_UNION_TABLES_IN_DIFFERENT_DIR1212HY000

ER_LOCK_DEADLOCK121340001

ER_TABLE_CANT_HANDLE_FULLTEXT1214HY000

ER_CANNOT_ADD_FOREIGN1215HY000

ER_NO_REFERENCED_ROW121623000

ER_ROW_IS_REFERENCED121723000

ER_CONNECT_TO_MASTER121808S01

ER_QUERY_ON_MASTER1219HY000

ER_ERROR_WHEN_EXECUTING_COMMAND1220HY000

ER_WRONG_USAGE1221HY000

ER_WRONG_NUMBER_OF_COLUMNS_IN_Select122221000

ER_CANT_Update_WITH_READLOCK1223HY000

ER_MIXING_NOT_ALLOWED1224HY000

ER_DUP_ARGUMENT1225HY000

ER_USER_LIMIT_REACHED122642000

ER_SPECIFIC_ACCESS_DENIED_ERROR1227HY000

ER_LOCAL_VARIABLE1228HY000

ER_GLOBAL_VARIABLE1229HY000

ER_NO_DEFAULT123042000

ER_WRONG_VALUE_FOR_VAR123142000

ER_WRONG_TYPE_FOR_VAR123242000

ER_VAR_CANT_BE_READ1233HY000

ER_CANT_USE_OPTION_HERE123442000

ER_NOT_SUPPORTED_YET123542000

ER_MASTER_FATAL_ERROR_READING_BINLOG1236HY000

ER_WRONG_FK_DEF123742000

ER_KEY_REF_DO_NOT_MATCH_TABLE_REF1238HY000

ER_CARDINALITY_COL123921000

ER_SUBSelect_NO_1_ROW124021000

ER_UNKNOWN_STMT_HANDLER1241HY000

ER_CORRUPT_HELP_DB1242HY000

ER_CYCLIC_REFERENCE1243HY000

ER_AUTO_CONVERT1244HY000

ER_ILLEGAL_REFERENCE124542S22

ER_DERIVED_MUST_HAVE_ALIAS124642000

ER_Select_REDUCED124701000

ER_TABLENAME_NOT_ALLOWED_HERE124842000

ER_NOT_SUPPORTED_AUTH_MODE124908004

ER_SPATIAL_CANT_HAVE_NULL125042000

ER_COLLATION_CHARSET_MISMATCH125142000

ER_SLAVE_WAS_RUNNING1252HY000

ER_SLAVE_WAS_NOT_RUNNING1253HY000

ER_TOO_BIG_FOR_UNCOMPRESS1254HY000

ER_ZLIB_Z_MEM_ERROR1255HY000

ER_ZLIB_Z_BUF_ERROR1256HY000

ER_ZLIB_Z_DATA_ERROR1257HY000

ER_CUT_VALUE_GROUP_CONCAT1258HY000

ER_WARN_TOO_FEW_RECORDS125901000

ER_WARN_TOO_MANY_RECORDS126001000

ER_WARN_NULL_TO_NOTNULL126101000

ER_WARN_DATA_OUT_OF_RANGE126201000

ER_WARN_DATA_TRUNCATED126301000

ER_WARN_USING_OTHER_HANDLER126401000

ER_CANT_AGGREGATE_COLLATIONS126542000

ER_Drop_USER126642000

ER_REVOKE_GRANTS126742000