您现在的位置：程式碼之家 >> 數據庫知識 > >> MySQL 資料庫 >> MySQL 資料庫相關知識

MySQL 常見錯誤代碼速查表：1000-1267 號中文對照與官方符號/SQLSTATE 完整對照

編輯：MySQL 資料庫相關知識

高頻錯誤快速查詢（Top 30）

代碼	常見訊息	典型原因與處置
1005	Can't create table	外鍵定義錯、磁碟滿、權限
1006	Can't create database	目錄權限、磁碟、檔案系統
1007	Database exists	改用 `CREATE IF NOT EXISTS`
1008	Database doesn't exist	拼寫、大小寫、未建立
1016	Can't open file	表損壞 → `REPAIR TABLE`、檔案遺失
1021	Disk full	清理空間、擴容、檢查 `tmpdir`
1022	Duplicate key	唯一鍵衝突 → `INSERT IGNORE`/`ON DUPLICATE KEY`
1032	Record not found	更新條件不匹配、並發刪除
1036	Table is read only	磁碟滿、MyISAM 唯讀標記、權限
1037	Out of memory	調大 `innodb_buffer_pool`、重啟
1038	Sort memory full	調大 `sort_buffer_size`
1040	Too many connections	調大 `max_connections`、修連線洩漏
1042	Bad host	DNS、`skip-name-resolve`、hosts
1044	Access denied for user	權限不足 → `GRANT`
1045	Access denied (password)	帳密錯、插件不符、`FLUSH PRIVILEGES`
1048	Column can't be null	NOT NULL 欄位傳 NULL
1049	Unknown database	庫不存在、拼寫
1050	Table exists	`DROP IF EXISTS` 再建
1051	Unknown table	表不存在、拼寫
1054	Unknown column	欄位不存在、遷移未執行
1062	Duplicate entry	主鍵/唯一鍵重複
1064	SQL syntax error	語法錯、保留字未加反引號、註解需空格
1065	Empty query	傳入空 SQL
1081	Can't create socket	socket 檔權限、SELinux
1114	Table is full	MyISAM 檔案上限、InnoDB 表空間滿
1116	Too many open tables	調大 `table_open_cache`
1129	Host blocked	連線錯誤過多 → `FLUSH HOSTS`
1130	Host not allowed	user 表 host 未授權
1146	Table doesn't exist	同 1051
1158-61	Network errors	網路、防火牆、`wait_timeout`、`max_allowed_packet`
1205	Lock wait timeout	死鎖、長交易 → `innodb_lock_wait_timeout`
1216	FK child fails	子表外鍵值父表無對應
1217	FK parent fails	父表被引用無法刪改
1226	User resource exceeded	配額用盡 → 重啟或調大
1227	Access denied (specific)	缺特定權限（SUPER/FILE 等）
1235	Version too old	功能需新版 → 升級
2002	Can't connect to server	服務未啟、socket/埠錯、防火牆

官方錯誤符號完整對照（節錄 1000-1267）

符號	代碼	SQLSTATE
ER_HASHCHK	1000	HY000
ER_NISAMCHK	1001	HY000
ER_NO	1002	HY000
ER_YES	1003	HY000
ER_CANT_CREATE_FILE	1004	HY000
ER_CANT_CREATE_TABLE	1005	HY000
ER_CANT_CREATE_DB	1006	HY000
ER_DB_CREATE_EXISTS	1007	HY000
ER_DB_DROP_EXISTS	1008	HY000
ER_DB_DROP_DELETE	1009	HY000
ER_DB_DROP_RMDIR	1010	HY000
ER_CANT_DELETE_FILE	1011	HY000
ER_CANT_FIND_SYSTEM_REC	1012	HY000
ER_CANT_GET_STAT	1013	HY000
ER_CANT_GET_WD	1014	HY000
ER_CANT_LOCK	1015	HY000
ER_CANT_OPEN_FILE	1016	HY000
ER_FILE_NOT_FOUND	1017	HY000
ER_CANT_READ_DIR	1018	HY000
ER_CANT_SET_WD	1019	HY000
ER_CHECKREAD	1020	HY000
ER_DISK_FULL	1021	HY000
ER_DUP_KEY	1022	23000
ER_ERROR_ON_CLOSE	1023	HY000
ER_ERROR_ON_READ	1024	HY000
ER_ERROR_ON_RENAME	1025	HY000
ER_ERROR_ON_WRITE	1026	HY000
ER_FILE_USED	1027	HY000
ER_FILSORT_ABORT	1028	HY000
ER_FORM_NOT_FOUND	1029	HY000
ER_GET_ERRNO	1030	HY000
ER_ILLEGAL_HA	1031	HY000
ER_KEY_NOT_FOUND	1032	HY000
ER_NOT_FORM_FILE	1033	HY000
ER_NOT_KEYFILE	1034	HY000
ER_OLD_KEYFILE	1035	HY000
ER_OPEN_AS_READONLY	1036	HY000
ER_OUTOFMEMORY	1037	HY001
ER_OUT_OF_SORTMEMORY	1038	HY001
ER_UNEXPECTED_EOF	1039	HY000
ER_CON_COUNT_ERROR	1040	08004
ER_OUT_OF_RESOURCES	1041	08004
ER_BAD_HOST_ERROR	1042	08S01
ER_HANDSHAKE_ERROR	1043	08S01
ER_DBACCESS_DENIED_ERROR	1044	42000
ER_ACCESS_DENIED_ERROR	1045	42000
ER_NO_DB_ERROR	1046	42000
ER_UNKNOWN_COM_ERROR	1047	08S01
ER_BAD_NULL_ERROR	1048	23000
ER_BAD_DB_ERROR	1049	42000
ER_TABLE_EXISTS_ERROR	1050	42S01
ER_BAD_TABLE_ERROR	1051	42S02
ER_NON_UNIQ_ERROR	1052	23000
ER_SERVER_SHUTDOWN	1053	08S01
ER_BAD_FIELD_ERROR	1054	42S22
ER_DUP_ENTRY	1062	23000
ER_PARSE_ERROR	1064	42000
ER_EMPTY_QUERY	1065	42000
ER_INVALID_DEFAULT	1067	42000
ER_MULTIPLE_PRI_KEY	1068	42000
ER_TOO_MANY_KEYS	1069	42000
ER_TOO_MANY_KEY_PARTS	1070	42000
ER_TOO_LONG_KEY	1071	42000
ER_KEY_COLUMN_DOES_NOT_EXITS	1072	42000
ER_BLOB_USED_AS_KEY	1073	42000
ER_TOO_BIG_FIELDLENGTH	1074	42000
ER_WRONG_AUTO_KEY	1075	42000
ER_IPSOCK_ERROR	1081	08S01
ER_RECORD_FILE_FULL	1114	HY000
ER_TOO_MANY_TABLES	1116	HY000
ER_HOST_IS_BLOCKED	1129	HY000
ER_HOST_NOT_PRIVILEGED	1130	HY000
ER_PASSWORD_NO_MATCH	1133	42000
ER_TABLEACCESS_DENIED_ERROR	1142	42000
ER_COLUMNACCESS_DENIED_ERROR	1143	42000
ER_NO_SUCH_TABLE	1146	42S02
ER_SYNTAX_ERROR	1149	42000
ER_NET_READ_ERROR	1158	08S01
ER_NET_READ_INTERRUPTED	1159	08S01
ER_NET_ERROR_ON_WRITE	1160	08S01
ER_NET_WRITE_INTERRUPTED	1161	08S01
ER_DUP_UNIQUE	1169	23000
ER_CHECK_NO_SUCH_TABLE	1177	42000
ER_ERROR_DURING_COMMIT	1180	HY000
ER_ERROR_DURING_ROLLBACK	1181	HY000
ER_UNKNOWN_SYSTEM_VARIABLE	1193	HY000
ER_TOO_MANY_USER_CONNECTIONS	1203	42000
ER_LOCK_WAIT_TIMEOUT	1205	HY000
ER_NO_PERMISSION_TO_CREATE_USER	1211	42000
ER_NO_REFERENCED_ROW	1216	23000
ER_ROW_IS_REFERENCED	1217	23000
ER_USER_LIMIT_REACHED	1226	42000
ER_SPECIFIC_ACCESS_DENIED_ERROR	1227	HY000
ER_NOT_SUPPORTED_YET	1235	42000
ER_MASTER_FATAL_ERROR_READING_BINLOG	1236	HY000
ER_WRONG_FK_DEF	1237	42000
ER_KEY_REF_DO_NOT_MATCH_TABLE_REF	1238	HY000
ER_CARDINALITY_COL	1239	21000
ER_SUBSELECT_NO_1_ROW	1240	21000
ER_CORRUPT_HELP_DB	1242	HY000
ER_CYCLIC_REFERENCE	1243	HY000
ER_AUTO_CONVERT	1244	HY000
ER_ILLEGAL_REFERENCE	1245	42S22
ER_DERIVED_MUST_HAVE_ALIAS	1246	42000
ER_TABLENAME_NOT_ALLOWED_HERE	1248	42000
ER_NOT_SUPPORTED_AUTH_MODE	1249	08004
ER_SPATIAL_CANT_HAVE_NULL	1250	42000
ER_COLLATION_CHARSET_MISMATCH	1251	42000
ER_TOO_BIG_FOR_UNCOMPRESS	1254	HY000
ER_ZLIB_Z_MEM_ERROR	1255	HY000
ER_ZLIB_Z_BUF_ERROR	1256	HY000
ER_ZLIB_Z_DATA_ERROR	1257	HY000
ER_CUT_VALUE_GROUP_CONCAT	1258	HY000
ER_DROP_USER	1266	42000
ER_REVOKE_GRANTS	1267	42000