Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
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.
1008
HY000
ER_DB_DROP_EXISTS
Can't drop database '%s'; database doesn't exist
1011
HY000
ER_CANT_DELETE_FILE
Error on delete of '%s' (errno: %d)
1002
HY000
ER_NO
NO
1026
HY000
ER_ERROR_ON_WRITE
Error writing file '%s' (errno: %d)
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
1030
HY000
ER_GET_ERRN
Got error %d from storage engine
1042
08S01
ER_BAD_HOST_ERROR
Can't get hostname for your address
1031
HY000
ER_ILLEGAL_HA
Table storage engine for '%s' doesn't have this option
1049
42000
ER_BAD_DB_ERROR
Unknown database '%s'
1043
08S01
ER_HANDSHAKE_ERROR
Bad handshake
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.
1044
42000
ER_DBACCESS_DENIED_ERROR
Access denied for user '%s'@'%s' to database '%s'
1050
42S01
ER_TABLE_EXISTS_ERROR
Table '%s' already exists
1024
HY000
ER_ERROR_ON_READ
Error reading file '%s' (errno: %d)
1005
HY000
ER_CANT_CREATE_TABLE
Can't create table '%s' (errno: %d)
1057
42000
ER_WRONG_SUM_SELECT
Statement has sum functions and columns in same statement
1029
HY000
ER_FORM_NOT_FOUND
View '%s' doesn't exist for '%s'
1039
HY000
ER_UNEXPECTED_EOF
Unexpected EOF found when reading file '%s' (Errno: %d)
1018
HY000
ER_CANT_READ_DIR
Can't read dir of '%s' (errno: %d)
1078
HY000
ER_GOT_SIGNAL
%s: Got signal %d. Aborting!
1096
HY000
ER_NO_TABLES_USED
No tables used
1076
HY000
ER_READY
%s: ready for connections. Version: '%s' socket: '%s' port: %d
1048
23000
ER_BAD_NULL_ERROR
Column '%s' cannot be null
1052
23000
ER_NON_UNIQ_ERROR
Column '%s' in %s is ambiguous
1079
HY000
ER_SHUTDOWN_COMPLETE
%s: Shutdown complete
1055
42000
ER_WRONG_FIELD_WITH_GROUP
'%s' isn't in GROUP BY
1087
HY000
ER_LOAD_INF
Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
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
1036
HY000
ER_OPEN_AS_READONLY
Table '%s' is read only
1054
42S22
ER_BAD_FIELD_ERROR
Unknown column '%s' in '%s'
1095
HY000
ER_KILL_DENIED_ERROR
You are not owner of thread %lu
1081
08S01
ER_IPSOCK_ERROR
Can't create IP socket
1080
08S01
ER_FORCING_CLOSE
%s: Forcing close of thread %ld user: '%s'
1023
HY000
ER_ERROR_ON_CLOSE
Error on close of '%s' (errno: %d)
1016
HY000
ER_CANT_OPEN_FILE
Can't open file: '%s' (errno: %d)
1027
HY000
ER_FILE_USED
'%s' is locked against change
1088
HY000
ER_ALTER_INF
Records: %ld Duplicates: %ld
1069
42000
ER_TOO_MANY_KEYS
Too many keys specified; max %d keys allowed
1090
42000
ER_CANT_REMOVE_ALL_FIELDS
You can't delete all columns with ALTER TABLE; use DROP TABLE instead
1082
42S12
ER_NO_SUCH_INDEX
Table '%s' has no index like the one used in CREATE INDEX; recreate the table
1061
42000
ER_DUP_KEYNAME
Duplicate key name '%s'
1084
42000
ER_BLOBS_AND_NO_TERMINATED
You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
1051
42S02
ER_BAD_TABLE_ERROR
Unknown table '%s'
1073
42000
ER_BLOB_USED_AS_KEY
BLOB column '%s' can't be used in key specification with the used table type
1077
HY000
ER_NORMAL_SHUTDOWN
%s: Normal shutdown
1064
42000
ER_PARSE_ERROR
%s near '%s' at line %d
1071
42000
ER_TOO_LONG_KEY
Specified key was too long; max key length is %d bytes
1091
42000
ER_CANT_DROP_FIELD_OR_KEY
Can't DROP '%s'; check that column/key exists
1056
42000
ER_WRONG_GROUP_FIELD
Can't group on '%s'
1040
08004
ER_CON_COUNT_ERROR
Too many connections
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 for more, as well as for details on setting permissions.
This error occurs when a key that requires a unique value (unique or primary) instead receives a duplicate. For example:
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:
1062
23000
ER_DUP_ENTRY
Duplicate entry '%s' for key %d
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'1010
HY000
ER_DB_DROP_RMDIR
Error dropping database (can't rmdir '%s', errno: %d)
This article doesn't currently contain any content.
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:
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.
1068
42000
ER_MULTIPLE_PRI_KEY
Multiple primary key defined
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)
);CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1, c2)
);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:
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:
1066
42000
ER_NONUNIQ_TABLE
Not unique table/alias: '%s'
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 |
+------+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.
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 column per table, and the column must be defined as a . Not adhering to either of these restrictions will result in this error. For example:
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
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 |
+----+------+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
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
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
1019
HY000
ER_CANT_SET_WD
Can't change dir to '%s' (errno: %d)
This article doesn't currently contain any content.
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.
This page is licensed: CC BY-SA / Gnu FDL
1000
HY000
ER_HASHCHK
hashchk
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
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.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL