Go to the first, previous, next, last section, table of contents.

21 Error Handling in MySQL

This chapter lists the errors that MySQL can return.

21.1 Error Returns

Following are error codes that may appear when you call MySQL from any host language.

The Name and Error Code columns correspond to definitions in the `include/mysqld_error.h' MySQL source file.

The SQLSTATE column corresponds to definitions in the `include/sql_state.h' MySQL source file.

The SQLSTATE error code is displayed only if you use MySQL version 4.1 and up. SQLSTATE codes were added for compatibility with X/Open, ANSI, and ODBC behavior.

A suggested text for each error code can be found in the `share/english/errmsg.txt' error-message file.

Because updates are frequent, it is possible that these files will contain additional error codes.

Name Error Code 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_WRONG_FIELD_WITH_GROUP 1055 42000
ER_WRONG_GROUP_FIELD 1056 42000
ER_WRONG_SUM_SELECT 1057 42000
ER_WRONG_VALUE_COUNT 1058 21S01
ER_TOO_LONG_IDENT 1059 42000
ER_DUP_FIELDNAME 1060 42S21
ER_DUP_KEYNAME 1061 42000
ER_DUP_ENTRY 1062 23000
ER_WRONG_FIELD_SPEC 1063 42000
ER_PARSE_ERROR 1064 42000
ER_EMPTY_QUERY 1065 42000
ER_NONUNIQ_TABLE 1066 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_READY 1076 00000
ER_NORMAL_SHUTDOWN 1077 00000
ER_GOT_SIGNAL 1078 00000
ER_SHUTDOWN_COMPLETE 1079 00000
ER_FORCING_CLOSE 1080 08S01
ER_IPSOCK_ERROR 1081 08S01
ER_NO_SUCH_INDEX 1082 42S12
ER_WRONG_FIELD_TERMINATORS 1083 42000
ER_BLOBS_AND_NO_TERMINATED 1084 42000
ER_TEXTFILE_NOT_READABLE 1085 HY000
ER_FILE_EXISTS_ERROR 1086 HY000
ER_LOAD_INFO 1087 HY000
ER_ALTER_INFO 1088 HY000
ER_WRONG_SUB_KEY 1089 HY000
ER_CANT_REMOVE_ALL_FIELDS 1090 42000
ER_CANT_DROP_FIELD_OR_KEY 1091 42000
ER_INSERT_INFO 1092 HY000
ER_UPDATE_TABLE_USED 1093 HY000
ER_NO_SUCH_THREAD 1094 HY000
ER_KILL_DENIED_ERROR 1095 HY000
ER_NO_TABLES_USED 1096 HY000
ER_TOO_BIG_SET 1097 HY000
ER_NO_UNIQUE_LOGFILE 1098 HY000
ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 HY000
ER_TABLE_NOT_LOCKED 1100 HY000
ER_BLOB_CANT_HAVE_DEFAULT 1101 42000
ER_WRONG_DB_NAME 1102 42000
ER_WRONG_TABLE_NAME 1103 42000
ER_TOO_BIG_SELECT 1104 42000
ER_UNKNOWN_ERROR 1105 HY000
ER_UNKNOWN_PROCEDURE 1106 42000
ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107 42000
ER_WRONG_PARAMETERS_TO_PROCEDURE 1108 HY000
ER_UNKNOWN_TABLE 1109 42S02
ER_FIELD_SPECIFIED_TWICE 1110 42000
ER_INVALID_GROUP_FUNC_USE 1111 42000
ER_UNSUPPORTED_EXTENSION 1112 42000
ER_TABLE_MUST_HAVE_COLUMNS 1113 42000
ER_RECORD_FILE_FULL 1114 HY000
ER_UNKNOWN_CHARACTER_SET 1115 42000
ER_TOO_MANY_TABLES 1116 HY000
ER_TOO_MANY_FIELDS 1117 HY000
ER_TOO_BIG_ROWSIZE 1118 42000
ER_STACK_OVERRUN 1119 HY000
ER_WRONG_OUTER_JOIN 1120 42000
ER_NULL_COLUMN_IN_INDEX 1121 42000
ER_CANT_FIND_UDF 1122 HY000
ER_CANT_INITIALIZE_UDF 1123 HY000
ER_UDF_NO_PATHS 1124 HY000
ER_UDF_EXISTS 1125 HY000
ER_CANT_OPEN_LIBRARY 1126 HY000
ER_CANT_FIND_DL_ENTRY 1127 HY000
ER_FUNCTION_NOT_DEFINED 1128 HY000
ER_HOST_IS_BLOCKED 1129 HY000
ER_HOST_NOT_PRIVILEGED 1130 HY000
ER_PASSWORD_ANONYMOUS_USER 1131 42000
ER_PASSWORD_NOT_ALLOWED 1132 42000
ER_PASSWORD_NO_MATCH 1133 42000
ER_UPDATE_INFO 1134 HY000
ER_CANT_CREATE_THREAD 1135 HY000
ER_WRONG_VALUE_COUNT_ON_ROW 1136 21S01
ER_CANT_REOPEN_TABLE 1137 HY000
ER_INVALID_USE_OF_NULL 1138 42000
ER_REGEXP_ERROR 1139 42000
ER_MIX_OF_GROUP_FUNC_AND_FIELDS 1140 42000
ER_NONEXISTING_GRANT 1141 42000
ER_TABLEACCESS_DENIED_ERROR 1142 42000
ER_COLUMNACCESS_DENIED_ERROR@tab 1143 42000
ER_ILLEGAL_GRANT_FOR_TABLE 1144 42000
ER_GRANT_WRONG_HOST_OR_USER 1145 42000
ER_NO_SUCH_TABLE 1146 42S02
ER_NONEXISTING_TABLE_GRANT 1147 42000
ER_NOT_ALLOWED_COMMAND 1148 42000
ER_SYNTAX_ERROR 1149 42000
ER_DELAYED_CANT_CHANGE_LOCK 1150 HY000
ER_TOO_MANY_DELAYED_THREADS 1151 HY000
ER_ABORTING_CONNECTION 1152 08S01
ER_NET_PACKET_TOO_LARGE 1153 08S01
ER_NET_READ_ERROR_FROM_PIPE 1154 08S01
ER_NET_FCNTL_ERROR 1155 08S01
ER_NET_PACKETS_OUT_OF_ORDER 1156 08S01
ER_NET_UNCOMPRESS_ERROR 1157 08S01
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_TOO_LONG_STRING 1162 42000
ER_TABLE_CANT_HANDLE_BLOB 1163 42000
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164 42000
ER_DELAYED_INSERT_TABLE_LOCKED 1165 HY000
ER_WRONG_COLUMN_NAME 1166 42000
ER_WRONG_KEY_COLUMN 1167 42000
ER_WRONG_MRG_TABLE 1168 HY000
ER_DUP_UNIQUE 1169 23000
ER_BLOB_KEY_WITHOUT_LENGTH 1170 42000
ER_PRIMARY_CANT_HAVE_NULL 1171 42000
ER_TOO_MANY_ROWS 1172 42000
ER_REQUIRES_PRIMARY_KEY 1173 42000
ER_NO_RAID_COMPILED 1174 HY000
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE 1175 HY000
ER_KEY_DOES_NOT_EXITS 1176 HY000
ER_CHECK_NO_SUCH_TABLE 1177 42000
ER_CHECK_NOT_IMPLEMENTED 1178 42000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179 25000
ER_ERROR_DURING_COMMIT 1180 HY000
ER_ERROR_DURING_ROLLBACK 1181 HY000
ER_ERROR_DURING_FLUSH_LOGS 1182 HY000
ER_ERROR_DURING_CHECKPOINT 1183 HY000
ER_NEW_ABORTING_CONNECTION 1184 08S01
ER_DUMP_NOT_IMPLEMENTED 1185 HY000
ER_FLUSH_MASTER_BINLOG_CLOSED 1186 HY000
ER_INDEX_REBUILD 1187 HY000
ER_MASTER 1188 HY000
ER_MASTER_NET_READ 1189 08S01
ER_MASTER_NET_WRITE 1190 08S01
ER_FT_MATCHING_KEY_NOT_FOUND 1191 HY000
ER_LOCK_OR_ACTIVE_TRANSACTION 1192 HY000
ER_UNKNOWN_SYSTEM_VARIABLE 1193 HY000
ER_CRASHED_ON_USAGE 1194 HY000
ER_CRASHED_ON_REPAIR 1195 HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK 1196 HY000
ER_TRANS_CACHE_FULL 1197 HY000
ER_SLAVE_MUST_STOP 1198 HY000
ER_SLAVE_NOT_RUNNING 1199 HY000
ER_BAD_SLAVE 1200 HY000
ER_MASTER_INFO 1201 HY000
ER_SLAVE_THREAD 1202 HY000
ER_TOO_MANY_USER_CONNECTIONS 1203 42000
ER_SET_CONSTANTS_ONLY 1204 HY000
ER_LOCK_WAIT_TIMEOUT 1205 HY000
ER_LOCK_TABLE_FULL 1206 HY000
ER_READ_ONLY_TRANSACTION 1207 25000
ER_DROP_DB_WITH_READ_LOCK 1208 HY000
ER_CREATE_DB_WITH_READ_LOCK 1209 HY000
ER_WRONG_ARGUMENTS 1210 HY000
ER_NO_PERMISSION_TO_CREATE_USER 1211 42000
ER_UNION_TABLES_IN_DIFFERENT_DIR 1212 HY000
ER_LOCK_DEADLOCK 1213 40001
ER_TABLE_CANT_HANDLE_FULLTEXT 1214 HY000
ER_CANNOT_ADD_FOREIGN 1215 HY000
ER_NO_REFERENCED_ROW 1216 23000
ER_ROW_IS_REFERENCED 1217 23000
ER_CONNECT_TO_MASTER 1218 08S01
ER_QUERY_ON_MASTER 1219 HY000
ER_ERROR_WHEN_EXECUTING_COMMAND 1220 HY000
ER_WRONG_USAGE 1221 HY000
ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT 1222 21000
ER_CANT_UPDATE_WITH_READLOCK 1223 HY000
ER_MIXING_NOT_ALLOWED 1224 HY000
ER_DUP_ARGUMENT 1225 HY000
ER_USER_LIMIT_REACHED 1226 42000
ER_SPECIFIC_ACCESS_DENIED_ERROR 1227 HY000
ER_LOCAL_VARIABLE 1228 HY000
ER_GLOBAL_VARIABLE 1229 HY000
ER_NO_DEFAULT 1230 42000
ER_WRONG_VALUE_FOR_VAR 1231 42000
ER_WRONG_TYPE_FOR_VAR 1232 42000
ER_VAR_CANT_BE_READ 1233 HY000
ER_CANT_USE_OPTION_HERE 1234 42000
ER_NOT_SUPPORTED_YET 1235 42000
ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 HY000
ER_SLAVE_IGNORED_TABLE 1237 HY000
ER_WRONG_FK_DEF 1238 42000
ER_KEY_REF_DO_NOT_MATCH_TABLE_REF 1239 HY000
ER_CARDINALITY_COL 1240 21000
ER_SUBSELECT_NO_1_ROW 1241 21000
ER_UNKNOWN_STMT_HANDLER 1242 HY000
ER_CORRUPT_HELP_DB 1243 HY000
ER_CYCLIC_REFERENCE 1244 HY000
ER_AUTO_CONVERT 1245 HY000
ER_ILLEGAL_REFERENCE 1246 42S22
ER_DERIVED_MUST_HAVE_ALIAS 1247 42000
ER_SELECT_REDUCED 1248 01000
ER_TABLENAME_NOT_ALLOWED_HERE 1249 42000
ER_NOT_SUPPORTED_AUTH_MODE 1250 08004
ER_SPATIAL_CANT_HAVE_NULL 1251 42000
ER_COLLATION_CHARSET_MISMATCH 1252 42000
ER_SLAVE_WAS_RUNNING 1253 HY000
ER_SLAVE_WAS_NOT_RUNNING 1254 HY000
ER_TOO_BIG_FOR_UNCOMPRESS 1255 HY000
ER_ZLIB_Z_MEM_ERROR 1256 HY000
ER_ZLIB_Z_BUF_ERROR 1257 HY000
ER_ZLIB_Z_DATA_ERROR 1258 HY000
ER_CUT_VALUE_GROUP_CONCAT 1259 HY000
ER_WARN_TOO_FEW_RECORDS 1260 01000
ER_WARN_TOO_MANY_RECORDS 1261 01000
ER_WARN_NULL_TO_NOTNULL 1262 01000
ER_WARN_DATA_OUT_OF_RANGE 1263 01000
ER_WARN_DATA_TRUNCATED 1264 01000
ER_WARN_USING_OTHER_HANDLER 1265 01000
ER_CANT_AGGREGATE_COLLATIONS 1266 42000
ER_DROP_USER 1267 42000
ER_REVOKE_GRANTS 1268 42000
ER_CANT_AGGREGATE_3COLLATIONS 1269 42000
ER_CANT_AGGREGATE_NCOLLATIONS 1270 42000
ER_VARIABLE_IS_NOT_STRUCT 1271 HY000
ER_UNKNOWN_COLLATION 1272 HY000
ER_SLAVE_IGNORED_SSL_PARAMS 1273 HY000
ER_SERVER_IS_IN_SECURE_AUTH_MODE 1274 HY000
ER_WARN_FIELD_RESOLVED 1275 HY000
ER_BAD_SLAVE_UNTIL_COND 1276 HY000
ER_MISSING_SKIP_SLAVE 1277 HY000
ER_UNTIL_COND_IGNORED 1278 HY000

21.2 Error Messages

Following are error messages that may appear when you call MySQL from any host language.

Error Code Error Message
1000 hashchk
1001 isamchk
1002 NO
1003 YES
1004 Can't create file '%s' (errno: %d)
1005 Can't create table '%s' (errno: %d)
1006 Can't create database '%s' (errno: %d)
1007 Can't create database '%s'; database exists
1008 Can't drop database '%s'; database doesn't exist
1009 Error dropping database (can't delete '%s', errno: %d)
1010 Error dropping database (can't rmdir '%s', errno: %d)
1011 Error on delete of '%s' (errno: %d)
1012 Can't read record in system table
1013 Can't get status of '%s' (errno: %d)
1014 Can't get working directory (errno: %d)
1015 Can't lock file (errno: %d)
1016 Can't open file: '%s' (errno: %d)
1017 Can't find file: '%s' (errno: %d)
1018 Can't read dir of '%s' (errno: %d)
1019 Can't change dir to '%s' (errno: %d)
1020 Record has changed since last read in table '%s'
1021 Disk full (%s). Waiting for someone to free some space...
1022 Can't write, duplicate key in table '%s'
1023 Error on close of '%s' (errno: %d)
1024 Error reading file '%s' (errno: %d)
1025 Error on rename of '%s' to '%s' (errno: %d)
1026 Error writing file '%s' (errno: %d)
1027 '%s' is locked against change
1028 Sort aborted
1029 View '%s' doesn't exist for '%s'
1030 Got error %d from storage engine
1031 Table storage engine for '%s' doesn't have this option
1032 Can't find record in '%s'
1033 Incorrect information in file: '%s'
1034 Incorrect key file for table: '%s'; try to repair it
1035 Old key file for table '%s'; repair it!
1036 Table '%s' is read only
1037 Out of memory. Restart daemon and try again (needed %d bytes)
1038 Out of sort memory. Increase daemon sort buffer size
1039 Unexpected eof found when reading file '%s' (errno: %d)
1040 Too many connections
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
1042 Can't get hostname for your address
1043 Bad handshake
1044 Access denied for user: '%s'@'%s' to database '%s'
1045 Access denied for user: '%s'@'%s' (Using password: %s)
1046 No Database Selected
1047 Unknown command
1048 Column '%s' cannot be null
1049 Unknown database '%s'
1050 Table '%s' already exists
1051 Unknown table '%s'
1052 Column: '%s' in %s is ambiguous
1053 Server shutdown in progress
1054 Unknown column '%s' in '%s'
1055 '%s' isn't in GROUP BY
1056 Can't group on '%s'
1057 Statement has sum functions and columns in same statement
1058 Column count doesn't match value count
1059 Identifier name '%s' is too long
1060 Duplicate column name '%s'
1061 Duplicate key name '%s'
1062 Duplicate entry '%s' for key %d
1063 Incorrect column specifier for column '%s'
1064 %s near '%s' at line %d
1065 Query was empty
1066 Not unique table/alias: '%s'
1067 Invalid default value for '%s'
1068 Multiple primary key defined
1069 Too many keys specified. Max %d keys allowed
1070 Too many key parts specified. Max %d parts allowed
1071 Specified key was too long. Max key length is %d
1072 Key column '%s' doesn't exist in table
1073 BLOB column '%s' can't be used in key specification with the used table type
1074 Too big column length for column '%s' (max = %d). Use BLOB instead
1075 Incorrect table definition; There can only be one auto column and it must be defined as a key
1076 %s: ready for connections. Version: '%s' socket: '%s' port: %d
1077 %s: Normal shutdown
1078 %s: Got signal %d. Aborting!
1079 %s: Shutdown Complete
1080 %s: Forcing close of thread %ld user: '%s'
1081 Can't create IP socket
1082 Table '%s' has no index like the one used in CREATE INDEX. Recreate the table
1083 Field separator argument is not what is expected. Check the manual
1084 You can't use fixed rowlength with BLOBs. Please use 'fields terminated by'
1085 The file '%s' must be in the database directory or be readable by all
1086 File '%s' already exists
1087 Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
1088 Records: %ld Duplicates: %ld
1089 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
1090 You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
1091 Can't DROP '%s'. Check that column/key exists
1092 Records: %ld Duplicates: %ld Warnings: %ld
1093 You can't specify target table '%s' for update in FROM clause
1094 Unknown thread id: %lu
1095 You are not owner of thread %lu
1096 No tables used
1097 Too many strings for column %s and SET
1098 Can't generate a unique log-filename %s.(1-999)
1099 Table '%s' was locked with a READ lock and can't be updated
1100 Table '%s' was not locked with LOCK TABLES
1101 BLOB/TEXT column '%s' can't have a default value
1102 Incorrect database name '%s'
1103 Incorrect table name '%s'
1104 The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok
1105 Unknown error
1106 Unknown procedure '%s'
1107 Incorrect parameter count to procedure '%s'
1108 Incorrect parameters to procedure '%s'
1109 Unknown table '%s' in %s
1110 Column '%s' specified twice
1111 Invalid use of group function
1112 Table '%s' uses an extension that doesn't exist in this MySQL version
1113 A table must have at least 1 column
1114 The table '%s' is full
1115 Unknown character set: '%s'
1116 Too many tables. MySQL can only use %d tables in a join
1117 Too many columns
1118 Too big row size. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some fields to TEXT or BLOBs
1119 Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed
1120 Cross dependency found in OUTER JOIN. Examine your ON conditions
1121 Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL
1122 Can't load function '%s'
1123 Can't initialize function '%s'; %s
1124 No paths allowed for shared library
1125 Function '%s' already exist
1126 Can't open shared library '%s' (errno: %d %s)
1127 Can't find function '%s' in library'
1128 Function '%s' is not defined
1129 Host '%s' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
1130 Host '%s' is not allowed to connect to this MySQL server
1131 You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords
1132 You must have privileges to update tables in the mysql database to be able to change passwords for others
1133 Can't find any matching row in the user table
1134 Rows matched: %ld Changed: %ld Warnings: %ld
1135 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
1136 Column count doesn't match value count at row %ld
1137 Can't reopen table: '%s'
1138 Invalid use of NULL value
1139 Got error '%s' from regexp
1140 Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause
1141 There is no such grant defined for user '%s' on host '%s'
1142 %s command denied to user: '%s'@'%s' for table '%s'
1143 %s command denied to user: '%s'@'%s' for column '%s' in table '%s'
1144 Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used
1145 The host or user argument to GRANT is too long
1146 Table '%s.%s' doesn't exist
1147 There is no such grant defined for user '%s' on host '%s' on table '%s'
1148 The used command is not allowed with this MySQL version
1149 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use
1150 Delayed insert thread couldn't get requested lock for table %s
1151 Too many delayed threads in use
1152 Aborted connection %ld to db: '%s' user: '%s' (%s)
1153 Got a packet bigger than 'max_allowed_packet'
1154 Got a read error from the connection pipe
1155 Got an error from fcntl()
1156 Got packets out of order
1157 Couldn't uncompress communication packet
1158 Got an error reading communication packets
1159 Got timeout reading communication packets
1160 Got an error writing communication packets
1161 Got timeout writing communication packets
1162 Result string is longer than max_allowed_packet
1163 The used table type doesn't support BLOB/TEXT columns
1164 The used table type doesn't support AUTO_INCREMENT columns
1165 INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES
1166 Incorrect column name '%s'
1167 The used storage engine can't index column '%s'
1168 All tables in the MERGE table are not identically defined
1169 Can't write, because of unique constraint, to table '%s'
1170 BLOB/TEXT column '%s' used in key specification without a key length
1171 All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
1172 Result consisted of more than one row
1173 This table type requires a primary key
1174 This version of MySQL is not compiled with RAID support
1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
1176 Key '%s' doesn't exist in table '%s'
1177 Can't open table
1178 The storage engine for the table doesn't support %s
1179 You are not allowed to execute this command in a transaction
1180 Got error %d during COMMIT
1181 Got error %d during ROLLBACK
1182 Got error %d during FLUSH_LOGS
1183 Got error %d during CHECKPOINT
1184 Aborted connection %ld to db: '%s' user: '%s' host: `%s' (%s)
1185 The storage engine for the table does not support binary table dump
1186 Binlog closed, cannot RESET MASTER
1187 Failed rebuilding the index of dumped table '%s'
1188 Error from master: '%s'
1189 Net error reading from master
1190 Net error writing to master
1191 Can't find FULLTEXT index matching the column list
1192 Can't execute the given command because you have active locked tables or an active transaction
1193 Unknown system variable '%s'
1194 Table '%s' is marked as crashed and should be repaired
1195 Table '%s' is marked as crashed and last (automatic?) repair failed
1196 Some non-transactional changed tables couldn't be rolled back
1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage. Increase this mysqld variable and try again
1198 This operation cannot be performed with a running slave, run STOP SLAVE first
1199 This operation requires a running slave, configure slave and do START SLAVE
1200 The server is not configured as slave, fix in config file or with CHANGE MASTER TO
1201 Could not initialize master info structure, more error messages can be found in the MySQL error log
1202 Could not create slave thread, check system resources
1203 User %s has already more than 'max_user_connections' active connections
1204 You may only use constant expressions with SET
1205 Lock wait timeout exceeded; Try restarting transaction
1206 The total number of locks exceeds the lock table size
1207 Update locks cannot be acquired during a READ UNCOMMITTED transaction
1208 DROP DATABASE not allowed while thread is holding global read lock
1209 CREATE DATABASE not allowed while thread is holding global read lock
1210 Wrong arguments to %s
1211 '%s'@'%s' is not allowed to create new users
1212 Incorrect table definition; all MERGE tables must be in the same database
1213 Deadlock found when trying to get lock; Try restarting transaction
1214 The used table type doesn't support FULLTEXT indexes
1215 Cannot add foreign key constraint
1216 Cannot add or update a child row: a foreign key constraint fails
1217 Cannot delete or update a parent row: a foreign key constraint fails
1218 Error connecting to master: %s
1219 Error running query on master: %s
1220 Error when executing command %s: %s
1221 Wrong usage of %s and %s
1222 The used SELECT statements have a different number of columns
1223 Can't execute the query because you have a conflicting read lock
1224 Mixing of transactional and non-transactional tables is disabled
1225 Option '%s' used twice in statement
1226 User '%s' has exceeded the '%s' resource (current value: %ld)
1227 Access denied. You need the %s privilege for this operation
1228 Variable '%s' is a LOCAL variable and can't be used with SET GLOBAL
1229 Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL
1230 Variable '%s' doesn't have a default value
1231 Variable '%s' can't be set to the value of '%s'
1232 Wrong argument type to variable '%s'
1233 Variable '%s' can only be set, not read
1234 Wrong usage/placement of '%s'
1235 This version of MySQL doesn't yet support '%s'
1236 Got fatal error %d: '%s' from master when reading data from binary log
1237 Slave SQL thread ignored the query because of replicate-*-table rules
1238 Wrong foreign key definition for '%s': %s
1239 Key reference and table reference doesn't match
1240 Operand should contain %d column(s)
1241 Subquery returns more than 1 row
1242 Unknown prepared statement handler (%ld) given to %s
1243 Help database is corrupt or does not exist
1244 Cyclic reference on subqueries
1245 Converting column '%s' from %s to %s
1246 Reference '%s' not supported (%s)
1247 Every derived table must have it's own alias
1248 Select %u was reduced during optimisation
1249 Table '%s' from one of SELECT's can not be used in %s
1250 Client does not support authentication protocol requested by server; consider upgrading MySQL client
1251 All parts of a SPATIAL KEY must be NOT NULL
1252 COLLATION '%s' is not valid for CHARACTER SET '%s'
1253 Slave is already running
1254 Slave has already been stopped
1255 Too big size of uncompressed data. The maximum size is %d. (probably, length of uncompressed data was corrupted)
1256 ZLIB: Not enough memory available for zlib
1257 ZLIB: Not enough room in the output buffer for zlib (probably, length of uncompressed data was corrupted)
1258 ZLIB: Input data was corrupted for zlib
1259 %d line(s) was(were) cut by group_concat()
1260 Row %ld doesn't contain data for all columns
1261 Row %ld was truncated; It contained more data than there where input columns
1262 Data truncated, NULL supplied to NOT NULL column '%s' at row %ld
1263 Data truncated, out of range for column '%s' at row %ld
1264 Data truncated for column '%s' at row %ld
1265 Using storage engine %s for table '%s'
1266 Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
1267 Can't drop one or more of the requested users
1268 Can't revoke all privileges, grant for one or more of the requested users
1269 Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'
1270 Illegal mix of collations for operation '%s'
1271 Variable '%s' is not a variable component (Can't be used as XXXX.variable_name)
1272 Unknown collation: '%s'
1273 SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support. They can be used later when MySQL slave with SSL will be started.
1274 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
1275 Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d
1276 Wrong parameter or combination of parameters for START SLAVE UNTIL
1277 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
1278 SQL thread is not to be started so UNTIL options are ignored
1279 Incorrect index name '%s'
1280 Incorrect catalog name '%s'
1281 Query cache failed to set size %lu, new query cache size is %lu
1282 Column '%s' cannot be part of FULLTEXT index
1283 Unknown key cache '%s'
1284 MySQL is started in --skip-name-resolve mode. You need to restart it without this switch for this grant to work
1285 Unknown table engine '%s'
1286 '%s' is deprecated. Use '%s' instead.
1287 The target table %s of the %s is not updatable.
1288 The '%s' feature was disabled. You need MySQL built with '%s' define to have it working
1289 MySQL is started in --skip-grant-tables mode. You can't use this command
1290 Can't create a %s from within another stored routine
1291 %s %s already exists
1292 %s %s does not exist
1293 Failed to DROP %s %s
1294 Failed to CREATE %s %s
1295 %s with no matching label: %s
1296 Redefining label %s
1297 End-label %s without match
1298 Referring to uninitialized variable %s
1299 SELECT in a stored procedure must have INTO
1300 RETURN is only allowed in a FUNCTION
1301 Statements like SELECT, INSERT, UPDATE (and others) are not allowed in a FUNCTION
1302 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been ignored.
1303 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN.
1304 Query execution was interrupted
1305 Wrong number of arguments for %s %s, expected %u, got %u
1306 Undefined CONDITION: %s
1307 No RETURN found in FUNCTION %s
1308 FUNCTION %s ended without RETURN
1309 Cursor statement must be a SELECT
1310 Cursor SELECT must not have INTO
1311 Undefined CURSOR: %s
1312 Cursor is already open
1313 Cursor is not open
1314 Undeclared variable: %s
1315 Wrong number of FETCH variables
1316 No data to FETCH
1317 Duplicate parameter: %s
1318 Duplicate variable: %s
1319 Duplicate condition: %s
1320 Duplicate cursor: %s
1321 Failed to ALTER %s %s
1322 Subselect value not supported

Go to the first, previous, next, last section, table of contents.