Mysql錯誤代碼分為兩部分，老版本一部分，4.1版本為新的部分 

第一部分: 
mysql的出錯代碼表，根據mysql的頭文件mysql/include/mysqld_error.h整理而成 

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：數據庫出現異常，請重啟數據庫 
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版本過低，不具有本功能 



第二部分 新4.1.11，摘自DOCSmysqld_error.txt 

character-set=utf-8 isher補充 


#define ER_HASHCHK 1000 
"hashchk", 

#define ER_NISAMCHK 1001 
"isamchk", 

#define ER_NO 1002 
"NO", 

#define ER_YES 1003 
"YES", 

#define ER_CANT_CREATE_FILE 1004 
"Can't create file '%-.64s' (errno: %d)", 

#define ER_CANT_CREATE_TABLE 1005 
"Can't create table '%-.64s' (errno: %d)", 

#define ER_CANT_CREATE_DB 1006 
"Can't create database '%-.64s' (errno: %d)", 

#define ER_DB_CREATE_EXISTS 1007 
"Can't create database '%-.64s'; database exists", 

#define ER_DB_DROP_EXISTS 1008 
"Can't drop database '%-.64s'; database doesn't exist", 

#define ER_DB_DROP_DELETE 1009 
"Error dropping database (can't delete '%-.64s', errno: %d)", 

#define ER_DB_DROP_RMDIR 1010 
"Error dropping database (can't rmdir '%-.64s', errno: %d)", 

#define ER_CANT_DELETE_FILE 1011 
"Error on delete of '%-.64s' (errno: %d)", 

#define ER_CANT_FIND_SYSTEM_REC 1012 
"Can't read record in system table", 

#define ER_CANT_GET_STAT 1013 
"Can't get status of '%-.64s' (errno: %d)", 

#define ER_CANT_GET_WD 1014 
"Can't get working directory (errno: %d)", 

#define ER_CANT_LOCK 1015 
"Can't lock file (errno: %d)", 

#define ER_CANT_OPEN_FILE 1016 
"Can't open file: '%-.64s' (errno: %d)", 

#define ER_FILE_NOT_FOUND 1017 
"Can't find file: '%-.64s' (errno: %d)", 

#define ER_CANT_READ_DIR 1018 
"Can't read dir of '%-.64s' (errno: %d)", 

#define ER_CANT_SET_WD 1019 
"Can't change dir to '%-.64s' (errno: %d)", 

#define ER_CHECKREAD 1020 
"Record has changed since last read in table '%-.64s'", 

#define ER_DISK_FULL 1021 
"Disk full (%s). Waiting for someone to free some space...", 

#define ER_DUP_KEY 1022 
"Can't write, duplicate key in table '%-.64s'", 

#define ER_ERROR_ON_CLOSE 1023 
"Error on close of '%-.64s' (errno: %d)", 

#define ER_ERROR_ON_READ 1024 
"Error reading file '%-.64s' (errno: %d)", 

#define ER_ERROR_ON_RENAME 1025 
"Error on rename of '%-.64s' to '%-.64s' (errno: %d)", 

#define ER_ERROR_ON_WRITE 1026 
"Error writing file '%-.64s' (errno: %d)", 

#define ER_FILE_USED 1027 
"'%-.64s' is locked against change", 

#define ER_FILSORT_ABORT 1028 
"So瘀牡?剕 ????o鸞? rt aborted", 

#define ER_FORM_NOT_FOUND 1029 
"View '%-.64s' doesn't exist for '%-.64s'", 

#define ER_GET_ERRNO 1030 
"Got error %d from storage engine", 

#define ER_ILLEGAL_HA 1031 
"Table storage engine for '%-.64s' doesn't have this option", 

#define ER_KEY_NOT_FOUND 1032 
"Can't find record in '%-.64s'", 

#define ER_NOT_FORM_FILE 1033 
"Incorrect information in file: '%-.64s'", 

#define ER_NOT_KEYFILE 1034 
"Incorrect key file for table: '%-.64s'; try to repair it", 

#define ER_OLD_KEYFILE 1035 
"Old key file for table '%-.64s'; repair it!", 

#define ER_OPEN_AS_READONLY 1036 
"Table '%-.64s' is read only", 

#define ER_OUTOFMEMORY 1037 
"Out of memory. Restart daemon and try again (needed %d bytes)", 

#define ER_OUT_OF_SORTMEMORY 1038 
"Out of sort memory. Increase daemon sort buffer size", 

#define ER_UNEXPECTED_EOF 1039 
"Unexpected eof found when reading file '%-.64s' (errno: %d)", 

#define ER_CON_COUNT_ERROR 1040 
"Too many connections", 

#define ER_OUT_OF_RESOURCES 1041 
"Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space", 

#define ER_BAD_HOST_ERROR 1042 
"Can't get hostname for your address", 

#define ER_HANDSHAKE_ERROR 1043 
"Bad handshake", 

#define ER_DBACCESS_DENIED_ERROR 1044 
"Access denied for user: '%-.32s'@'%-.64s' to database '%-.64s'", 

#define ER_ACCESS_DENIED_ERROR 1045 
"Access denied for user: '%-.32s'@'%-.64s' (Using password: %s)", 

#define ER_NO_DB_ERROR 1046 
"No Database Selected", 

#define ER_UNKNOWN_COM_ERROR 1047 
"Unknown command", 

#define ER_BAD_NULL_ERROR 1048 
"Column '%-.64s' cannot be null", 

#define ER_BAD_DB_ERROR 1049 
"Unknown database '%-.64s'", 

#define ER_TABLE_EXISTS_ERROR 1050 
"Table '%-.64s' already exists", 

#define ER_BAD_TABLE_ERROR 1051 
"Unknown table '%-.64s'", 

#define ER_NON_UNIQ_ERROR 1052 
"Column: '%-.64s' in %-.64s is ambiguous", 

#define ER_SERVER_SHUTDOWN 1053 
"Server shutdown in progress", 

#define ER_BAD_FIELD_ERROR 1瘀牡?剕 ????o鸞? 054 
"Unknown column '%-.64s' in '%-.64s'", 

#define ER_WRONG_FIELD_WITH_GROUP 1055 
"'%-.64s' isn't in GROUP BY", 

#define ER_WRONG_GROUP_FIELD 1056 
"Can't group on '%-.64s'", 

#define ER_WRONG_SUM_SELECT 1057 
"Statement has sum functions and columns in same statement", 

#define ER_WRONG_VALUE_COUNT 1058 
"Column count doesn't match value count", 

#define ER_TOO_LONG_IDENT 1059 
"Identifier name '%-.100s' is too long", 

#define ER_DUP_FIELDNAME 1060 
"Duplicate column name '%-.64s'", 

#define ER_DUP_KEYNAME 1061 
"Duplicate key name '%-.64s'", 

#define ER_DUP_ENTRY 1062 
"Duplicate entry '%-.64s' for key %d", 

#define ER_WRONG_FIELD_SPEC 1063 
"Incorrect column specifier for column '%-.64s'", 

#define ER_PARSE_ERROR 1064 
"%s near '%-.80s' at line %d", 

#define ER_EMPTY_QUERY 1065 
"Query was empty", 

#define ER_NONUNIQ_TABLE 1066 
"Not unique table/alias: '%-.64s'", 

#define ER_INVALID_DEFAULT 1067 
"Invalid default value for '%-.64s'", 

#define ER_MULTIPLE_PRI_KEY 1068 
"Multiple primary key defined", 

#define ER_TOO_MANY_KEYS 1069 
"Too many keys specified; max %d keys allowed", 

#define ER_TOO_MANY_KEY_PARTS 1070 
"Too many key parts specified. Max %d parts allowed", 

#define ER_TOO_LONG_KEY 1071 
"Specified key was too long; max key length is %d bytes", 

#define ER_KEY_COLUMN_DOES_NOT_EXITS 1072 
"Key column '%-.64s' doesn't exist in table", 

#define ER_BLOB_USED_AS_KEY 1073 
"BLOB column '%-.64s' can't be used in key specification with the used table type", 

#define ER_TOO_BIG_FIELDLENGTH 1074 
"Too big column length for column '%-.64s' (max = %d). Use BLOB instead", 

#define ER_WRONG_AUTO_KEY 1075 
"Incorrect table definition; There can only be one auto column and it must be defined as a key", 

#define ER_READY 1076 
"%s: ready for connections. 
Version: '%s' socket: '%s' port: %d 
", 

#define ER_NORMAL_SHUTDOWN 1077 
"%s: Normal shutdown 
", 

#define ER_GOT_SIGNAL 1078 
"%s: Got signal %d. Aborting! 
", 

#define ER_SHUTDOWN_COMPLETE 1079 
"%s: Shutdown Complete 
", 

#define ER_FORCING_CLOSE 1080 
"%s: 瘀牡?剕 ????o鸞? Forcing close of thread %ld user: '%-.32s' 
", 

#define ER_IPSOCK_ERROR 1081 
"Can't create IP socket",