mysql错误码
时间：2008-04-22 来源：mars531706
| Error Code | SQL State | Message |
| End of Server Errors | ||
| Error: 1000 | SQLSTATE: HY000 ER_HASHCHK | Message: hashchk |
| Error: 1001 | SQLSTATE: HY000 ER_NISAMCHK | Message: isamchk |
| Error: 1002 | SQLSTATE: HY000 ER_NO | Message: NO |
| Error: 1003 | SQLSTATE: HY000 ER_YES | Message: YES |
| Error: 1004 | SQLSTATE: HY000 ER_CANT_CREATE_FILE | Message: Can't create file '%s' errno: %d |
| Error: 1005 | SQLSTATE: HY000 ER_CANT_CREATE_TABLE | Message: Can't create table '%s' errno: %d |
| Error: 1006 | SQLSTATE: HY000 ER_CANT_CREATE_DB | Message: Can't create database '%s' errno: %d |
| Error: 1007 | SQLSTATE: HY000 ER_DB_CREATE_EXISTS | Message: Can't create database '%s'; database exists |
| Error: 1008 | SQLSTATE: HY000 ER_DB_DROP_EXISTS | Message: Can't drop database '%s'; database doesn't exist |
| Error: 1009 | SQLSTATE: HY000 ER_DB_DROP_DELETE | Message: Error dropping database can't delete '%s', errno: %d |
| Error: 1010 | SQLSTATE: HY000 ER_DB_DROP_RMDIR | Message: Error dropping database can't rmdir '%s', errno: %d |
| Error: 1011 | SQLSTATE: HY000 ER_CANT_DELETE_FILE | Message: Error on delete of '%s' errno: %d |
| Error: 1012 | SQLSTATE: HY000 ER_CANT_FIND_SYSTEM_REC | Message: Can't read record in system table |
| Error: 1013 | SQLSTATE: HY000 ER_CANT_GET_STAT | Message: Can't get status of '%s' errno: %d |
| Error: 1014 | SQLSTATE: HY000 ER_CANT_GET_WD | Message: Can't get working directory errno: %d |
| Error: 1015 | SQLSTATE: HY000 ER_CANT_LOCK | Message: Can't lock file errno: %d |
| Error: 1016 | SQLSTATE: HY000 ER_CANT_OPEN_FILE | Message: Can't open file: '%s' errno: %d |
| Error: 1017 | SQLSTATE: HY000 ER_FILE_NOT_FOUND | Message: Can't find file: '%s' errno: %d |
| Error: 1018 | SQLSTATE: HY000 ER_CANT_READ_DIR | Message: Can't read dir of '%s' errno: %d |
| Error: 1019 | SQLSTATE: HY000 ER_CANT_SET_WD | Message: Can't change dir to '%s' errno: %d |
| Error: 1020 | SQLSTATE: HY000 ER_CHECKREAD | Message: Record has changed since last read in table '%s' |
| Error: 1021 | SQLSTATE: HY000 ER_DISK_FULL | Message: Disk full %s; waiting for someone to free some space... |
| Error: 1022 | SQLSTATE: 23000 ER_DUP_KEY | Message: Can't write; duplicate key in table '%s' |
| Error: 1023 | SQLSTATE: HY000 ER_ERROR_ON_CLOSE | Message: Error on close of '%s' errno: %d |
| Error: 1024 | SQLSTATE: HY000 ER_ERROR_ON_READ | Message: Error reading file '%s' errno: %d |
| Error: 1025 | SQLSTATE: HY000 ER_ERROR_ON_RENAME | Message: Error on rename of '%s' to '%s' errno: %d |
| Error: 1026 | SQLSTATE: HY000 ER_ERROR_ON_WRITE | Message: Error writing file '%s' errno: %d |
| Error: 1027 | SQLSTATE: HY000 ER_FILE_USED | Message: '%s' is locked against change |
| Error: 1028 | SQLSTATE: HY000 ER_FILSORT_ABORT | Message: Sort aborted |
| Error: 1029 | SQLSTATE: HY000 ER_FORM_NOT_FOUND | Message: View '%s' doesn't exist for '%s' |
| Error: 1030 | SQLSTATE: HY000 ER_GET_ERRNO | Message: Got error %d from storage engine |
| Error: 1031 | SQLSTATE: HY000 ER_ILLEGAL_HA | Message: Table storage engine for '%s' doesn't have this option |
| Error: 1032 | SQLSTATE: HY000 ER_KEY_NOT_FOUND | Message: Can't find record in '%s' |
| Error: 1033 | SQLSTATE: HY000 ER_NOT_FORM_FILE | Message: Incorrect information in file: '%s' |
| Error: 1034 | SQLSTATE: HY000 ER_NOT_KEYFILE | Message: Incorrect key file for table '%s'; try to repair it |
| Error: 1035 | SQLSTATE: HY000 ER_OLD_KEYFILE | Message: Old key file for table '%s'; repair it! |
| Error: 1036 | SQLSTATE: HY000 ER_OPEN_AS_READONLY | Message: Table '%s' is read only |
| Error: 1037 | SQLSTATE: HY001 ER_OUTOFMEMORY | Message: Out of memory; restart server and try again needed %d bytes |
| Error: 1038 | SQLSTATE: HY001 ER_OUT_OF_SORTMEMORY | Message: Out of sort memory; increase server sort buffer size |
| Error: 1039 | SQLSTATE: HY000 ER_UNEXPECTED_EOF | Message: Unexpected EOF found when reading file '%s' errno: %d |
| Error: 1040 | SQLSTATE: 08004 ER_CON_COUNT_ERROR | Message: Too many connections |
| Error: 1041 | SQLSTATE: HY000 ER_OUT_OF_RESOURCES | Message: 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 |
| Error: 1042 | SQLSTATE: 08S01 ER_BAD_HOST_ERROR | Message: Can't get hostname for your address |
| Error: 1043 | SQLSTATE: 08S01 ER_HANDSHAKE_ERROR | Message: Bad handshake |
| Error: 1044 | SQLSTATE: 42000 ER_DBACCESS_DENIED_ERROR | Message: Access denied for user '%s'@'%s' to database '%s' |
| Error: 1045 | SQLSTATE: 28000 ER_ACCESS_DENIED_ERROR | Message: Access denied for user '%s'@'%s' using password: %s |
| Error: 1046 | SQLSTATE: 3D000 ER_NO_DB_ERROR | Message: No database selected |
| Error: 1047 | SQLSTATE: 08S01 ER_UNKNOWN_COM_ERROR | Message: Unknown command |
| Error: 1048 | SQLSTATE: 23000 ER_BAD_NULL_ERROR | Message: Column '%s' cannot be null |
| Error: 1049 | SQLSTATE: 42000 ER_BAD_DB_ERROR | Message: Unknown database '%s' |
| Error: 1050 | SQLSTATE: 42S01 ER_TABLE_EXISTS_ERROR | Message: Table '%s' already exists |
| Error: 1051 | SQLSTATE: 42S02 ER_BAD_TABLE_ERROR | Message: Unknown table '%s' |
| Error: 1052 | SQLSTATE: 23000 ER_NON_UNIQ_ERROR | Message: Column '%s' in %s is ambiguous |
| Error: 1053 | SQLSTATE: 08S01 ER_SERVER_SHUTDOWN | Message: Server shutdown in progress |
| Error: 1054 | SQLSTATE: 42S22 ER_BAD_FIELD_ERROR | Message: Unknown column '%s' in '%s' |
| Error: 1055 | SQLSTATE: 42000 ER_WRONG_FIELD_WITH_GROUP | Message: '%s' isn't in GROUP BY |
| Error: 1056 | SQLSTATE: 42000 ER_WRONG_GROUP_FIELD | Message: Can't group on '%s' |
| Error: 1057 | SQLSTATE: 42000 ER_WRONG_SUM_SELECT | Message: Statement has sum functions and columns in same statement |
| Error: 1058 | SQLSTATE: 21S01 ER_WRONG_VALUE_COUNT | Message: Column count doesn't match value count |
| Error: 1059 | SQLSTATE: 42000 ER_TOO_LONG_IDENT | Message: Identifier name '%s' is too long |
| Error: 1060 | SQLSTATE: 42S21 ER_DUP_FIELDNAME | Message: Duplicate column name '%s' |
| Error: 1061 | SQLSTATE: 42000 ER_DUP_KEYNAME | Message: Duplicate key name '%s' |
| Error: 1062 | SQLSTATE: 23000 ER_DUP_ENTRY | Message: Duplicate entry '%s' for key %d |
| Error: 1063 | SQLSTATE: 42000 ER_WRONG_FIELD_SPEC | Message: Incorrect column specifier for column '%s' |
| Error: 1064 | SQLSTATE: 42000 ER_PARSE_ERROR | Message: %s near '%s' at line %d |
| Error: 1065 | SQLSTATE: HY000 ER_EMPTY_QUERY | Message: Query was empty |
| Error: 1066 | SQLSTATE: 42000 ER_NONUNIQ_TABLE | Message: Not unique table/alias: '%s' |
| Error: 1067 | SQLSTATE: 42000 ER_INVALID_DEFAULT | Message: Invalid default value for '%s' |
| Error: 1068 | SQLSTATE: 42000 ER_MULTIPLE_PRI_KEY | Message: Multiple primary key defined |
| Error: 1069 | SQLSTATE: 42000 ER_TOO_MANY_KEYS | Message: Too many keys specified; max %d keys allowed |
| Error: 1070 | SQLSTATE: 42000 ER_TOO_MANY_KEY_PARTS | Message: Too many key parts specified; max %d parts allowed |
| Error: 1071 | SQLSTATE: 42000 ER_TOO_LONG_KEY | Message: Specified key was too long; max key length is %d bytes |
| Error: 1072 | SQLSTATE: 42000 ER_KEY_COLUMN_DOES_NOT_EXITS | Message: Key column '%s' doesn't exist in table |
| Error: 1073 | SQLSTATE: 42000 ER_BLOB_USED_AS_KEY | Message: BLOB column '%s' can't be used in key specification with the used table type |
| Error: 1074 | SQLSTATE: 42000 ER_TOO_BIG_FIELDLENGTH | Message: Column length too big for column '%s' max = %d; use BLOB instead |
| Error: 1075 | SQLSTATE: 42000 ER_WRONG_AUTO_KEY | Message: Incorrect table definition; there can be only one auto column and it must be defined as a key |
| Error: 1076 | SQLSTATE: HY000 ER_READY | Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d |
| Error: 1077 | SQLSTATE: HY000 ER_NORMAL_SHUTDOWN | Message: %s: Normal shutdown |
| Error: 1078 | SQLSTATE: HY000 ER_GOT_SIGNAL | Message: %s: Got signal %d. Aborting! |
| Error: 1079 | SQLSTATE: HY000 ER_SHUTDOWN_COMPLETE | Message: %s: Shutdown complete |
| Error: 1080 | SQLSTATE: 08S01 ER_FORCING_CLOSE | Message: %s: Forcing close of thread %ld user: '%s' |
| Error: 1081 | SQLSTATE: 08S01 ER_IPSOCK_ERROR | Message: Can't create IP socket |
| Error: 1082 | SQLSTATE: 42S12 ER_NO_SUCH_INDEX | Message: Table '%s' has no index like the one used in CREATE INDEX; recreate the table |
| Error: 1083 | SQLSTATE: 42000 ER_WRONG_FIELD_TERMINATORS | Message: Field separator argument is not what is expected; check the manual |
| Error: 1084 | SQLSTATE: 42000 ER_BLOBS_AND_NO_TERMINATED | Message: You can't use fixed rowlength with BLOBs; please use 'fields terminated by' |
| Error: 1085 | SQLSTATE: HY000 ER_TEXTFILE_NOT_READABLE | Message: The file '%s' must be in the database directory or be readable by all |
| Error: 1086 | SQLSTATE: HY000 ER_FILE_EXISTS_ERROR | Message: File '%s' already exists |
| Error: 1087 | SQLSTATE: HY000 ER_LOAD_INFO | Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld |
| Error: 1088 | SQLSTATE: HY000 ER_ALTER_INFO | Message: Records: %ld Duplicates: %ld |
| Error: 1089 | SQLSTATE: HY000 ER_WRONG_SUB_KEY | Message: Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys |
| Error: 1090 | SQLSTATE: 42000 ER_CANT_REMOVE_ALL_FIELDS | Message: You can't delete all columns with ALTER TABLE; use DROP TABLE instead |
| Error: 1091 | SQLSTATE: 42000 ER_CANT_DROP_FIELD_OR_KEY | Message: Can't DROP '%s'; check that column/key exists |
| Error: 1092 | SQLSTATE: HY000 ER_INSERT_INFO | Message: Records: %ld Duplicates: %ld Warnings: %ld |
| Error: 1093 | SQLSTATE: HY000 ER_UPDATE_TABLE_USED | Message: You can't specify target table '%s' for update in FROM clause |
| Error: 1094 | SQLSTATE: HY000 ER_NO_SUCH_THREAD | Message: Unknown thread id: %lu |
| Error: 1095 | SQLSTATE: HY000 ER_KILL_DENIED_ERROR | Message: You are not owner of thread %lu |
| Error: 1096 | SQLSTATE: HY000 ER_NO_TABLES_USED | Message: No tables used |
| Error: 1097 | SQLSTATE: HY000 ER_TOO_BIG_SET | Message: Too many strings for column %s and SET |
| Error: 1098 | SQLSTATE: HY000 ER_NO_UNIQUE_LOGFILE | Message: Can't generate a unique log-filename %s.1-999 |
| Error: 1099 | SQLSTATE: HY000 ER_TABLE_NOT_LOCKED_FOR_WRITE | Message: Table '%s' was locked with a READ lock and can't be updated |
| Error: 1100 | SQLSTATE: HY000 ER_TABLE_NOT_LOCKED | Message: Table '%s' was not locked with LOCK TABLES |
| Error: 1101 | SQLSTATE: 42000 ER_BLOB_CANT_HAVE_DEFAULT | Message: BLOB/TEXT column '%s' can't have a default value |
| Error: 1102 | SQLSTATE: 42000 ER_WRONG_DB_NAME | Message: Incorrect database name '%s' |
| Error: 1103 | SQLSTATE: 42000 ER_WRONG_TABLE_NAME | Message: Incorrect table name '%s' |
| Error: 1104 | SQLSTATE: 42000 ER_TOO_BIG_SELECT | Message: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay |
| Error: 1105 | SQLSTATE: HY000 ER_UNKNOWN_ERROR | Message: Unknown error |
| Error: 1106 | SQLSTATE: 42000 ER_UNKNOWN_PROCEDURE | Message: Unknown procedure '%s' |
| Error: 1107 | SQLSTATE: 42000 ER_WRONG_PARAMCOUNT_TO_PROCEDURE | Message: Incorrect parameter count to procedure '%s' |
| Error: 1108 | SQLSTATE: HY000 ER_WRONG_PARAMETERS_TO_PROCEDURE | Message: Incorrect parameters to procedure '%s' |
| Error: 1109 | SQLSTATE: 42S02 ER_UNKNOWN_TABLE | Message: Unknown table '%s' in %s |
| Error: 1110 | SQLSTATE: 42000 ER_FIELD_SPECIFIED_TWICE | Message: Column '%s' specified twice |
| Error: 1111 | SQLSTATE: HY000 ER_INVALID_GROUP_FUNC_USE | Message: Invalid use of group function |
| Error: 1112 | SQLSTATE: 42000 ER_UNSUPPORTED_EXTENSION | Message: Table '%s' uses an extension that doesn't exist in this MySQL version |
| Error: 1113 | SQLSTATE: 42000 ER_TABLE_MUST_HAVE_COLUMNS | Message: A table must have at least 1 column |
| Error: 1114 | SQLSTATE: HY000 ER_RECORD_FILE_FULL | Message: The table '%s' is full |
| Error: 1115 | SQLSTATE: 42000 ER_UNKNOWN_CHARACTER_SET | Message: Unknown character set: '%s' |
| Error: 1116 | SQLSTATE: HY000 ER_TOO_MANY_TABLES | Message: Too many tables; MySQL can only use %d tables in a join |
| Error: 1117 | SQLSTATE: HY000 ER_TOO_MANY_FIELDS | Message: Too many columns |
| Error: 1118 | SQLSTATE: 42000 ER_TOO_BIG_ROWSIZE | Message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs |
| Error: 1119 | SQLSTATE: HY000 ER_STACK_OVERRUN | Message: Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed |
| Error: 1120 | SQLSTATE: 42000 ER_WRONG_OUTER_JOIN | Message: Cross dependency found in OUTER JOIN; examine your ON conditions |
| Error: 1121 | SQLSTATE: 42000 ER_NULL_COLUMN_IN_INDEX | Message: Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL |
| Error: 1122 | SQLSTATE: HY000 ER_CANT_FIND_UDF | Message: Can't load function '%s' |
| Error: 1123 | SQLSTATE: HY000 ER_CANT_INITIALIZE_UDF | Message: Can't initialize function '%s'; %s |
| Error: 1124 | SQLSTATE: HY000 ER_UDF_NO_PATHS | Message: No paths allowed for shared library |
| Error: 1125 | SQLSTATE: HY000 ER_UDF_EXISTS | Message: Function '%s' already exists |
| Error: 1126 | SQLSTATE: HY000 ER_CANT_OPEN_LIBRARY | Message: Can't open shared library '%s' errno: %d %s |
| Error: 1127 | SQLSTATE: HY000 ER_CANT_FIND_DL_ENTRY | Message: Can't find function '%s' in library' |
| Error: 1128 | SQLSTATE: HY000 ER_FUNCTION_NOT_DEFINED | Message: Function '%s' is not defined |
| Error: 1129 | SQLSTATE: HY000 ER_HOST_IS_BLOCKED | Message: Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' |
| Error: 1130 | SQLSTATE: HY000 ER_HOST_NOT_PRIVILEGED | Message: Host '%s' is not allowed to connect to this MySQL server |
| Error: 1131 | SQLSTATE: 42000 ER_PASSWORD_ANONYMOUS_USER | Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords |
| Error: 1132 | SQLSTATE: 42000 ER_PASSWORD_NOT_ALLOWED | Message: You must have privileges to update tables in the mysql database to be able to change passwords for others |
| Error: 1133 | SQLSTATE: 42000 ER_PASSWORD_NO_MATCH | Message: Can't find any matching row in the user table |
| Error: 1134 | SQLSTATE: HY000 ER_UPDATE_INFO | Message: Rows matched: %ld Changed: %ld Warnings: %ld |
| Error: 1135 | SQLSTATE: HY000 ER_CANT_CREATE_THREAD | Message: Can't create a new thread errno %d; if you are not out of available memory, you can consult the manual for a possible OS-dependent bug |
| Error: 1136 | SQLSTATE: 21S01 ER_WRONG_VALUE_COUNT_ON_ROW | Message: Column count doesn't match value count at row %ld |
| Error: 1137 | SQLSTATE: HY000 ER_CANT_REOPEN_TABLE | Message: Can't reopen table: '%s' |
| Error: 1138 | SQLSTATE: 22004 ER_INVALID_USE_OF_NULL | Message: Invalid use of NULL value |
| Error: 1139 | SQLSTATE: 42000 ER_REGEXP_ERROR | Message: Got error '%s' from regexp |
| Error: 1140 | SQLSTATE: 42000 ER_MIX_OF_GROUP_FUNC_AND_FIELDS | Message: Mixing of GROUP columns MIN,MAX,COUNT,... with no GROUP columns is illegal if there is no GROUP BY clause |
| Error: 1141 | SQLSTATE: 42000 ER_NONEXISTING_GRANT | Message: There is no such grant defined for user '%s' on host '%s' |
| Error: 1142 | SQLSTATE: 42000 ER_TABLEACCESS_DENIED_ERROR | Message: %s command denied to user '%s'@'%s' for table '%s' |
| Error: 1143 | SQLSTATE: 42000 ER_COLUMNACCESS_DENIED_ERROR | Message: %s command denied to user '%s'@'%s' for column '%s' in table '%s' |
| Error: 1144 | SQLSTATE: 42000 ER_ILLEGAL_GRANT_FOR_TABLE | Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used |
| Error: 1145 | SQLSTATE: 42000 ER_GRANT_WRONG_HOST_OR_USER | Message: The host or user argument to GRANT is too long |
| Error: 1146 | SQLSTATE: 42S02 ER_NO_SUCH_TABLE | Message: Table '%s.%s' doesn't exist |
| Error: 1147 | SQLSTATE: 42000 ER_NONEXISTING_TABLE_GRANT | Message: There is no such grant defined for user '%s' on host '%s' on table '%s' |
| Error: 1148 | SQLSTATE: 42000 ER_NOT_ALLOWED_COMMAND | Message: The used command is not allowed with this MySQL version |
| Error: 1149 | SQLSTATE: 42000 ER_SYNTAX_ERROR | Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use |
| Error: 1150 | SQLSTATE: HY000 ER_DELAYED_CANT_CHANGE_LOCK | Message: Delayed insert thread couldn't get requested lock for table %s |
| Error: 1151 | SQLSTATE: HY000 ER_TOO_MANY_DELAYED_THREADS | Message: Too many delayed threads in use |
| Error: 1152 | SQLSTATE: 08S01 ER_ABORTING_CONNECTION | Message: Aborted connection %ld to db: '%s' user: '%s' %s |
| Error: 1153 | SQLSTATE: 08S01 ER_NET_PACKET_TOO_LARGE | Message: Got a packet bigger than 'max_allowed_packet' bytes |
| Error: 1154 | SQLSTATE: 08S01 ER_NET_READ_ERROR_FROM_PIPE | Message: Got a read error from the connection pipe |
| Error: 1155 | SQLSTATE: 08S01 ER_NET_FCNTL_ERROR | Message: Got an error from fcntl |
| Error: 1156 | SQLSTATE: 08S01 ER_NET_PACKETS_OUT_OF_ORDER | Message: Got packets out of order |
| Error: 1157 | SQLSTATE: 08S01 ER_NET_UNCOMPRESS_ERROR | Message: Couldn't uncompress communication packet |
| Error: 1158 | SQLSTATE: 08S01 ER_NET_READ_ERROR | Message: Got an error reading communication packets |
| Error: 1159 | SQLSTATE: 08S01 ER_NET_READ_INTERRUPTED | Message: Got timeout reading communication packets |
| Error: 1160 | SQLSTATE: 08S01 ER_NET_ERROR_ON_WRITE | Message: Got an error writing communication packets |
| Error: 1161 | SQLSTATE: 08S01 ER_NET_WRITE_INTERRUPTED | Message: Got timeout writing communication packets |
| Error: 1162 | SQLSTATE: 42000 ER_TOO_LONG_STRING | Message: Result string is longer than 'max_allowed_packet' bytes |
| Error: 1163 | SQLSTATE: 42000 ER_TABLE_CANT_HANDLE_BLOB | Message: The used table type doesn't support BLOB/TEXT columns |
| Error: 1164 | SQLSTATE: 42000 ER_TABLE_CANT_HANDLE_AUTO_INCREMENT | Message: The used table type doesn't support AUTO_INCREMENT columns |
| Error: 1165 | SQLSTATE: HY000 ER_DELAYED_INSERT_TABLE_LOCKED | Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES |
| Error: 1166 | SQLSTATE: 42000 ER_WRONG_COLUMN_NAME | Message: Incorrect column name '%s' |
| Error: 1167 | SQLSTATE: 42000 ER_WRONG_KEY_COLUMN | Message: The used storage engine can't index column '%s' |
| Error: 1168 | SQLSTATE: HY000 ER_WRONG_MRG_TABLE | Message: All tables in the MERGE table are not identically defined |
| Error: 1169 | SQLSTATE: 23000 ER_DUP_UNIQUE | Message: Can't write, because of unique constraint, to table '%s' |
| Error: 1170 | SQLSTATE: 42000 ER_BLOB_KEY_WITHOUT_LENGTH | Message: BLOB/TEXT column '%s' used in key specification without a key length |
| Error: 1171 | SQLSTATE: 42000 ER_PRIMARY_CANT_HAVE_NULL | Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead |
| Error: 1172 | SQLSTATE: 42000 ER_TOO_MANY_ROWS | Message: Result consisted of more than one row |
| Error: 1173 | SQLSTATE: 42000 ER_REQUIRES_PRIMARY_KEY | Message: This table type requires a primary key |
| Error: 1174 | SQLSTATE: HY000 ER_NO_RAID_COMPILED | Message: This version of MySQL is not compiled with RAID support |
| Error: 1175 | SQLSTATE: HY000 ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE | Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column |
| Error: 1176 | SQLSTATE: HY000 ER_KEY_DOES_NOT_EXITS | Message: Key '%s' doesn't exist in table '%s' |
| Error: 1177 | SQLSTATE: 42000 ER_CHECK_NO_SUCH_TABLE | Message: Can't open table |
| Error: 1178 | SQLSTATE: 42000 ER_CHECK_NOT_IMPLEMENTED | Message: The storage engine for the table doesn't support %s |
| Error: 1179 | SQLSTATE: 25000 ER_CANT_DO_THIS_DURING_AN_TRANSACTION | Message: You are not allowed to execute this command in a transaction |
| Error: 1180 | SQLSTATE: HY000 ER_ERROR_DURING_COMMIT | Message: Got error %d during COMMIT |
| Error: 1181 | SQLSTATE: HY000 ER_ERROR_DURING_ROLLBACK | Message: Got error %d during ROLLBACK |
| Error: 1182 | SQLSTATE: HY000 ER_ERROR_DURING_FLUSH_LOGS | Message: Got error %d during FLUSH_LOGS |
| Error: 1183 | SQLSTATE: HY000 ER_ERROR_DURING_CHECKPOINT | Message: Got error %d during CHECKPOINT |
| Error: 1184 | SQLSTATE: 08S01 ER_NEW_ABORTING_CONNECTION | Message: Aborted connection %ld to db: '%s' user: '%s' host: `%s' %s |
| Error: 1185 | SQLSTATE: HY000 ER_DUMP_NOT_IMPLEMENTED | Message: The storage engine for the table does not support binary table dump |
| Error: 1186 | SQLSTATE: HY000 ER_FLUSH_MASTER_BINLOG_CLOSED | Message: Binlog closed, cannot RESET MASTER |
| Error: 1187 | SQLSTATE: HY000 ER_INDEX_REBUILD | Message: Failed rebuilding the index of dumped table '%s' |
| Error: 1188 | SQLSTATE: HY000 ER_MASTER | Message: Error from master: '%s' |
| Error: 1189 | SQLSTATE: 08S01 ER_MASTER_NET_READ | Message: Net error reading from master |
| Error: 1190 | SQLSTATE: 08S01 ER_MASTER_NET_WRITE | Message: Net error writing to master |
| Error: 1191 | SQLSTATE: HY000 ER_FT_MATCHING_KEY_NOT_FOUND | Message: Can't find FULLTEXT index matching the column list |
| Error: 1192 | SQLSTATE: HY000 ER_LOCK_OR_ACTIVE_TRANSACTION | Message: Can't execute the given command because you have active locked tables or an active transaction |
| Error: 1193 | SQLSTATE: HY000 ER_UNKNOWN_SYSTEM_VARIABLE | Message: Unknown system variable '%s' |
| Error: 1194 | SQLSTATE: HY000 ER_CRASHED_ON_USAGE | Message: Table '%s' is marked as crashed and should be repaired |
| Error: 1195 | SQLSTATE: HY000 ER_CRASHED_ON_REPAIR | Message: Table '%s' is marked as crashed and last automatic? repair failed |
| Error: 1196 | SQLSTATE: HY000 ER_WARNING_NOT_COMPLETE_ROLLBACK | Message: Some non-transactional changed tables couldn't be rolled back |
| Error: 1197 | SQLSTATE: HY000 ER_TRANS_CACHE_FULL | Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again |
| Error: 1198 | SQLSTATE: HY000 ER_SLAVE_MUST_STOP | Message: This operation cannot be performed with a running slave; run STOP SLAVE first |
| Error: 1199 | SQLSTATE: HY000 ER_SLAVE_NOT_RUNNING | Message: This operation requires a running slave; configure slave and do START SLAVE |
| Error: 1200 | SQLSTATE: HY000 ER_BAD_SLAVE | Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO |
| Error: 1201 | SQLSTATE: HY000 ER_MASTER_INFO | Message: Could not initialize master info structure; more error messages can be found in the MySQL error log |
| Error: 1202 | SQLSTATE: HY000 ER_SLAVE_THREAD | Message: Could not create slave thread; check system resources |
| Error: 1203 | SQLSTATE: 42000 ER_TOO_MANY_USER_CONNECTIONS | Message: User %s has already more than 'max_user_connections' active connections |
| Error: 1204 | SQLSTATE: HY000 ER_SET_CONSTANTS_ONLY | Message: You may only use constant expressions with SET |
| Error: 1205 | SQLSTATE: HY000 ER_LOCK_WAIT_TIMEOUT | Message: Lock wait timeout exceeded; try restarting transaction |
| Error: 1206 | SQLSTATE: HY000 ER_LOCK_TABLE_FULL | Message: The total number of locks exceeds the lock table size |
| Error: 1207 | SQLSTATE: 25000 ER_READ_ONLY_TRANSACTION | Message: Update locks cannot be acquired during a READ UNCOMMITTED transaction |
| Error: 1208 | SQLSTATE: HY000 ER_DROP_DB_WITH_READ_LOCK | Message: DROP DATABASE not allowed while thread is holding global read lock |
| Error: 1209 | SQLSTATE: HY000 ER_CREATE_DB_WITH_READ_LOCK | Message: CREATE DATABASE not allowed while thread is holding global read lock |
| Error: 1210 | SQLSTATE: HY000 ER_WRONG_ARGUMENTS | Message: Incorrect arguments to %s |
| Error: 1211 | SQLSTATE: 42000 ER_NO_PERMISSION_TO_CREATE_USER | Message: '%s'@'%s' is not allowed to create new users |
| Error: 1212 | SQLSTATE: HY000 ER_UNION_TABLES_IN_DIFFERENT_DIR | Message: Incorrect table definition; all MERGE tables must be in the same database |
| Error: 1213 | SQLSTATE: 40001 ER_LOCK_DEADLOCK | Message: Deadlock found when trying to get lock; try restarting transaction |
| Error: 1214 | SQLSTATE: HY000 ER_TABLE_CANT_HANDLE_FT | Message: The used table type doesn't support FULLTEXT indexes |
| Error: 1215 | SQLSTATE: HY000 ER_CANNOT_ADD_FOREIGN | Message: Cannot add foreign key constraint |
| Error: 1216 | SQLSTATE: 23000 ER_NO_REFERENCED_ROW | Message: Cannot add or update a child row: a foreign key constraint fails |
| Error: 1217 | SQLSTATE: 23000 ER_ROW_IS_REFERENCED | Message: Cannot delete or update a parent row: a foreign key constraint fails |
| Error: 1218 | SQLSTATE: 08S01 ER_CONNECT_TO_MASTER | Message: Error connecting to master: %s |
| Error: 1219 | SQLSTATE: HY000 ER_QUERY_ON_MASTER | Message: Error running query on master: %s |
| Error: 1220 | SQLSTATE: HY000 ER_ERROR_WHEN_EXECUTING_COMMAND | Message: Error when executing command %s: %s |
| Error: 1221 | SQLSTATE: HY000 ER_WRONG_USAGE | Message: Incorrect usage of %s and %s |
| Error: 1222 | SQLSTATE: 21000 ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT | Message: The used SELECT statements have a different number of columns |
| Error: 1223 | SQLSTATE: HY000 ER_CANT_UPDATE_WITH_READLOCK | Message: Can't execute the query because you have a conflicting read lock |
| Error: 1224 | SQLSTATE: HY000 ER_MIXING_NOT_ALLOWED | Message: Mixing of transactional and non-transactional tables is disabled |
| Error: 1225 | SQLSTATE: HY000 ER_DUP_ARGUMENT | Message: Option '%s' used twice in statement |
| Error: 1226 | SQLSTATE: 42000 ER_USER_LIMIT_REACHED | Message: User '%s' has exceeded the '%s' resource current value: %ld |
| Error: 1227 | SQLSTATE: HY000 ER_SPECIFIC_ACCESS_DENIED_ERROR | Message: Access denied; you need the %s privilege for this operation |
| Error: 1228 | SQLSTATE: HY000 ER_LOCAL_VARIABLE | Message: Variable '%s' is a SESSION variable and can't be used with SET GLOBAL |
| Error: 1229 | SQLSTATE: HY000 ER_GLOBAL_VARIABLE | Message: Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL |
| Error: 1230 | SQLSTATE: 42000 ER_NO_DEFAULT | Message: Variable '%s' doesn't have a default value |
| Error: 1231 | SQLSTATE: 42000 ER_WRONG_VALUE_FOR_VAR | Message: Variable '%s' can't be set to the value of '%s' |
| Error: 1232 | SQLSTATE: 42000 ER_WRONG_TYPE_FOR_VAR | Message: Incorrect argument type to variable '%s' |
| Error: 1233 | SQLSTATE: HY000 ER_VAR_CANT_BE_READ | Message: Variable '%s' can only be set, not read |
| Error: 1234 | SQLSTATE: 42000 ER_CANT_USE_OPTION_HERE | Message: Incorrect usage/placement of '%s' |
| Error: 1235 | SQLSTATE: 42000 ER_NOT_SUPPORTED_YET | Message: This version of MySQL doesn't yet support '%s' |
| Error: 1236 | SQLSTATE: HY000 ER_MASTER_FATAL_ERROR_READING_BINLOG | Message: Got fatal error %d: '%s' from master when reading data from binary log |
| Error: 1237 | SQLSTATE: HY000 ER_SLAVE_IGNORED_TABLE | Message: Slave SQL thread ignored the query because of replicate-*-table rules |
| Error: 1238 | SQLSTATE: HY000 ER_INCORRECT_GLOBAL_LOCAL_VAR | Message: Variable '%s' is a %s variable |
| Error: 1239 | SQLSTATE: 42000 ER_WRONG_FK_DEF | Message: Incorrect foreign key definition for '%s': %s |
| Error: 1240 | SQLSTATE: HY000 ER_KEY_REF_DO_NOT_MATCH_TABLE_REF | Message: Key reference and table reference don't match |
| Error: 1241 | SQLSTATE: 21000 ER_OPERAND_COLUMNS | Message: Operand should contain %d columns |
| Error: 1242 | SQLSTATE: 21000 ER_SUBQUERY_NO_1_ROW | Message: Subquery returns more than 1 row |
| Error: 1243 | SQLSTATE: HY000 ER_UNKNOWN_STMT_HANDLER | Message: Unknown prepared statement handler %.*s given to %s |
| Error: 1244 | SQLSTATE: HY000 ER_CORRUPT_HELP_DB | Message: Help database is corrupt or does not exist |
| Error: 1245 | SQLSTATE: HY000 ER_CYCLIC_REFERENCE | Message: Cyclic reference on subqueries |
| Error: 1246 | SQLSTATE: HY000 ER_AUTO_CONVERT | Message: Converting column '%s' from %s to %s |
| Error: 1247 | SQLSTATE: 42S22 ER_ILLEGAL_REFERENCE | Message: Reference '%s' not supported %s |
| Error: 1248 | SQLSTATE: 42000 ER_DERIVED_MUST_HAVE_ALIAS | Message: Every derived table must have its own alias |
| Error: 1249 | SQLSTATE: 01000 ER_SELECT_REDUCED | Message: Select %u was reduced during optimization |
| Error: 1250 | SQLSTATE: 42000 ER_TABLENAME_NOT_ALLOWED_HERE | Message: Table '%s' from one of the SELECTs cannot be used in %s |
| Error: 1251 | SQLSTATE: 08004 ER_NOT_SUPPORTED_AUTH_MODE | Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client |
| Error: 1252 | SQLSTATE: 42000 ER_SPATIAL_CANT_HAVE_NULL | Message: All parts of a SPATIAL index must be NOT NULL |
| Error: 1253 | SQLSTATE: 42000 ER_COLLATION_CHARSET_MISMATCH | Message: COLLATION '%s' is not valid for CHARACTER SET '%s' |
| Error: 1254 | SQLSTATE: HY000 ER_SLAVE_WAS_RUNNING | Message: Slave is already running |
| Error: 1255 | SQLSTATE: HY000 ER_SLAVE_WAS_NOT_RUNNING | Message: Slave has already been stopped |
| Error: 1256 | SQLSTATE: HY000 ER_TOO_BIG_FOR_UNCOMPRESS | Message: Uncompressed data size too large; the maximum size is %d probably, length of uncompressed data was corrupted |
| Error: 1257 | SQLSTATE: HY000 ER_ZLIB_Z_MEM_ERROR | Message: ZLIB: Not enough memory |
| Error: 1258 | SQLSTATE: HY000 ER_ZLIB_Z_BUF_ERROR | Message: ZLIB: Not enough room in the output buffer probably, length of uncompressed data was corrupted |
| Error: 1259 | SQLSTATE: HY000 ER_ZLIB_Z_DATA_ERROR | Message: ZLIB: Input data corrupted |
| Error: 1260 | SQLSTATE: HY000 ER_CUT_VALUE_GROUP_CONCAT | Message: %d lines were cut by GROUP_CONCAT |
| Error: 1261 | SQLSTATE: 01000 ER_WARN_TOO_FEW_RECORDS | Message: Row %ld doesn't contain data for all columns |
| Error: 1262 | SQLSTATE: 01000 ER_WARN_TOO_MANY_RECORDS | Message: Row %ld was truncated; it contained more data than there were input columns |
| Error: 1263 | SQLSTATE: 22004 ER_WARN_NULL_TO_NOTNULL | Message: Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld |
| Error: 1264 | SQLSTATE: 22003 ER_WARN_DATA_OUT_OF_RANGE | Message: Out of range value adjusted for column '%s' at row %ld |
| Error: 1265 | SQLSTATE: 01000 ER_WARN_DATA_TRUNCATED | Message: Data truncated for column '%s' at row %ld |
| Error: 1266 | SQLSTATE: HY000 ER_WARN_USING_OTHER_HANDLER | Message: Using storage engine %s for table '%s' |
| Error: 1267 | SQLSTATE: HY000 ER_CANT_AGGREGATE_2COLLATIONS | Message: Illegal mix of collations %s,%s and %s,%s for operation '%s' |
| Error: 1268 | SQLSTATE: HY000 ER_DROP_USER | Message: Can't drop one or more of the requested users |
| Error: 1269 | SQLSTATE: HY000 ER_REVOKE_GRANTS | Message: Can't revoke all privileges, grant for one or more of the requested users |
| Error: 1270 | SQLSTATE: HY000 ER_CANT_AGGREGATE_3COLLATIONS | Message: Illegal mix of collations %s,%s, %s,%s, %s,%s for operation '%s' |
| Error: 1271 | SQLSTATE: HY000 ER_CANT_AGGREGATE_NCOLLATIONS | Message: Illegal mix of collations for operation '%s' |
| Error: 1272 | SQLSTATE: HY000 ER_VARIABLE_IS_NOT_STRUCT | Message: Variable '%s' is not a variable component can't be used as XXXX.variable_name |
| Error: 1273 | SQLSTATE: HY000 ER_UNKNOWN_COLLATION | Message: Unknown collation: '%s' |
| Error: 1274 | SQLSTATE: HY000 ER_SLAVE_IGNORED_SSL_PARAMS | Message: SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support; they can be used later if MySQL slave with SSL is started |
| Error: 1275 | SQLSTATE: HY000 ER_SERVER_IS_IN_SECURE_AUTH_MODE | Message: Server is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format |
| Error: 1276 | SQLSTATE: HY000 ER_WARN_FIELD_RESOLVED | Message: Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d |
| Error: 1277 | SQLSTATE: HY000 ER_BAD_SLAVE_UNTIL_COND | Message: Incorrect parameter or combination of parameters for START SLAVE UNTIL |
| Error: 1278 | SQLSTATE: HY000 ER_MISSING_SKIP_SLAVE | Message: It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart |
| Error: 1279 | SQLSTATE: HY000 ER_UNTIL_COND_IGNORED | Message: SQL thread is not to be started so UNTIL options are ignored |
| Error: 1280 | SQLSTATE: 42000 ER_WRONG_NAME_FOR_INDEX | Message: Incorrect index name '%s' |
| Error: 1281 | SQLSTATE: 42000 ER_WRONG_NAME_FOR_CATALOG | Message: Incorrect catalog name '%s' |
| Error: 1282 | SQLSTATE: HY000 ER_WARN_QC_RESIZE | Message: Query cache failed to set size %lu; new query cache size is %lu |
| Error: 1283 | SQLSTATE: HY000 ER_BAD_FT_COLUMN | Message: Column '%s' cannot be part of FULLTEXT index |
| Error: 1284 | SQLSTATE: HY000 ER_UNKNOWN_KEY_CACHE | Message: Unknown key cache '%s' |
| Error: 1285 | SQLSTATE: HY000 ER_WARN_HOSTNAME_WONT_WORK | Message: MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work |
| Error: 1286 | SQLSTATE: 42000 ER_UNKNOWN_STORAGE_ENGINE | Message: Unknown table engine '%s' |
| Error: 1287 | SQLSTATE: HY000 ER_WARN_DEPRECATED_SYNTAX | Message: '%s' is deprecated; use '%s' instead |
| Error: 1288 | SQLSTATE: HY000 ER_NON_UPDATABLE_TABLE | Message: The target table %s of the %s is not updatable |
| Error: 1289 | SQLSTATE: HY000 ER_FEATURE_DISABLED | Message: The '%s' feature is disabled; you need MySQL built with '%s' to have it working |
| Error: 1290 | SQLSTATE: HY000 ER_OPTION_PREVENTS_STATEMENT | Message: The MySQL server is running with the %s option so it cannot execute this statement |
| Error: 1291 | SQLSTATE: HY000 ER_DUPLICATED_VALUE_IN_TYPE | Message: Column '%s' has duplicated value '%s' in %s |
| Error: 1292 | SQLSTATE: 22007 ER_TRUNCATED_WRONG_VALUE | Message: Truncated incorrect %s value: '%s' |
| Error: 1293 | SQLSTATE: HY000 ER_TOO_MUCH_AUTO_TIMESTAMP_COLS | Message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause |
| Error: 1294 | SQLSTATE: HY000 ER_INVALID_ON_UPDATE | Message: Invalid ON UPDATE clause for '%s' column |
| Error: 1295 | SQLSTATE: HY000 ER_UNSUPPORTED_PS | Message: This command is not supported in the prepared statement protocol yet |
| Error: 1296 | SQLSTATE: HY000 ER_GET_ERRMSG | Message: Got error %d '%s' from %s |
| Error: 1297 | SQLSTATE: HY000 ER_GET_TEMPORARY_ERRMSG | Message: Got temporary error %d '%s' from %s |
| Error: 1298 | SQLSTATE: HY000 ER_UNKNOWN_TIME_ZONE | Message: Unknown or incorrect time zone: '%s' |
| Error: 1299 | SQLSTATE: HY000 ER_WARN_INVALID_TIMESTAMP | Message: Invalid TIMESTAMP value in column '%s' at row %ld |
| Error: 1300 | SQLSTATE: HY000 ER_INVALID_CHARACTER_STRING | Message: Invalid %s character string: '%s' |
| Error: 1301 | SQLSTATE: HY000 ER_WARN_ALLOWED_PACKET_OVERFLOWED | Message: Result of %s was larger than max_allowed_packet %ld - truncated |
| Error: 1302 | SQLSTATE: HY000 ER_CONFLICTING_DECLARATIONS | Message: Conflicting declarations: '%s%s' and '%s%s' |
| Error: 1303 | SQLSTATE: 2F003 ER_SP_NO_RECURSIVE_CREATE | Message: Can't create a %s from within another stored routine |
| Error: 1304 | SQLSTATE: 42000 ER_SP_ALREADY_EXISTS | Message: %s %s already exists |
| Error: 1305 | SQLSTATE: 42000 ER_SP_DOES_NOT_EXIST | Message: %s %s does not exist |
| Error: 1306 | SQLSTATE: HY000 ER_SP_DROP_FAILED | Message: Failed to DROP %s %s |
| Error: 1307 | SQLSTATE: HY000 ER_SP_STORE_FAILED | Message: Failed to CREATE %s %s |
| Error: 1308 | SQLSTATE: 42000 ER_SP_LILABEL_MISMATCH | Message: %s with no matching label: %s |
| Error: 1309 | SQLSTATE: 42000 ER_SP_LABEL_REDEFINE | Message: Redefining label %s |
| Error: 1310 | SQLSTATE: 42000 ER_SP_LABEL_MISMATCH | Message: End-label %s without match |
| Error: 1311 | SQLSTATE: 01000 ER_SP_UNINIT_VAR | Message: Referring to uninitialized variable %s |
| Error: 1312 | SQLSTATE: 0A000 ER_SP_BADSELECT | Message: SELECT in a stored procedure must have INTO |
| Error: 1313 | SQLSTATE: 42000 ER_SP_BADRETURN | Message: RETURN is only allowed in a FUNCTION |
| Error: 1314 | SQLSTATE: 0A000 ER_SP_BADSTATEMENT | Message: Statements like SELECT, INSERT, UPDATE and others are not allowed in a FUNCTION |
| Error: 1315 | SQLSTATE: 42000 ER_UPDATE_LOG_DEPRECATED_IGNORED | Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored |
| Error: 1316 | SQLSTATE: 42000 ER_UPDATE_LOG_DEPRECATED_TRANSLATED | Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN |
| Error: 1317 | SQLSTATE: 70100 ER_QUERY_INTERRUPTED | Message: Query execution was interrupted |
| Error: 1318 | SQLSTATE: 42000 ER_SP_WRONG_NO_OF_ARGS | Message: Incorrect number of arguments for %s %s; expected %u, got %u |
| Error: 1319 | SQLSTATE: 42000 ER_SP_COND_MISMATCH | Message: Undefined CONDITION: %s |
| Error: 1320 | SQLSTATE: 42000 ER_SP_NORETURN | Message: No RETURN found in FUNCTION %s |
| Error: 1321 | SQLSTATE: 2F005 ER_SP_NORETURNEND | Message: FUNCTION %s ended without RETURN |
| Error: 1322 | SQLSTATE: 42000 ER_SP_BAD_CURSOR_QUERY | Message: Cursor statement must be a SELECT |
| Error: 1323 | SQLSTATE: 42000 ER_SP_BAD_CURSOR_SELECT | Message: Cursor SELECT must not have INTO |
| Error: 1324 | SQLSTATE: 42000 ER_SP_CURSOR_MISMATCH | Message: Undefined CURSOR: %s |
| Error: 1325 | SQLSTATE: 24000 ER_SP_CURSOR_ALREADY_OPEN | Message: Cursor is already open |
| Error: 1326 | SQLSTATE: 24000 ER_SP_CURSOR_NOT_OPEN | Message: Cursor is not open |
| Error: 1327 | SQLSTATE: 42000 ER_SP_UNDECLARED_VAR | Message: Undeclared variable: %s |
| Error: 1328 | SQLSTATE: HY000 ER_SP_WRONG_NO_OF_FETCH_ARGS | Message: Incorrect number of FETCH variables |
| Error: 1329 | SQLSTATE: 02000 ER_SP_FETCH_NO_DATA | Message: No data to FETCH |
| Error: 1330 | SQLSTATE: 42000 ER_SP_DUP_PARAM | Message: Duplicate parameter: %s |
| Error: 1331 | SQLSTATE: 42000 ER_SP_DUP_VAR | Message: Duplicate variable: %s |
| Error: 1332 | SQLSTATE: 42000 ER_SP_DUP_COND | Message: Duplicate condition: %s |
| Error: 1333 | SQLSTATE: 42000 ER_SP_DUP_CURS | Message: Duplicate cursor: %s |
| Error: 1334 | SQLSTATE: HY000 ER_SP_CANT_ALTER | Message: Failed to ALTER %s %s |
| Error: 1335 | SQLSTATE: 0A000 ER_SP_SUBSELECT_NYI | Message: Subselect value not supported |
| Error: 1336 | SQLSTATE: 42000 ER_SP_NO_USE | Message: USE is not allowed in a stored procedure |
| Error: 1337 | SQLSTATE: 42000 ER_SP_VARCOND_AFTER_CURSHNDLR | Message: Variable or condition declaration after cursor or handler declaration |
| Error: 1338 | SQLSTATE: 42000 ER_SP_CURSOR_AFTER_HANDLER | Message: Cursor declaration after handler declaration |
| Error: 1339 | SQLSTATE: 20000 ER_SP_CASE_NOT_FOUND | Message: Case not found for CASE statement |
| Error: 1340 | SQLSTATE: HY000 ER_FPARSER_TOO_BIG_FILE | Message: Configuration file '%s' is too big/ |
| Error: 1341 | SQLSTATE: HY000 ER_FPARSER_BAD_HEADER | Message: Malformed file type header in file '%s' |
| Error: 1342 | SQLSTATE: HY000 ER_FPARSER_EOF_IN_COMMENT | Message: Unexpected end of file while parsing comment '%s' |
| Error: 1343 | SQLSTATE: HY000 ER_FPARSER_ERROR_IN_PARAMETER | Message: Error while parsing parameter '%s' line: '%s' |
| Error: 1344 | SQLSTATE: HY000 ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER | Message: Unexpected end of file while skipping unknown parameter '%s' |
| Error: 1345 | SQLSTATE: HY000 ER_VIEW_NO_EXPLAIN | Message: EXPLAIN/SHOW can not be issued; lacking privileges for underlying table |
| Error: 1346 | SQLSTATE: HY000 ER_FRM_UNKNOWN_TYPE | Message: File '%s' has unknown type '%s' in its header |
| Error: 1347 | SQLSTATE: HY000 ER_WRONG_OBJECT | Message: '%s.%s' is not %s |
| Error: 1348 | SQLSTATE: HY000 ER_NONUPDATEABLE_COLUMN | Message: Column '%s' is not updatable |
| Error: 1349 | SQLSTATE: HY000 ER_VIEW_SELECT_DERIVED | Message: View's SELECT contains a subquery in the FROM clause |
| Error: 1350 | SQLSTATE: HY000 ER_VIEW_SELECT_CLAUSE | Message: View's SELECT contains a '%s' clause |
| Error: 1351 | SQLSTATE: HY000 ER_VIEW_SELECT_VARIABLE | Message: View's SELECT contains a variable or parameter |
| Error: 1352 | SQLSTATE: HY000 ER_VIEW_SELECT_TMPTABLE | Message: View's SELECT contains a temporary table '%s' |
| Error: 1353 | SQLSTATE: HY000 ER_VIEW_WRONG_LIST | Message: View's SELECT and view's field list have different column counts |
| Error: 1354 | SQLSTATE: HY000 ER_WARN_VIEW_MERGE | Message: View merge algorithm can't be used here for now assumed undefined algorithm |
| Error: 1355 | SQLSTATE: HY000 ER_WARN_VIEW_WITHOUT_KEY | Message: View being updated does not have complete key of underlying table in it |
| Error: 1356 | SQLSTATE: HY000 ER_VIEW_INVALID | Message: View '%s.%s' references invalid tables or columns |
| Error: 1357 | SQLSTATE: HY000 ER_SP_NO_DROP_SP | Message: Can't drop a %s from within another stored routine |
| Error: 1358 | SQLSTATE: HY000 ER_SP_GOTO_IN_HNDLR | Message: GOTO is not allowed in a stored procedure handler |
| Error: 1359 | SQLSTATE: HY000 ER_TRG_ALREADY_EXISTS | Message: Trigger already exists |
| Error: 1360 | SQLSTATE: HY000 ER_TRG_DOES_NOT_EXIST | Message: Trigger does not exist |
| Error: 1361 | SQLSTATE: HY000 ER_TRG_ON_VIEW_OR_TEMP_TABLE | Message: Trigger's '%s' is view or temporary table |
| Error: 1362 | SQLSTATE: HY000 ER_TRG_CANT_CHANGE_ROW | Message: Updating of %s row is not allowed in %strigger |
| Error: 1363 | SQLSTATE: HY000 ER_TRG_NO_SUCH_ROW_IN_TRG | Message: There is no %s row in %s trigger |
| Error: 1364 | SQLSTATE: HY000 ER_NO_DEFAULT_FOR_FIELD | Message: Field '%s' doesn't have a default value |
| Error: 1365 | SQLSTATE: 22012 ER_DIVISION_BY_ZERO | Message: Division by 0 |
| Error: 1366 | SQLSTATE: HY000 ER_TRUNCATED_WRONG_VALUE_FOR_FIELD | Message: Incorrect %s value: '%s' for column '%s' at row %ld |
| Error: 1367 | SQLSTATE: 22007 ER_ILLEGAL_VALUE_FOR_TYPE | Message: Illegal %s '%s' value found during parsing |
| Error: 1368 | SQLSTATE: HY000 ER_VIEW_NONUPD_CHECK | Message: CHECK OPTION on non-updatable view '%s.%s' |
| Error: 1369 | SQLSTATE: HY000 ER_VIEW_CHECK_FAILED | Message: CHECK OPTION failed '%s.%s' |
- Server Errors
- Client Errors
Client Errors
| Error Code | SQL State | Message |
| End of Client Errors | ||
| Error: 2000 | CR_UNKNOWN_ERROR | Message: Unknown MySQL error |
| Error: 2001 | CR_SOCKET_CREATE_ERROR | Message: Can't create UNIX socket %d |
| Error: 2002 | CR_CONNECTION_ERROR | Message: Can't connect to local MySQL server through socket '%s' %d |
| Error: 2003 | CR_CONN_HOST_ERROR | Message: Can't connect to MySQL server on '%s' %d |
| Error: 2004 | CR_IPSOCK_ERROR | Message: Can't create TCP/IP socket %d |
| Error: 2005 | CR_UNKNOWN_HOST | Message: Unknown MySQL server host '%s' %d |
| Error: 2006 | CR_SERVER_GONE_ERROR | Message: MySQL server has gone away |
| Error: 2007 | CR_VERSION_ERROR | Message: Protocol mismatch; server version = %d, client version = %d |
| Error: 2008 | CR_OUT_OF_MEMORY | Message: MySQL client ran out of memory |
| Error: 2009 | CR_WRONG_HOST_INFO | Message: Wrong host info |
| Error: 2010 | CR_LOCALHOST_CONNECTION | Message: Localhost via UNIX socket |
| Error: 2011 | CR_TCP_CONNECTION | Message: %s via TCP/IP |
| Error: 2012 | CR_SERVER_HANDSHAKE_ERR | Message: Error in server handshake |
| Error: 2013 | CR_SERVER_LOST | Message: Lost connection to MySQL server during query |
| Error: 2014 | CR_COMMANDS_OUT_OF_SYNC | Message: Commands out of sync; you can't run this command now |
| Error: 2015 | CR_NAMEDPIPE_CONNECTION | Message: %s via named pipe |
| Error: 2016 | CR_NAMEDPIPEWAIT_ERROR | Message: Can't wait for named pipe to host: %s pipe: %s %lu |
| Error: 2017 | CR_NAMEDPIPEOPEN_ERROR | Message: Can't open named pipe to host: %s pipe: %s %lu |
| Error: 2018 | CR_NAMEDPIPESETSTATE_ERROR | Message: Can't set state of named pipe to host: %s pipe: %s %lu |
| Error: 2019 | CR_CANT_READ_CHARSET | Message: Can't initialize character set %s path: %s |
| Error: 2020 | CR_NET_PACKET_TOO_LARGE | Message: Got packet bigger than 'max_allowed_packet' bytes |
| Error: 2021 | CR_EMBEDDED_CONNECTION | Message: Embedded server |
| Error: 2022 | CR_PROBE_SLAVE_STATUS | Message: Error on SHOW SLAVE STATUS: |
| Error: 2023 | CR_PROBE_SLAVE_HOSTS | Message: Error on SHOW SLAVE HOSTS: |
| Error: 2024 | CR_PROBE_SLAVE_CONNECT | Message: Error connecting to slave: |
| Error: 2025 | CR_PROBE_MASTER_CONNECT | Message: Error connecting to master: |
| Error: 2026 | CR_SSL_CONNECTION_ERROR | Message: SSL connection error |
| Error: 2027 | CR_MALFORMED_PACKET | Message: Malformed packet |
| Error: 2028 | CR_WRONG_LICENSE | Message: This client library is licensed only for use with MySQL servers having '%s' license |
| Error: 2029 | CR_NULL_POINTER | Message: Invalid use of null pointer |
| Error: 2030 | CR_NO_PREPARE_STMT | Message: Statement not prepared |
| Error: 2031 | CR_PARAMS_NOT_BOUND | Message: No data supplied for parameters in prepared statement |
| Error: 2032 | CR_DATA_TRUNCATED | Message: Data truncated |
| Error: 2033 | CR_NO_PARAMETERS_EXISTS | Message: No parameters exist in the statement |
| Error: 2034 | CR_INVALID_PARAMETER_NO | Message: Invalid parameter number |
| Error: 2035 | CR_INVALID_BUFFER_USE | Message: Can't send long data for non-string/non-binary data types parameter: %d |
| Error: 2036 | CR_UNSUPPORTED_PARAM_TYPE | Message: Using unsupported buffer type: %d parameter: %d |
| Error: 2037 | CR_SHARED_MEMORY_CONNECTION | Message: Shared memory %lu |
| Error: 2038 | CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR | Message: Can't open shared memory; client could not create request event %lu |
| Error: 2039 | CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR | Message: Can't open shared memory; no answer event received from server %lu |
| Error: 2040 | CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR | Message: Can't open shared memory; server could not allocate file mapping %lu |
| Error: 2041 | CR_SHARED_MEMORY_CONNECT_MAP_ERROR | Message: Can't open shared memory; server could not get pointer to file mapping %lu |
| Error: 2042 | CR_SHARED_MEMORY_FILE_MAP_ERROR | Message: Can't open shared memory; client could not allocate file mapping %lu |
| Error: 2043 | CR_SHARED_MEMORY_MAP_ERROR | Message: Can't open shared memory; client could not get pointer to file mapping %lu |
| Error: 2044 | CR_SHARED_MEMORY_EVENT_ERROR | Message: Can't open shared memory; client could not create %s event %lu |
| Error: 2045 | CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR | Message: Can't open shared memory; no answer from server %lu |
| Error: 2046 | CR_SHARED_MEMORY_CONNECT_SET_ERROR | Message: Can't open shared memory; cannot send request event to server %lu |
| Error: 2047 | CR_CONN_UNKNOW_PROTOCOL | Message: Wrong or unknown protocol |
| Error: 2048 | CR_INVALID_CONN_HANDLE | Message: Invalid connection handle |
| Error: 2049 | CR_SECURE_AUTH | Message: Connection using old pre-4.1.1 authentication protocol refused client option 'secure_auth' enabled |
| Error: 2050 | CR_FETCH_CANCELED | Message: Row retrieval was canceled by mysql_stmt_close call |
| Error: 2051 | CR_NO_DATA | Message: Attempt to read column without prior row fetch |
相关阅读 更多 +
