常見錯誤!
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_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
