MySQL常见出错代码对照
2022-11-12 09:16:54
内容摘要
这篇文章主要为大家详细介绍了MySQL常见出错代码对照，具有一定的参考价值，可以用来参考一下。
对此感兴趣的朋友，看看idc笔记做的技术笔记！常见错误！1016错误：文件无法打开，使用后
文章正文
这篇文章主要为大家详细介绍了MySQL常见出错代码对照，具有一定的参考价值，可以用来参考一下。
对此感兴趣的朋友，看看idc笔记做的技术笔记！
常见错误！1016错误：文件无法打开，使用后台修复或者使用phpmyadmin进行修复。1044错误：数据库用户权限不足，请联系空间商解决1045错误：数据库服务器/数据库用户名/数据库名/数据库密码错误，请联系空间商检查帐户。1054错误：程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖。1146错误：数据表缺失,请恢复备份数据.1005：创建表失败1006：创建数据库失败1007：数据库已存在，创建数据库失败1008：数据库不存在，删除数据库失败1009：不能删除数据库文件导致删除数据库失败1010：不能删除数据目录导致删除数据库失败1011：删除数据库文件失败1012：不能读取系统表中的记录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：数据库出现异常，请重启数据库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'tconnectto...通常意味着没有一个MySQL服务器运行在系统上或当试图连接mysqld服务器时，你正在使用一个错误的套接字文件或TCP/IP端口。说明：以上只是常见错误号，并且解决办法也不一定肯定管用！具体请参考MYSQL手册（各大下载站均有下载）更多详细错误代码错误名称/错误代码SQL状态ER_HASHCHK1000HY000ER_NISAMCHK1001HY000ER_NO1002HY000ER_YES1003HY000ER_CANT_CREATE_FILE1004HY000ER_CANT_CREATE_TABLE1005HY000ER_CANT_CREATE_DB1006HY000ER_DB_CREATE_EXISTS1007HY000ER_DB_DROP_EXISTS1008HY000ER_DB_DROP_DELETE1009HY000ER_DB_DROP_RMDIR1010HY000ER_CANT_DELETE_FILE1011HY000ER_CANT_FIND_SYSTEM_REC1012HY000ER_CANT_GET_STAT1013HY000ER_CANT_GET_WD1014HY000ER_CANT_LOCK1015HY000ER_CANT_OPEN_FILE1016HY000ER_FILE_NOT_FOUND1017HY000ER_CANT_READ_DIR1018HY000ER_CANT_SET_WD1019HY000ER_CHECKREAD1020HY000ER_DISK_FULL1021HY000ER_DUP_KEY102223000ER_ERROR_ON_CLOSE1023HY000ER_ERROR_ON_READ1024HY000ER_ERROR_ON_RENAME1025HY000ER_ERROR_ON_WRITE1026HY000ER_FILE_USED1027HY000ER_FILSORT_ABORT1028HY000ER_FORM_NOT_FOUND1029HY000ER_GET_ERRNO1030HY000ER_ILLEGAL_HA1031HY000ER_KEY_NOT_FOUND1032HY000ER_NOT_FORM_FILE1033HY000ER_NOT_KEYFILE1034HY000ER_OLD_KEYFILE1035HY000ER_OPEN_AS_READONLY1036HY000ER_OUTOFMEMORY1037HY001ER_OUT_OF_SORTMEMORY1038HY001ER_UNEXPECTED_EOF1039HY000ER_CON_COUNT_ERROR104008004ER_OUT_OF_RESOURCES104108004ER_BAD_HOST_ERROR104208S01ER_HANDSHAKE_ERROR104308S01ER_DBACCESS_DENIED_ERROR104442000ER_ACCESS_DENIED_ERROR104542000ER_NO_DB_ERROR104642000ER_UNKNOWN_COM_ERROR104708S01ER_BAD_NULL_ERROR104823000ER_BAD_DB_ERROR104942000ER_TABLE_EXISTS_ERROR105042S01ER_BAD_TABLE_ERROR105142S02ER_NON_UNIQ_ERROR105223000ER_SERVER_SHUTDOWN105308S01ER_BAD_FIELD_ERROR105442S22ER_WRONG_FIELD_WITH_GROUP105542000ER_WRONG_GROUP_FIELD105642000ER_WRONG_SUM_SELECT105742000ER_WRONG_VALUE_COUNT105821S01ER_TOO_LONG_IDENT105942000ER_DUP_FIELDNAME106042S21ER_DUP_KEYNAME106142000ER_DUP_ENTRY106223000ER_WRONG_FIELD_SPEC106342000ER_PARSE_ERROR106442000ER_EMPTY_QUERY106542000ER_NONUNIQ_TABLE106642000ER_INVALID_DEFAULT106742000ER_MULTIPLE_PRI_KEY106842000ER_TOO_MANY_KEYS106942000ER_TOO_MANY_KEY_PARTS107042000ER_TOO_LONG_KEY107142000ER_KEY_COLUMN_DOES_NOT_EXITS107242000ER_BLOB_USED_AS_KEY107342000ER_TOO_BIG_FIELDLENGTH107442000ER_WRONG_AUTO_KEY107542000ER_READY107600000ER_NORMAL_SHUTDOWN107700000ER_GOT_SIGNAL107800000ER_SHUTDOWN_COMPLETE107900000ER_FORCING_CLOSE108008S01ER_IPSOCK_ERROR108108S01ER_NO_SUCH_INDEX108242S12ER_WRONG_FIELD_TERMINATORS108342000ER_BLOBS_AND_NO_TERMINATED108442000ER_TEXTFILE_NOT_READABLE1085HY000ER_FILE_EXISTS_ERROR1086HY000ER_LOAD_INFO1087HY000ER_ALTER_INFO1088HY000ER_WRONG_SUB_KEY1089HY000ER_CANT_REMOVE_ALL_FIELDS109042000ER_CANT_DROP_FIELD_OR_KEY109142000ER_INSERT_INFO1092HY000ER_UPDATE_TABLE_USED1093HY000ER_NO_SUCH_THREAD1094HY000ER_KILL_DENIED_ERROR1095HY000ER_NO_TABLES_USED1096HY000ER_TOO_BIG_SET1097HY000ER_NO_UNIQUE_LOGFILE1098HY000ER_TABLE_NOT_LOCKED_FOR_WRITE1099HY000ER_TABLE_NOT_LOCKED1100HY000ER_BLOB_CANT_HAVE_DEFAULT110142000ER_WRONG_DB_NAME110242000ER_WRONG_TABLE_NAME110342000ER_TOO_BIG_SELECT110442000ER_UNKNOWN_ERROR1105HY000ER_UNKNOWN_PROCEDURE110642000ER_WRONG_PARAMCOUNT_TO_PROCEDURE110742000ER_WRONG_PARAMETERS_TO_PROCEDURE1108HY000ER_UNKNOWN_TABLE110942S02ER_FIELD_SPECIFIED_TWICE111042000ER_INVALID_GROUP_FUNC_USE111142000ER_UNSUPPORTED_EXTENSION111242000ER_TABLE_MUST_HAVE_COLUMNS111342000ER_RECORD_FILE_FULL1114HY000ER_UNKNOWN_CHARACTER_SET111542000ER_TOO_MANY_TABLES1116HY000ER_TOO_MANY_FIELDS1117HY000ER_TOO_BIG_ROWSIZE111842000ER_STACK_OVERRUN1119HY000ER_WRONG_OUTER_JOIN112042000ER_NULL_COLUMN_IN_INDEX112142000ER_CANT_FIND_UDF1122HY000ER_CANT_INITIALIZE_UDF1123HY000ER_UDF_NO_PATHS1124HY000ER_UDF_EXISTS1125HY000ER_CANT_OPEN_LIBRARY1126HY000ER_CANT_FIND_DL_ENTRY1127HY000ER_FUNCTION_NOT_DEFINED1128HY000ER_HOST_IS_BLOCKED1129HY000ER_HOST_NOT_PRIVILEGED1130HY000ER_PASSWORD_ANONYMOUS_USER113142000ER_PASSWORD_NOT_ALLOWED113242000ER_PASSWORD_NO_MATCH113342000ER_UPDATE_INFO1134HY000ER_CANT_CREATE_THREAD1135HY000ER_WRONG_VALUE_COUNT_ON_ROW113621S01ER_CANT_REOPEN_TABLE1137HY000ER_INVALID_USE_OF_NULL113842000ER_REGEXP_ERROR113942000ER_MIX_OF_GROUP_FUNC_AND_FIELDS114042000ER_NONEXISTING_GRANT114142000ER_TABLEACCESS_DENIED_ERROR114242000ER_COLUMNACCESS_DENIED_ERROR114342000ER_ILLEGAL_GRANT_FOR_TABLE114442000ER_GRANT_WRONG_HOST_OR_USER114542000ER_NO_SUCH_TABLE114642S02ER_NONEXISTING_TABLE_GRANT114742000ER_NOT_ALLOWED_COMMAND114842000ER_SYNTAX_ERROR114942000ER_DELAYED_CANT_CHANGE_LOCK1150HY000ER_TOO_MANY_DELAYED_THREADS1151HY000ER_ABORTING_CONNECTION115208S01ER_NET_PACKET_TOO_LARGE115308S01ER_NET_READ_ERROR_FROM_PIPE115408S01ER_NET_FCNTL_ERROR115508S01ER_NET_PACKETS_OUT_OF_ORDER115608S01ER_NET_UNCOMPRESS_ERROR115708S01ER_NET_READ_ERROR115808S01ER_NET_READ_INTERRUPTED115908S01ER_NET_ERROR_ON_WRITE116008S01ER_NET_WRITE_INTERRUPTED116108S01ER_TOO_LONG_STRING116242000ER_TABLE_CANT_HANDLE_BLOB116342000ER_TABLE_CANT_HANDLE_AUTO_INCREMENT116442000ER_DELAYED_INSERT_TABLE_LOCKED1165HY000ER_WRONG_COLUMN_NAME116642000ER_WRONG_KEY_COLUMN116742000ER_WRONG_MRG_TABLE1168HY000ER_DUP_UNIQUE116923000ER_BLOB_KEY_WITHOUT_LENGTH117042000ER_PRIMARY_CANT_HAVE_NULL117142000ER_TOO_MANY_ROWS117242000ER_REQUIRES_PRIMARY_KEY117342000ER_NO_RAID_COMPILED1174HY000ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE1175HY000ER_KEY_DOES_NOT_EXITS1176HY000ER_CHECK_NO_SUCH_TABLE117742000ER_CHECK_NOT_IMPLEMENTED117842000ER_CANT_DO_THIS_DURING_AN_TRANSACTION117925000ER_ERROR_DURING_COMMIT1180HY000ER_ERROR_DURING_ROLLBACK1181HY000ER_ERROR_DURING_FLUSH_LOGS1182HY000ER_ERROR_DURING_CHECKPOINT1183HY000ER_NEW_ABORTING_CONNECTION118408S01ER_DUMP_NOT_IMPLEMENTED1185HY000ER_FLUSH_MASTER_BINLOG_CLOSED1186HY000ER_INDEX_REBUILD1187HY000ER_MASTER1188HY000ER_MASTER_NET_READ118908S01ER_MASTER_NET_WRITE119008S01ER_FT_MATCHING_KEY_NOT_FOUND1191HY000ER_LOCK_OR_ACTIVE_TRANSACTION1192HY000ER_UNKNOWN_SYSTEM_VARIABLE1193HY000ER_CRASHED_ON_USAGE1194HY000ER_CRASHED_ON_REPAIR1195HY000ER_WARNING_NOT_COMPLETE_ROLLBACK1196HY000ER_TRANS_CACHE_FULL1197HY000ER_SLAVE_MUST_STOP1198HY000ER_SLAVE_NOT_RUNNING1199HY000ER_BAD_SLAVE1200HY000ER_MASTER_INFO1201HY000ER_SLAVE_THREAD1202HY000ER_TOO_MANY_USER_CONNECTIONS120342000ER_SET_CONSTANTS_ONLY1204HY000ER_LOCK_WAIT_TIMEOUT1205HY000ER_LOCK_TABLE_FULL1206HY000ER_READ_ONLY_TRANSACTION120725000ER_DROP_DB_WITH_READ_LOCK1208HY000ER_CREATE_DB_WITH_READ_LOCK1209HY000ER_WRONG_ARGUMENTS1210HY000ER_NO_PERMISSION_TO_CREATE_USER121142000ER_UNION_TABLES_IN_DIFFERENT_DIR1212HY000ER_LOCK_DEADLOCK121340001ER_TABLE_CANT_HANDLE_FULLTEXT1214HY000ER_CANNOT_ADD_FOREIGN1215HY000ER_NO_REFERENCED_ROW121623000ER_ROW_IS_REFERENCED121723000ER_CONNECT_TO_MASTER121808S01ER_QUERY_ON_MASTER1219HY000ER_ERROR_WHEN_EXECUTING_COMMAND1220HY000ER_WRONG_USAGE1221HY000ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT122221000ER_CANT_UPDATE_WITH_READLOCK1223HY000ER_MIXING_NOT_ALLOWED1224HY000ER_DUP_ARGUMENT1225HY000ER_USER_LIMIT_REACHED122642000ER_SPECIFIC_ACCESS_DENIED_ERROR1227HY000ER_LOCAL_VARIABLE1228HY000ER_GLOBAL_VARIABLE1229HY000ER_NO_DEFAULT123042000ER_WRONG_VALUE_FOR_VAR123142000ER_WRONG_TYPE_FOR_VAR123242000ER_VAR_CANT_BE_READ1233HY000ER_CANT_USE_OPTION_HERE123442000ER_NOT_SUPPORTED_YET123542000ER_MASTER_FATAL_ERROR_READING_BINLOG1236HY000ER_WRONG_FK_DEF123742000ER_KEY_REF_DO_NOT_MATCH_TABLE_REF1238HY000ER_CARDINALITY_COL123921000ER_SUBSELECT_NO_1_ROW124021000ER_UNKNOWN_STMT_HANDLER1241HY000ER_CORRUPT_HELP_DB1242HY000ER_CYCLIC_REFERENCE1243HY000ER_AUTO_CONVERT1244HY000ER_ILLEGAL_REFERENCE124542S22ER_DERIVED_MUST_HAVE_ALIAS124642000ER_SELECT_REDUCED124701000ER_TABLENAME_NOT_ALLOWED_HERE124842000ER_NOT_SUPPORTED_AUTH_MODE124908004ER_SPATIAL_CANT_HAVE_NULL125042000ER_COLLATION_CHARSET_MISMATCH125142000ER_SLAVE_WAS_RUNNING1252HY000ER_SLAVE_WAS_NOT_RUNNING1253HY000ER_TOO_BIG_FOR_UNCOMPRESS1254HY000ER_ZLIB_Z_MEM_ERROR1255HY000ER_ZLIB_Z_BUF_ERROR1256HY000ER_ZLIB_Z_DATA_ERROR1257HY000ER_CUT_VALUE_GROUP_CONCAT1258HY000ER_WARN_TOO_FEW_RECORDS125901000ER_WARN_TOO_MANY_RECORDS126001000ER_WARN_NULL_TO_NOTNULL126101000ER_WARN_DATA_OUT_OF_RANGE126201000ER_WARN_DATA_TRUNCATED126301000ER_WARN_USING_OTHER_HANDLER126401000ER_CANT_AGGREGATE_COLLATIONS126542000ER_DROP_USER126642000ER_REVOKE_GRANTS126742000注：关于MySQL常见出错代码对照的内容就先介绍到这里，更多相关文章的可以留意
代码注释
作者：喵哥笔记
