| 代碼 | 錯誤訊息 | 可能原因與對策 |
|---|
| 1005 | Can't create table | 外鍵定義錯誤、引擎不支援、磁碟空間不足 |
| 1006 | Can't create database | 權限不足、磁碟空間、路徑錯誤 |
| 1007 | Database exists | 建庫前先 DROP IF EXISTS 或改名 |
| 1008 | Database doesn't exist | 拼寫錯誤、未建立、大小寫敏感(Linux) |
| 1009 | Can't drop database (file) | 檔案被鎖定、權限問題 |
| 1010 | Can't drop database (dir) | 目錄非空、權限問題 |
| 1011 | Can't delete database file | 檔案系統錯誤、權限 |
| 1012 | Can't read record in system table | 權限表損壞、磁碟錯誤 |
| 1020 | Record has changed | 並發修改衝突 |
| 1021 | Disk full | 擴充磁碟或清理空間 |
| 1022 | Duplicate key | 唯一鍵/主鍵衝突，檢查資料或用 INSERT IGNORE |
| 1023 | Error on close | 檔案關閉異常 |
| 1024 | Error reading file | 磁碟壞軌、檔案損壞 |
| 1025 | Error on rename | RENAME TABLE 失敗、外鍵阻擋 |
| 1026 | Error writing file | 磁碟滿、權限、檔案系統錯誤 |
| 1032 | Record doesn't exist | UPDATE/DELETE 找不到目標行 |
| 1036 | Table is read only | FLUSH TABLES WITH READ LOCK、檔案系統只讀、myisamchk 未釋放 |
| 1037 | Out of memory | 重啟服務/伺服器、調整 innodb_buffer_pool |
| 1038 | Out of sort memory | 增大 sort_buffer_size |
| 1040 | Too many connections | 增大 max_connections、檢查連線洩漏 |
| 1041 | Out of memory | 系統記憶體不足 |
| 1042 | Bad host name | DNS 解析失敗、/etc/hosts、skip-name-resolve |
| 1043 | Invalid connection | 網路中斷、防火牆、逾時 |
| 1044 | Access denied for user | 權限不足、GRANT 缺失 |
| 1045 | Access denied (user/pass) | 帳號密碼錯誤、host 不符 |
| 1048 | Column cannot be null | NOT NULL 欄位未給值 |
| 1049 | Unknown database | 資料庫不存在 |
| 1050 | Table already exists | CREATE IF NOT EXISTS 或先 DROP |
| 1051 | Unknown table | 表不存在、拼寫錯誤 |
| 1054 | Unknown column | 欄位不存在、拼寫錯誤 |
| 1062 | Duplicate entry | 唯一鍵衝突 |
| 1065 | Empty query | SQL 字串為空 |
| 1081 | Can't create socket | 埠衝突、權限、SELinux |
| 1114 | Table is full | 磁碟滿、InnoDB 表空間滿、MyISAM 4GB 限制(舊版) |
| 1116 | Too many open tables | 增大 table_open_cache |
| 1129 | Host is blocked | 連線錯誤過多，FLUSH HOSTS 或增大 max_connect_errors |
| 1130 | Host not allowed | GRANT host 不符、需授權遠端 IP |
| 1133 | User doesn't exist | 帳號不存在 |
| 1141 | Command denied to user | 無資料庫權限 |
| 1142 | Command denied to table | 無資料表權限 |
| 1143 | Command denied to column | 無欄位權限 |
| 1146 | Table doesn't exist | 表不存在 |
| 1147 | Undefined user access | 權限定義不完整 |
| 1149 | Syntax error | SQL 語法錯誤 |
| 1158 | Network read error | 檢查網路連線 |
| 1159 | Network read timeout | 增大 net_read_timeout |
| 1160 | Network write error | 檢查網路 |
| 1161 | Network write timeout | 增大 net_write_timeout |
| 1169 | Duplicate entry (update) | UPDATE 造成唯一鍵衝突 |
| 1177 | Can't open table | 權限、檔案損壞、鎖衝突 |
| 1180 | Commit failed | 交易提交失敗 |
| 1181 | Rollback failed | 交易回滾失敗 |
| 1203 | User max connections | 增大 max_user_connections |
| 1205 | Lock wait timeout | 增大 innodb_lock_wait_timeout、優化長交易 |
| 1211 | No create user privilege | 無 CREATE USER 權限 |
| 1216 | FK constraint fails (child) | 子表外鍵值在父表不存在 |
| 1217 | FK constraint fails (parent) | 父表記錄被子表引用，無法刪改 |
| 1226 | User resource limit | 超過 MAX_QUERIES_PER_HOUR 等限制 |
| 1227 | Access denied (super privilege) | 需 SUPER 權限 |
| 1235 | MySQL version too old | 功能需較新版本 |
