1000
HY000
ER_HASHCHK
hashchk
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1001
HY000
ER_NISAMCHK
isamchk
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1002
HY000
ER_NO
NO
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1003
HY000
ER_YES
YES
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1004
HY000
ER_CANT_CREATE_FILE
Can't create file '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1005
HY000
ER_CANT_CREATE_TABLE
Can't create table '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1006
HY000
ER_CANT_CREATE_DB
Can't create database '%s' (errno: %d)
The server has insufficient free disk space to create the database. Free up space and retry.
There may be a file permission issue on the data directories. Check both the user and group permissions and set accordingly.
This page is licensed: CC BY-SA / Gnu FDL
1007
HY000
ER_DB_CREATE_EXISTS
Can't create database '%s'; database exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1008
HY000
ER_DB_DROP_EXISTS
Can't drop database '%s'; database doesn't exist
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1009
HY000
ER_DB_DROP_DELETE
Error dropping database (can't delete '%s', errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1010
HY000
ER_DB_DROP_RMDIR
Error dropping database (can't rmdir '%s', errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1011
HY000
ER_CANT_DELETE_FILE
Error on delete of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1012
HY000
ER_CANT_FIND_SYSTEM_REC
Can't read record in system table
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1013
HY000
ER_CANT_GET_STAT
Can't get status of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1014
HY000
ER_CANT_GET_WD
Can't get working directory (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1015
HY000
ER_CANT_LOCK
Can't lock file (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1016
HY000
ER_CANT_OPEN_FILE
Can't open file: '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1017
HY000
ER_FILE_NOT_FOUND
Can't find file: '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1018
HY000
ER_CANT_READ_DIR
Can't read dir of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1019
HY000
ER_CANT_SET_WD
Can't change dir to '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1020
HY000
ER_CHECKREAD
Record has changed since last read in table '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1021
HY000
ER_DISK_FULL
Disk full (%s); waiting for someone to free some space...
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1022
23000
ER_DUP_KEY
Can't write; duplicate key in table '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1023
HY000
ER_ERROR_ON_CLOSE
Error on close of '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1024
HY000
ER_ERROR_ON_READ
Error reading file '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1025
HY000
ER_ERROR_ON_RENAME
Error on rename of '%s' to '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1026
HY000
ER_ERROR_ON_WRITE
Error writing file '%s' (errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1027
HY000
ER_FILE_USED
'%s' is locked against change
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1028
HY000
ER_FILSORT_ABORT
Sort aborted
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1029
HY000
ER_FORM_NOT_FOUND
View '%s' doesn't exist for '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1030
HY000
ER_GET_ERRN
Got error %d from storage engine
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1031
HY000
ER_ILLEGAL_HA
Table storage engine for '%s' doesn't have this option
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1032
HY000
ER_KEY_NOT_FOUND
Can't find record in '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1033
HY000
ER_NOT_FORM_FILE
Incorrect information in file: '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1034
HY000
ER_NOT_KEYFILE
Incorrect key file for table '%s'; try to repair it
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1035
HY000
ER_OLD_KEYFILE
Old key file for table '%s'; repair it!
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1036
HY000
ER_OPEN_AS_READONLY
Table '%s' is read only
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1039
HY000
ER_UNEXPECTED_EOF
Unexpected EOF found when reading file '%s' (Errno: %d)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1040
08004
ER_CON_COUNT_ERROR
Too many connections
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1041
HY000
ER_OUT_OF_RESOURCES
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
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1042
08S01
ER_BAD_HOST_ERROR
Can't get hostname for your address
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1043
08S01
ER_HANDSHAKE_ERROR
Bad handshake
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1044
42000
ER_DBACCESS_DENIED_ERROR
Access denied for user '%s'@'%s' to database '%s'
The user is trying to access a database/schema they do not have access to. See Troubleshooting Connection Issues for more, as well as GRANT for details on setting permissions.
This page is licensed: CC BY-SA / Gnu FDL
1045
28000
ER_ACCESS_DENIED_ERROR
Access denied for user '%s'@'%s' (using password: %s)
The user/password combination does not exist or the user does not have privileges to the given database. See Troubleshooting Connection Issues for more, as well as GRANT for details on setting permissions.
This page is licensed: CC BY-SA / Gnu FDL
1046
3D000
ER_NO_DB_ERROR
No database selected
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1047
08S01
ER_UNKNOWN_COM_ERROR
Unknown command
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1048
23000
ER_BAD_NULL_ERROR
Column '%s' cannot be null
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1049
42000
ER_BAD_DB_ERROR
Unknown database '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1050
42S01
ER_TABLE_EXISTS_ERROR
Table '%s' already exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1051
42S02
ER_BAD_TABLE_ERROR
Unknown table '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1052
23000
ER_NON_UNIQ_ERROR
Column '%s' in %s is ambiguous
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1053
08S01
ER_SERVER_SHUTDOWN
Server shutdown in progress
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1054
42S22
ER_BAD_FIELD_ERROR
Unknown column '%s' in '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1055
42000
ER_WRONG_FIELD_WITH_GROUP
'%s' isn't in GROUP BY
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1056
42000
ER_WRONG_GROUP_FIELD
Can't group on '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1057
42000
ER_WRONG_SUM_SELECT
Statement has sum functions and columns in same statement
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1058
21S01
ER_WRONG_VALUE_COUNT
Column count doesn't match value count
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1059
42000
ER_TOO_LONG_IDENT
Identifier name '%s' is too long
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1060
42S21
ER_DUP_FIELDNAME
Duplicate column name '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1061
42000
ER_DUP_KEYNAME
Duplicate key name '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1062
23000
ER_DUP_ENTRY
Duplicate entry '%s' for key %d
This error occurs when a key that requires a unique value (unique or primary) instead receives a duplicate. For example:
CREATE TABLE t1 (
id INT AUTO_INCREMENT PRIMARY KEY,
f VARCHAR(10) UNIQUE
);
INSERT INTO t1 (f) VALUES ('a'),('b');
SELECT * FROM t1;
+----+------+
| id | f |
+----+------+
| 1 | a |
| 2 | b |
+----+------+
INSERT INTO t1 (f) VALUES ('b'),('c');
ERROR 1062 (23000): Duplicate entry 'b' for key 'f'Solve the error by either not attempting to insert a duplicate value, or not requiring the key to be unique. For example, the below replaces the unique index with an index permitting duplicates:
ALTER TABLE t1 DROP INDEX f, ADD INDEX (f);
INSERT INTO t1 (f) VALUES ('b'),('c');
SELECT * FROM t1;
+----+------+
| id | f |
+----+------+
| 1 | a |
| 2 | b |
| 3 | b |
| 4 | c |
+----+------+This page is licensed: CC BY-SA / Gnu FDL
1063
42000
ER_WRONG_FIELD_SPEC
Incorrect column specifier for column '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1064
42000
ER_PARSE_ERROR
%s near '%s' at line %d
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1065
42000
ER_EMPTY_QUERY
Query was empty
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1066
42000
ER_NONUNIQ_TABLE
Not unique table/alias: '%s'
In order to avoid ambiguity, a table name or alias must uniquely identify an object. There are many situations where this could occur.
For example, HANDLER statements use unqualified table names, requiring the use of an alias in certain contexts. For example:
CREATE TABLE t1 (f1 INT);
INSERT INTO t1 VALUES (1),(2),(3);
HANDLER t1 OPEN;
HANDLER t1 READ NEXT;
+------+
| f1 |
+------+
| 1 |
+------+
HANDLER t1 READ NEXT;
+------+
| f1 |
+------+
| 2 |
+------+In the previous example, the HANDLER was opened with the t1 table name. Since HANDLERs use unqualified table names, trying to access another table with this same name, even though it's in another database, will result in ambiguity. An alias needs to be used to avoid the ambiguity:
CREATE DATABASE db_new;
CREATE TABLE db_new.t1 (id INT);
INSERT INTO db_new.t1 VALUES (4),(5),(6);
HANDLER db_new.t1 OPEN;
ERROR 1066 (42000): Not unique table/alias: 't1'
HANDLER db_new.t1 OPEN AS db_new_t1;
HANDLER db_new_t1 READ NEXT LIMIT 3;
+------+
| id |
+------+
| 4 |
| 5 |
| 6 |
+------+This page is licensed: CC BY-SA / Gnu FDL
1067
42000
ER_INVALID_DEFAULT
Invalid default value for '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1068
42000
ER_MULTIPLE_PRI_KEY
Multiple primary key defined
No more than one primary key can be defined per table. Attempting to define more in a single table will result in this error. For example:
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1),
PRIMARY KEY(c2)
);
ERROR 1068 (42000): Multiple primary key defined
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1)
);It's also possible that this error results from a mistaken attempt to define a multi-part primary key. This is an example of the correct definition for such a key.
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1, c2)
);This page is licensed: CC BY-SA / Gnu FDL
1069
42000
ER_TOO_MANY_KEYS
Too many keys specified; max %d keys allowed
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1070
42000
ER_TOO_MANY_KEY_PARTS
Too many key parts specified; max %d parts allowed
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1071
42000
ER_TOO_LONG_KEY
Specified key was too long; max key length is %d bytes
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1072
42000
ER_KEY_COLUMN_DOES_NOT_EXITS
Key column '%s' doesn't exist in table
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1073
42000
ER_BLOB_USED_AS_KEY
BLOB column '%s' can't be used in key specification with the used table type
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1074
42000
ER_TOO_BIG_FIELDLENGTH
Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1075
42000
ER_WRONG_AUTO_KEY
Incorrect table definition; there can be only one auto column and it must be defined as a key
There can only be one AUTO_INCREMENT column per table, and the column must be defined as a key. Not adhering to either of these restrictions will result in this error. For example:
CREATE OR REPLACE TABLE animals (
id1 MEDIUMINT NOT NULL AUTO_INCREMENT,
id2 TINYINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id1),
KEY (id2)
);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE OR REPLACE TABLE animals (
id1 MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL
);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE OR REPLACE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
Query OK, 0 rows affected (0.017 sec)This page is licensed: CC BY-SA / Gnu FDL
1076
HY000
ER_READY
%s: ready for connections. Version: '%s' socket: '%s' port: %d
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1077
HY000
ER_NORMAL_SHUTDOWN
%s: Normal shutdown
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1078
HY000
ER_GOT_SIGNAL
%s: Got signal %d. Aborting!
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1079
HY000
ER_SHUTDOWN_COMPLETE
%s: Shutdown complete
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1080
08S01
ER_FORCING_CLOSE
%s: Forcing close of thread %ld user: '%s'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1081
08S01
ER_IPSOCK_ERROR
Can't create IP socket
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1082
42S12
ER_NO_SUCH_INDEX
Table '%s' has no index like the one used in CREATE INDEX; recreate the table
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1083
42000
ER_WRONG_FIELD_TERMINATORS
Field separator argument is not what is expected; check the manual
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1084
42000
ER_BLOBS_AND_NO_TERMINATED
You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1085
HY000
ER_TEXTFILE_NOT_READABLE
The file '%s' must be in the database directory or be readable by all
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1086
HY000
ER_FILE_EXISTS_ERROR
File '%s' already exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1087
HY000
ER_LOAD_INF
Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1088
HY000
ER_ALTER_INF
Records: %ld Duplicates: %ld
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1089
HY000
ER_WRONG_SUB_KEY
Incorrect prefix 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 prefix keys
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1090
42000
ER_CANT_REMOVE_ALL_FIELDS
You can't delete all columns with ALTER TABLE; use DROP TABLE instead
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1091
42000
ER_CANT_DROP_FIELD_OR_KEY
Can't DROP '%s'; check that column/key exists
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1092
HY000
ER_INSERT_INF
Records: %ld Duplicates: %ld Warnings: %ld
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1093
HY000
ER_UPDATE_TABLE_USED
You can't specify target table '%s' for update in FROM clause
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1094
HY000
ER_NO_SUCH_THREAD
Unknown thread id: %lu
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1095
HY000
ER_KILL_DENIED_ERROR
You are not owner of thread %lu
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1096
HY000
ER_NO_TABLES_USED
No tables used
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1097
HY000
ER_TOO_BIG_SET
Too many strings for column %s and SET
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
1098
HY000
ER_NO_UNIQUE_LOGFILE
Can't generate a unique log-filename %s.(1-999)
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL