Error 1008: Can't drop database; database doesn't exist
Error Code
SQLSTATE
Error
Description
Error 1078: Got signal. Aborting!
Error Code
SQLSTATE
Error
Description
Error 1014: Can't get working directory
Error Code
SQLSTATE
Error
Description
Error 1050: Table already exists
Error Code
SQLSTATE
Error
Description
Error 1026: Error writing file
Error Code
SQLSTATE
Error
Description
Error 1038: Out of sort memory, consider increasing server sort buffer size
Error Code
SQLSTATE
Error
Description
Error 1057: Statement has sum functions and columns in same statement
Error Code
SQLSTATE
Error
Description
Error 1051: Unknown table
Error Code
SQLSTATE
Error
Description
Error 1030: Got error from storage engine
Error Code
SQLSTATE
Error
Description
Error 1015: Can't lock file
Error Code
SQLSTATE
Error
Description
Error 1025: Error on rename of
Error Code
SQLSTATE
Error
Description
Error 1056: Can't group on
Error Code
SQLSTATE
Error
Description
Error 1040: Too many connections
Error Code
SQLSTATE
Error
Description
Error 1047: Unknown command
Error Code
SQLSTATE
Error
Description
Possible Causes and Solutions
1020
HY000
ER_CHECKREAD
Record has changed since last read in table '%s'
Possible Causes and Solutions
1003
HY000
ER_YES
YES
Possible Causes and Solutions
1021
HY000
ER_DISK_FULL
Disk full (%s); waiting for someone to free some space...
Possible Causes and Solutions
1016
HY000
ER_CANT_OPEN_FILE
Can't open file: '%s' (errno: %d)
Possible Causes and Solutions
1005
HY000
ER_CANT_CREATE_TABLE
Can't create table '%s' (errno: %d)
Possible Causes and Solutions
1012
HY000
ER_CANT_FIND_SYSTEM_REC
Can't read record in system table
Possible Causes and Solutions
1022
23000
ER_DUP_KEY
Can't write; duplicate key in table '%s'
Possible Causes and Solutions
1011
HY000
ER_CANT_DELETE_FILE
Error on delete of '%s' (errno: %d)
Possible Causes and Solutions
1007
HY000
ER_DB_CREATE_EXISTS
Can't create database '%s'; database exists
Possible Causes and Solutions
Insufficient Disk Space
The server has insufficient free disk space to create the database. Free up space and retry.
File permissions
There may be a file permission issue on the data directories. Check both the user and group permissions and set accordingly.
1006
HY000
ER_CANT_CREATE_DB
Can't create database '%s' (errno: %d)
Possible Causes and Solutions
1028
HY000
ER_FILSORT_ABORT
Sort aborted
Possible Causes and Solutions
1017
HY000
ER_FILE_NOT_FOUND
Can't find file: '%s' (errno: %d)
Possible Causes and Solutions
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
Possible Causes and Solutions
1027
HY000
ER_FILE_USED
'%s' is locked against change
Possible Causes and Solutions
1043
08S01
ER_HANDSHAKE_ERROR
Bad handshake
Possible Causes and Solutions
1049
42000
ER_BAD_DB_ERROR
Unknown database '%s'
Possible Causes and Solutions
1036
HY000
ER_OPEN_AS_READONLY
Table '%s' is read only
Possible Causes and Solutions
1008
HY000
ER_DB_DROP_EXISTS
Can't drop database '%s'; database doesn't exist
Possible Causes and Solutions
1078
HY000
ER_GOT_SIGNAL
%s: Got signal %d. Aborting!
Possible Causes and Solutions
1014
HY000
ER_CANT_GET_WD
Can't get working directory (errno: %d)
Possible Causes and Solutions
1050
42S01
ER_TABLE_EXISTS_ERROR
Table '%s' already exists
Possible Causes and Solutions
1026
HY000
ER_ERROR_ON_WRITE
Error writing file '%s' (errno: %d)
Possible Causes and Solutions
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
Possible Causes and Solutions
1057
42000
ER_WRONG_SUM_SELECT
Statement has sum functions and columns in same statement
Possible Causes and Solutions
1051
42S02
ER_BAD_TABLE_ERROR
Unknown table '%s'
Possible Causes and Solutions
1030
HY000
ER_GET_ERRN
Got error %d from storage engine
Possible Causes and Solutions
1015
HY000
ER_CANT_LOCK
Can't lock file (errno: %d)
Possible Causes and Solutions
1025
HY000
ER_ERROR_ON_RENAME
Error on rename of '%s' to '%s' (errno: %d)
Possible Causes and Solutions
1056
42000
ER_WRONG_GROUP_FIELD
Can't group on '%s'
Possible Causes and Solutions
1040
08004
ER_CON_COUNT_ERROR
Too many connections
Possible Causes and Solutions
1047
08S01
ER_UNKNOWN_COM_ERROR
Unknown command
Error 1013: Can't get status of
Error Code
SQLSTATE
Error
Description
1013
HY000
ER_CANT_GET_STAT
Can't get status of '%s' (errno: %d)
Possible Causes and Solutions
Error 1029: View doesn't exist for
Error Code
SQLSTATE
Error
Description
1029
HY000
ER_FORM_NOT_FOUND
View '%s' doesn't exist for '%s'
Possible Causes and Solutions
Error 1055: isn't in GROUP BY
Error Code
SQLSTATE
Error
Description
1055
42000
ER_WRONG_FIELD_WITH_GROUP
'%s' isn't in GROUP BY
Possible Causes and Solutions
Error 1037: Out of memory; restart server and try again
Error Code
SQLSTATE
Error
Description
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
Possible Causes and Solutions
Error 1024: Error reading file
Error Code
SQLSTATE
Error
Description
1024
HY000
ER_ERROR_ON_READ
Error reading file '%s' (errno: %d)
Possible Causes and Solutions
Error 1052: Column is ambiguous
Error Code
SQLSTATE
Error
Description
1052
23000
ER_NON_UNIQ_ERROR
Column '%s' in %s is ambiguous
Possible Causes and Solutions
Error 1032: Can't find record in
Error Code
SQLSTATE
Error
Description
1032
HY000
ER_KEY_NOT_FOUND
Can't find record in '%s'
Possible Causes and Solutions
Error 1074: Column length too big for column; use BLOB or TEXT instead
Error Code
SQLSTATE
Error
Description
1074
42000
ER_TOO_BIG_FIELDLENGTH
Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead
Possible Causes and Solutions
Error 1063: Incorrect column specifier for column
Error Code
SQLSTATE
Error
Description
1063
42000
ER_WRONG_FIELD_SPEC
Incorrect column specifier for column '%s'
Possible Causes and Solutions
Error 1023: Error on close of
Error Code
SQLSTATE
Error
Description
1023
HY000
ER_ERROR_ON_CLOSE
Error on close of '%s' (errno: %d)
Possible Causes and Solutions
Error 1093: You can't specify target table for update in FROM clause
Error Code
SQLSTATE
Error
Description
1093
HY000
ER_UPDATE_TABLE_USED
You can't specify target table '%s' for update in FROM clause
Possible Causes and Solutions
Error 1065: Query was empty
Error Code
SQLSTATE
Error
Description
1065
42000
ER_EMPTY_QUERY
Query was empty
Possible Causes and Solutions
Error 1077: Normal shutdown
Error Code
SQLSTATE
Error
Description
1077
HY000
ER_NORMAL_SHUTDOWN
%s: Normal shutdown
Possible Causes and Solutions
Error 1039: Unexpected EOF found when reading file
Error Code
SQLSTATE
Error
Description
1039
HY000
ER_UNEXPECTED_EOF
Unexpected EOF found when reading file '%s' (Errno: %d)
Possible Causes and Solutions
Error 1069: Too many keys specified; max keys allowed
Error Code
SQLSTATE
Error
Description
1069
42000
ER_TOO_MANY_KEYS
Too many keys specified; max %d keys allowed
Possible Causes and Solutions
Error 1053: Server shutdown in progress
Error Code
SQLSTATE
Error
Description
1053
08S01
ER_SERVER_SHUTDOWN
Server shutdown in progress
Possible Causes and Solutions
Error 1086: File already exists
Error Code
SQLSTATE
Error
Description
1086
HY000
ER_FILE_EXISTS_ERROR
File '%s' already exists
Possible Causes and Solutions
Error 1059: Identifier name is too long
Error Code
SQLSTATE
Error
Description
1059
42000
ER_TOO_LONG_IDENT
Identifier name '%s' is too long
Possible Causes and Solutions
Error 1092: Records Duplicates Warnings
Error Code
SQLSTATE
Error
Description
1092
HY000
ER_INSERT_INF
Records: %ld Duplicates: %ld Warnings: %ld
Possible Causes and Solutions
Error 1091: Can't DROP; check that column/key exists
Error Code
SQLSTATE
Error
Description
1091
42000
ER_CANT_DROP_FIELD_OR_KEY
Can't DROP '%s'; check that column/key exists
Possible Causes and Solutions
Error 1096: No tables used
Error Code
SQLSTATE
Error
Description
1096
HY000
ER_NO_TABLES_USED
No tables used
Possible Causes and Solutions
Error 1079: Shutdown complete
Error Code
SQLSTATE
Error
Description
1079
HY000
ER_SHUTDOWN_COMPLETE
%s: Shutdown complete
Possible Causes and Solutions
Error 1076: ready for connections
Error Code
SQLSTATE
Error
Description
1076
HY000
ER_READY
%s: ready for connections. Version: '%s' socket: '%s' port: %d
Possible Causes and Solutions
Error 1095: You are not owner of thread
Error Code
SQLSTATE
Error
Description
1095
HY000
ER_KILL_DENIED_ERROR
You are not owner of thread %lu
Possible Causes and Solutions
Error 1089: Incorrect prefix key; the used key part isn't a string, the used length is longer than t
Error Code
SQLSTATE
Error
Description
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
Possible Causes and Solutions
Error 1058: Column count doesn't match value count
Error Code
SQLSTATE
Error
Description
1058
21S01
ER_WRONG_VALUE_COUNT
Column count doesn't match value count
Possible Causes and Solutions
Error 1060: Duplicate column name
Error Code
SQLSTATE
Error
Description
1060
42S21
ER_DUP_FIELDNAME
Duplicate column name '%s'
Possible Causes and Solutions
Error 1061: Duplicate key name
Error Code
SQLSTATE
Error
Description
1061
42000
ER_DUP_KEYNAME
Duplicate key name '%s'
Possible Causes and Solutions
Error 1071: Specified key was too long; max key length is
Error Code
SQLSTATE
Error
Description
1071
42000
ER_TOO_LONG_KEY
Specified key was too long; max key length is %d bytes
Possible Causes and Solutions
Error 1081: Can't create IP socket
Error Code
SQLSTATE
Error
Description
1081
08S01
ER_IPSOCK_ERROR
Can't create IP socket
Possible Causes and Solutions
Error 1034: Incorrect key file for table; try to repair it
Error Code
SQLSTATE
Error
Description
1034
HY000
ER_NOT_KEYFILE
Incorrect key file for table '%s'; try to repair it
Possible Causes and Solutions
Error 1072: Key column doesn't exist in table
Error Code
SQLSTATE
Error
Description
1072
42000
ER_KEY_COLUMN_DOES_NOT_EXITS
Key column '%s' doesn't exist in table
Possible Causes and Solutions
Error 1090: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Error Code
SQLSTATE
Error
Description
1090
42000
ER_CANT_REMOVE_ALL_FIELDS
You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Possible Causes and Solutions
Error 1088: Records Duplicates
Error Code
SQLSTATE
Error
Description
1088
HY000
ER_ALTER_INF
Records: %ld Duplicates: %ld
Possible Causes and Solutions
Error 1035: Old key file for table; repair it!
Error Code
SQLSTATE
Error
Description
1035
HY000
ER_OLD_KEYFILE
Old key file for table '%s'; repair it!
Possible Causes and Solutions
Error 1033: Incorrect information in file
Error Code
SQLSTATE
Error
Description
1033
HY000
ER_NOT_FORM_FILE
Incorrect information in file: '%s'
Possible Causes and Solutions
Error 1064: near at line
Error Code
SQLSTATE
Error
Description
1064
42000
ER_PARSE_ERROR
%s near '%s' at line %d
Possible Causes and Solutions
Error 1097: Too many strings for column and SET
Error Code
SQLSTATE
Error
Description
1097
HY000
ER_TOO_BIG_SET
Too many strings for column %s and SET
Possible Causes and Solutions
Error 1083: Field separator argument is not what is expected; check the manual
Error Code
SQLSTATE
Error
Description
1083
42000
ER_WRONG_FIELD_TERMINATORS
Field separator argument is not what is expected; check the manual
Possible Causes and Solutions
Error 1045: Access denied for user (using password)
Error Code
SQLSTATE
Error
Description
Error 1048: Column cannot be null
Error Code
SQLSTATE
Error
Description
Error 1054: Unknown column
Error Code
SQLSTATE
Error
Description
Error 1062: Duplicate entry for key
Error Code
SQLSTATE
Error
Description
Error 1080: Forcing close of thread
Error Code
SQLSTATE
Error
Description
Error 1031: Table storage engine doesn't have this option
Error Code
SQLSTATE
Error
Description
Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as
Error Code
SQLSTATE
Error
Description
Error 1066: Not unique table/alias
Error Code
SQLSTATE
Error
Description
Error 1087: Records Deleted Skipped Warnings
Error Code
SQLSTATE
Error
Description
Error 1094: Unknown thread id
Error Code
SQLSTATE
Error
Description
Error 1070: Too many key parts specified; max parts allowed
Error Code
SQLSTATE
Error
Description
Error 1046: No database selected
Error Code
SQLSTATE
Error
Description
Error 1082: Table has no index like the one used in CREATE INDEX; recreate the table
Error Code
SQLSTATE
Error
Description
Error 1085: The file must be in the database directory or be readable by all
Error Code
SQLSTATE
Error
Description
Error 1067: Invalid default value for
Error Code
SQLSTATE
Error
Description
Possible Causes and Solutions
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.
Access denied for user '%s'@'%s' (using password: %s)
This page is licensed: CC BY-SA / Gnu FDL
Possible Causes and Solutions
1048
23000
ER_BAD_NULL_ERROR
Column '%s' cannot be null
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
1054
42S22
ER_BAD_FIELD_ERROR
Unknown column '%s' in '%s'
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
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'
This page is licensed: CC BY-SA / Gnu FDL
Possible Causes and Solutions
1080
08S01
ER_FORCING_CLOSE
%s: Forcing close of thread %ld user: '%s'
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
1031
HY000
ER_ILLEGAL_HA
Table storage engine for '%s' doesn't have this option
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
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:
1075
42000
ER_WRONG_AUTO_KEY
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,
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
Possible Causes and Solutions
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:
This article doesn't currently contain any content.
Possible Causes and Solutions
1094
HY000
ER_NO_SUCH_THREAD
Unknown thread id: %lu
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
1070
42000
ER_TOO_MANY_KEY_PARTS
Too many key parts specified; max %d parts allowed
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
1046
3D000
ER_NO_DB_ERROR
No database selected
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
1082
42S12
ER_NO_SUCH_INDEX
Table '%s' has no index like the one used in CREATE INDEX; recreate the table
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
1085
HY000
ER_TEXTFILE_NOT_READABLE
The file '%s' must be in the database directory or be readable by all
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Possible Causes and Solutions
1067
42000
ER_INVALID_DEFAULT
Invalid default value for '%s'
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
Error 1068: Multiple primary key defined
Error Code
SQLSTATE
Error
Description
1068
42000
ER_MULTIPLE_PRI_KEY
Multiple primary key defined
Possible Causes and Solutions
No more than one 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.
Error 1098: Can't generate a unique log-filename
Error Code
SQLSTATE
Error
Description
1098
HY000
ER_NO_UNIQUE_LOGFILE
Can't generate a unique log-filename %s.(1-999)
Possible Causes and Solutions
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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.
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 |
+------+
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)
);