| Error | SQLSTATE | Symbol | Message |
|---|
| 1004 | HY000 | ER_CANT_CREATE_FILE | Can't create file '%s' (errno: %d) |
| 1005 | HY000 | ER_CANT_CREATE_TABLE | Can't create table '%s' (errno: %d) |
| 1007 | HY000 | ER_DB_CREATE_EXISTS | Can't create database '%s'; database exists |
| 1008 | HY000 | ER_DB_DROP_EXISTS | Can't drop database '%s'; database doesn't exist |
| 1016 | HY000 | ER_CANT_OPEN_FILE | Can't open file: '%s' (errno: %d) |
| 1021 | HY000 | ER_DISK_FULL | Disk full (%s); waiting for someone to free space... |
| 1022 | 23000 | ER_DUP_KEY | Can't write; duplicate key in table '%s' |
| 1032 | HY000 | ER_KEY_NOT_FOUND | Can't find record in '%s' |
| 1037 | HY001 | ER_OUTOFMEMORY | Out of memory; restart server and try again (need %d bytes) |
| 1040 | 08004 | ER_CON_COUNT_ERROR | Too many connections |
| 1044 | 42000 | ER_DBACCESS_DENIED_ERROR | Access denied for user '%s'@'%s' to database '%s' |
| 1045 | 28000 | ER_ACCESS_DENIED_ERROR | Access denied for user '%s'@'%s' (using password: %s) |
| 1049 | 42000 | ER_BAD_DB_ERROR | Unknown database '%s' |
| 1050 | 42S01 | ER_TABLE_EXISTS_ERROR | Table '%s' already exists |
| 1051 | 42S02 | ER_BAD_TABLE_ERROR | Unknown table '%s' |
| 1054 | 42S22 | ER_BAD_FIELD_ERROR | Unknown column '%s' in '%s' |
| 1062 | 23000 | ER_DUP_ENTRY | Duplicate entry '%s' for key %d |
| 1064 | 42000 | ER_PARSE_ERROR | You have an error in your SQL syntax near '%s' at line %d |
| 1067 | 42000 | ER_INVALID_DEFAULT | Invalid default value for '%s' |
| 1114 | HY000 | ER_RECORD_FILE_FULL | The table '%s' is full |
| 1130 | HY000 | ER_HOST_NOT_PRIVILEGED | Host '%s' is not allowed to connect to this MySQL server |
| 1146 | 42S02 | ER_NO_SUCH_TABLE | Table '%s.%s' doesn't exist |
| 1153 | 08S01 | ER_NET_PACKET_TOO_LARGE | Got a packet bigger than 'max_allowed_packet' bytes |
| 1175 | HY000 | ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE | You are using safe update mode and tried to update a table without a WHERE that uses a KEY column |
| 1205 | HY000 | ER_LOCK_WAIT_TIMEOUT | Lock wait timeout exceeded; try restarting transaction |
| 1213 | 40001 | ER_LOCK_DEADLOCK | Deadlock found when trying to get lock; try restarting transaction |
| 1215 | HY000 | ER_CANNOT_ADD_FOREIGN | Cannot add foreign key constraint |
| 1226 | 42000 | ER_USER_LIMIT_REACHED | User '%s' has exceeded the '%s' resource (current value: %ld) |
| 1290 | HY000 | ER_OPTION_PREVENTS_STATEMENT | The MySQL server is running with the %s option so it cannot execute this statement |
| 1364 | HY000 | ER_NO_DEFAULT_FOR_FIELD | Field '%s' doesn't have a default value |
| 1366 | HY000 | ER_TRUNCATED_WRONG_VALUE_FOR_FIELD | Incorrect %s value: '%s' for column '%s' at row %ld |
| 1449 | HY000 | ER_VIEW_FRM_NO_USER | The view '%s.%s' has no definer information (old table format) |
| 1451 | 23000 | ER_ROW_IS_REFERENCED_2 | Cannot delete or update a parent row: a foreign key constraint fails (%s) |
| 1452 | 23000 | ER_NO_REFERENCED_ROW_2 | Cannot add or update a child row: a foreign key constraint fails (%s) |
| Error | Symbol | Message |
|---|
| 2000 | CR_UNKNOWN_ERROR | Unknown MySQL error |
| 2002 | CR_CONNECTION_ERROR | Can't connect to local MySQL server through socket '%s' (%d) |
| 2003 | CR_CONN_HOST_ERROR | Can't connect to MySQL server on '%s' (%d) |
| 2006 | CR_SERVER_GONE_ERROR | MySQL server has gone away |
| 2008 | CR_OUT_OF_MEMORY | MySQL client ran out of memory |
| 2013 | CR_SERVER_LOST | Lost connection to MySQL server during query |
| 2014 | CR_COMMANDS_OUT_OF_SYNC | Commands out of sync; you can't run this command now |
| 2020 | CR_NET_PACKET_TOO_LARGE | Got packet bigger than 'max_allowed_packet' bytes |
| 2026 | CR_SSL_CONNECTION_ERROR | SSL connection error |
| 2049 | CR_SECURE_AUTH | Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) |
| 2054 | CR_NOT_IMPLEMENTED | This feature is not implemented |
