B.3.1 Server Error Message Reference

The MySQL server writes some error messages to its error log, and sends others to client programs.

Example server-side error messages written to the error log:

2018-09-26T14:46:06.326016Z 0 [Note] Skipping generation of SSL
certificates as options related to SSL are specified.

2018-10-02T03:20:39.410387Z 0 [ERROR] Plugin 'InnoDB'
registration as a STORAGE ENGINE failed.

Example server-side error message sent to client programs, as displayed by the mysql client:

mysql> SELECT * FROM no_such_table;
ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist

Each server error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and Components”. These components are available as described in Section B.2, “Error Information Interfaces”.

In addition to the errors in the following list, the server can also produce error messages that have error codes in the range from 1 to 999. See Section B.3.3, “Global Error Message Reference”

  • Error number: 1000; Symbol: ER_HASHCHK; SQLSTATE: HY000

    Message: hashchk

    Unused.

  • Error number: 1001; Symbol: ER_NISAMCHK; SQLSTATE: HY000

    Message: isamchk

    Unused.

  • Error number: 1002; Symbol: ER_NO; SQLSTATE: HY000

    Message: NO

    Used in the construction of other messages.

  • Error number: 1003; Symbol: ER_YES; SQLSTATE: HY000

    Message: YES

    Used in the construction of other messages.

    Extended EXPLAIN format generates Note messages. ER_YES is used in the Code column for these messages in subsequent SHOW WARNINGS output.

  • Error number: 1004; Symbol: ER_CANT_CREATE_FILE; SQLSTATE: HY000

    Message: Can't create file '%s' (errno: %d - %s)

    Occurs for failure to create or copy a file needed for some operation.

    Possible causes: Permissions problem for source file; destination file already exists but is not writeable.

  • Error number: 1005; Symbol: ER_CANT_CREATE_TABLE; SQLSTATE: HY000

    Message: Can't create table '%s' (errno: %d)

    InnoDB reports this error when a table cannot be created. If the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. If the error message refers to error -1, table creation probably failed because the table includes a column name that matched the name of an internal InnoDB table.

  • Error number: 1006; Symbol: ER_CANT_CREATE_DB; SQLSTATE: HY000

    Message: Can't create database '%s' (errno: %d)

  • Error number: 1007; Symbol: ER_DB_CREATE_EXISTS; SQLSTATE: HY000

    Message: Can't create database '%s'; database exists

    An attempt to create a database failed because the database already exists.

    Drop the database first if you really want to replace an existing database, or add an IF NOT EXISTS clause to the CREATE DATABASE statement if to retain an existing database without having the statement produce an error.

  • Error number: 1008; Symbol: ER_DB_DROP_EXISTS; SQLSTATE: HY000

    Message: Can't drop database '%s'; database doesn't exist

  • Error number: 1009; Symbol: ER_DB_DROP_DELETE; SQLSTATE: HY000

    Message: Error dropping database (can't delete '%s', errno: %d)

  • Error number: 1010; Symbol: ER_DB_DROP_RMDIR; SQLSTATE: HY000

    Message: Error dropping database (can't rmdir '%s', errno: %d)

  • Error number: 1011; Symbol: ER_CANT_DELETE_FILE; SQLSTATE: HY000

    Message: Error on delete of '%s' (errno: %d - %s)

  • Error number: 1012; Symbol: ER_CANT_FIND_SYSTEM_REC; SQLSTATE: HY000

    Message: Can't read record in system table

    Returned by InnoDB for attempts to access InnoDB INFORMATION_SCHEMA tables when InnoDB is unavailable.

  • Error number: 1013; Symbol: ER_CANT_GET_STAT; SQLSTATE: HY000

    Message: Can't get status of '%s' (errno: %d - %s)

  • Error number: 1014; Symbol: ER_CANT_GET_WD; SQLSTATE: HY000

    Message: Can't get working directory (errno: %d - %s)

  • Error number: 1015; Symbol: ER_CANT_LOCK; SQLSTATE: HY000

    Message: Can't lock file (errno: %d - %s)

  • Error number: 1016; Symbol: ER_CANT_OPEN_FILE; SQLSTATE: HY000

    Message: Can't open file: '%s' (errno: %d - %s)

    InnoDB reports this error when the table from the InnoDB data files cannot be found, even though the .frm file for the table exists. See Section 14.22.3, “Troubleshooting InnoDB Data Dictionary Operations”.

  • Error number: 1017; Symbol: ER_FILE_NOT_FOUND; SQLSTATE: HY000

    Message: Can't find file: '%s' (errno: %d - %s)

  • Error number: 1018; Symbol: ER_CANT_READ_DIR; SQLSTATE: HY000

    Message: Can't read dir of '%s' (errno: %d - %s)

  • Error number: 1019; Symbol: ER_CANT_SET_WD; SQLSTATE: HY000

    Message: Can't change dir to '%s' (errno: %d - %s)

  • Error number: 1020; Symbol: ER_CHECKREAD; SQLSTATE: HY000

    Message: Record has changed since last read in table '%s'

  • Error number: 1021; Symbol: ER_DISK_FULL; SQLSTATE: HY000

    Message: Disk full (%s); waiting for someone to free some space... (errno: %d - %s)

  • Error number: 1022; Symbol: ER_DUP_KEY; SQLSTATE: 23000

    Message: Can't write; duplicate key in table '%s'

  • Error number: 1023; Symbol: ER_ERROR_ON_CLOSE; SQLSTATE: HY000

    Message: Error on close of '%s' (errno: %d - %s)

  • Error number: 1024; Symbol: ER_ERROR_ON_READ; SQLSTATE: HY000

    Message: Error reading file '%s' (errno: %d - %s)

  • Error number: 1025; Symbol: ER_ERROR_ON_RENAME; SQLSTATE: HY000

    Message: Error on rename of '%s' to '%s' (errno: %d - %s)

  • Error number: 1026; Symbol: ER_ERROR_ON_WRITE; SQLSTATE: HY000

    Message: Error writing file '%s' (errno: %d - %s)

  • Error number: 1027; Symbol: ER_FILE_USED; SQLSTATE: HY000

    Message: '%s' is locked against change

  • Error number: 1028; Symbol: ER_FILSORT_ABORT; SQLSTATE: HY000

    Message: Sort aborted

  • Error number: 1029; Symbol: ER_FORM_NOT_FOUND; SQLSTATE: HY000

    Message: View '%s' doesn't exist for '%s'

  • Error number: 1030; Symbol: ER_GET_ERRNO; SQLSTATE: HY000

    Message: Got error %d from storage engine

    Check the %d value to see what the OS error means. For example, 28 indicates that you have run out of disk space.

  • Error number: 1031; Symbol: ER_ILLEGAL_HA; SQLSTATE: HY000

    Message: Table storage engine for '%s' doesn't have this option

  • Error number: 1032; Symbol: ER_KEY_NOT_FOUND; SQLSTATE: HY000

    Message: Can't find record in '%s'

  • Error number: 1033; Symbol: ER_NOT_FORM_FILE; SQLSTATE: HY000

    Message: Incorrect information in file: '%s'

  • Error number: 1034; Symbol: ER_NOT_KEYFILE; SQLSTATE: HY000

    Message: Incorrect key file for table '%s'; try to repair it

  • Error number: 1035; Symbol: ER_OLD_KEYFILE; SQLSTATE: HY000

    Message: Old key file for table '%s'; repair it!

  • Error number: 1036; Symbol: ER_OPEN_AS_READONLY; SQLSTATE: HY000

    Message: Table '%s' is read only

  • Error number: 1037; Symbol: ER_OUTOFMEMORY; SQLSTATE: HY001

    Message: Out of memory; restart server and try again (needed %d bytes)

  • Error number: 1038; Symbol: ER_OUT_OF_SORTMEMORY; SQLSTATE: HY001

    Message: Out of sort memory, consider increasing server sort buffer size

  • Error number: 1039; Symbol: ER_UNEXPECTED_EOF; SQLSTATE: HY000

    Message: Unexpected EOF found when reading file '%s' (errno: %d - %s)

  • Error number: 1040; Symbol: ER_CON_COUNT_ERROR; SQLSTATE: 08004

    Message: Too many connections

  • Error number: 1041; Symbol: ER_OUT_OF_RESOURCES; SQLSTATE: HY000

    Message: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space

  • Error number: 1042; Symbol: ER_BAD_HOST_ERROR; SQLSTATE: 08S01

    Message: Can't get hostname for your address

  • Error number: 1043; Symbol: ER_HANDSHAKE_ERROR; SQLSTATE: 08S01

    Message: Bad handshake

  • Error number: 1044; Symbol: ER_DBACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: Access denied for user '%s'@'%s' to database '%s'

  • Error number: 1045; Symbol: ER_ACCESS_DENIED_ERROR; SQLSTATE: 28000

    Message: Access denied for user '%s'@'%s' (using password: %s)

  • Error number: 1046; Symbol: ER_NO_DB_ERROR; SQLSTATE: 3D000

    Message: No database selected

  • Error number: 1047; Symbol: ER_UNKNOWN_COM_ERROR; SQLSTATE: 08S01

    Message: Unknown command

  • Error number: 1048; Symbol: ER_BAD_NULL_ERROR; SQLSTATE: 23000

    Message: Column '%s' cannot be null

  • Error number: 1049; Symbol: ER_BAD_DB_ERROR; SQLSTATE: 42000

    Message: Unknown database '%s'

  • Error number: 1050; Symbol: ER_TABLE_EXISTS_ERROR; SQLSTATE: 42S01

    Message: Table '%s' already exists

  • Error number: 1051; Symbol: ER_BAD_TABLE_ERROR; SQLSTATE: 42S02

    Message: Unknown table '%s'

  • Error number: 1052; Symbol: ER_NON_UNIQ_ERROR; SQLSTATE: 23000

    Message: Column '%s' in %s is ambiguous

    %s = column name
    %s = location of column (for example, "field list")

    Likely cause: A column appears in a query without appropriate qualification, such as in a select list or ON clause.

    Examples:

    mysql> SELECT i FROM t INNER JOIN t AS t2;
    ERROR 1052 (23000): Column 'i' in field list is ambiguous
    
    mysql> SELECT * FROM t LEFT JOIN t AS t2 ON i = i;
    ERROR 1052 (23000): Column 'i' in on clause is ambiguous

    Resolution:

    • Qualify the column with the appropriate table name:

      mysql> SELECT t2.i FROM t INNER JOIN t AS t2;
    • Modify the query to avoid the need for qualification:

      mysql> SELECT * FROM t LEFT JOIN t AS t2 USING (i);
  • Error number: 1053; Symbol: ER_SERVER_SHUTDOWN; SQLSTATE: 08S01

    Message: Server shutdown in progress

  • Error number: 1054; Symbol: ER_BAD_FIELD_ERROR; SQLSTATE: 42S22

    Message: Unknown column '%s' in '%s'

  • Error number: 1055; Symbol: ER_WRONG_FIELD_WITH_GROUP; SQLSTATE: 42000

    Message: '%s' isn't in GROUP BY

  • Error number: 1056; Symbol: ER_WRONG_GROUP_FIELD; SQLSTATE: 42000

    Message: Can't group on '%s'

  • Error number: 1057; Symbol: ER_WRONG_SUM_SELECT; SQLSTATE: 42000

    Message: Statement has sum functions and columns in same statement

  • Error number: 1058; Symbol: ER_WRONG_VALUE_COUNT; SQLSTATE: 21S01

    Message: Column count doesn't match value count

  • Error number: 1059; Symbol: ER_TOO_LONG_IDENT; SQLSTATE: 42000

    Message: Identifier name '%s' is too long

  • Error number: 1060; Symbol: ER_DUP_FIELDNAME; SQLSTATE: 42S21

    Message: Duplicate column name '%s'

  • Error number: 1061; Symbol: ER_DUP_KEYNAME; SQLSTATE: 42000

    Message: Duplicate key name '%s'

  • Error number: 1062; Symbol: ER_DUP_ENTRY; SQLSTATE: 23000

    Message: Duplicate entry '%s' for key %d

    The message returned with this error uses the format string for ER_DUP_ENTRY_WITH_KEY_NAME.

  • Error number: 1063; Symbol: ER_WRONG_FIELD_SPEC; SQLSTATE: 42000

    Message: Incorrect column specifier for column '%s'

  • Error number: 1064; Symbol: ER_PARSE_ERROR; SQLSTATE: 42000

    Message: %s near '%s' at line %d

  • Error number: 1065; Symbol: ER_EMPTY_QUERY; SQLSTATE: 42000

    Message: Query was empty

  • Error number: 1066; Symbol: ER_NONUNIQ_TABLE; SQLSTATE: 42000

    Message: Not unique table/alias: '%s'

  • Error number: 1067; Symbol: ER_INVALID_DEFAULT; SQLSTATE: 42000

    Message: Invalid default value for '%s'

  • Error number: 1068; Symbol: ER_MULTIPLE_PRI_KEY; SQLSTATE: 42000

    Message: Multiple primary key defined

  • Error number: 1069; Symbol: ER_TOO_MANY_KEYS; SQLSTATE: 42000

    Message: Too many keys specified; max %d keys allowed

  • Error number: 1070; Symbol: ER_TOO_MANY_KEY_PARTS; SQLSTATE: 42000

    Message: Too many key parts specified; max %d parts allowed

  • Error number: 1071; Symbol: ER_TOO_LONG_KEY; SQLSTATE: 42000

    Message: Specified key was too long; max key length is %d bytes

  • Error number: 1072; Symbol: ER_KEY_COLUMN_DOES_NOT_EXITS; SQLSTATE: 42000

    Message: Key column '%s' doesn't exist in table

  • Error number: 1073; Symbol: ER_BLOB_USED_AS_KEY; SQLSTATE: 42000

    Message: BLOB column '%s' can't be used in key specification with the used table type

  • Error number: 1074; Symbol: ER_TOO_BIG_FIELDLENGTH; SQLSTATE: 42000

    Message: Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead

  • Error number: 1075; Symbol: ER_WRONG_AUTO_KEY; SQLSTATE: 42000

    Message: Incorrect table definition; there can be only one auto column and it must be defined as a key

  • Error number: 1076; Symbol: ER_READY; SQLSTATE: HY000

    Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d

  • Error number: 1077; Symbol: ER_NORMAL_SHUTDOWN; SQLSTATE: HY000

    Message: %s: Normal shutdown

  • Error number: 1078; Symbol: ER_GOT_SIGNAL; SQLSTATE: HY000

    Message: %s: Got signal %d. Aborting!

  • Error number: 1079; Symbol: ER_SHUTDOWN_COMPLETE; SQLSTATE: HY000

    Message: %s: Shutdown complete

  • Error number: 1080; Symbol: ER_FORCING_CLOSE; SQLSTATE: 08S01

    Message: %s: Forcing close of thread %ld user: '%s'

  • Error number: 1081; Symbol: ER_IPSOCK_ERROR; SQLSTATE: 08S01

    Message: Can't create IP socket

  • Error number: 1082; Symbol: ER_NO_SUCH_INDEX; SQLSTATE: 42S12

    Message: Table '%s' has no index like the one used in CREATE INDEX; recreate the table

  • Error number: 1083; Symbol: ER_WRONG_FIELD_TERMINATORS; SQLSTATE: 42000

    Message: Field separator argument is not what is expected; check the manual

  • Error number: 1084; Symbol: ER_BLOBS_AND_NO_TERMINATED; SQLSTATE: 42000

    Message: You can't use fixed rowlength with BLOBs; please use 'fields terminated by'

  • Error number: 1085; Symbol: ER_TEXTFILE_NOT_READABLE; SQLSTATE: HY000

    Message: The file '%s' must be in the database directory or be readable by all

  • Error number: 1086; Symbol: ER_FILE_EXISTS_ERROR; SQLSTATE: HY000

    Message: File '%s' already exists

  • Error number: 1087; Symbol: ER_LOAD_INFO; SQLSTATE: HY000

    Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld

  • Error number: 1088; Symbol: ER_ALTER_INFO; SQLSTATE: HY000

    Message: Records: %ld Duplicates: %ld

  • Error number: 1089; Symbol: ER_WRONG_SUB_KEY; SQLSTATE: HY000

    Message: 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

  • Error number: 1090; Symbol: ER_CANT_REMOVE_ALL_FIELDS; SQLSTATE: 42000

    Message: You can't delete all columns with ALTER TABLE; use DROP TABLE instead

  • Error number: 1091; Symbol: ER_CANT_DROP_FIELD_OR_KEY; SQLSTATE: 42000

    Message: Can't DROP '%s'; check that column/key exists

  • Error number: 1092; Symbol: ER_INSERT_INFO; SQLSTATE: HY000

    Message: Records: %ld Duplicates: %ld Warnings: %ld

  • Error number: 1093; Symbol: ER_UPDATE_TABLE_USED; SQLSTATE: HY000

    Message: You can't specify target table '%s' for update in FROM clause

    This error occurs for attempts to select from and modify the same table within a single statement. If the select attempt occurs within a derived table, you can avoid this error by setting the derived_merge flag of the optimizer_switch system variable to force the subquery to be materialized into a temporary table, which effectively causes it to be a different table from the one modified. See Section 8.2.2.4, “Optimizing Derived Tables and View References with Merging or Materialization”.

  • Error number: 1094; Symbol: ER_NO_SUCH_THREAD; SQLSTATE: HY000

    Message: Unknown thread id: %lu

  • Error number: 1095; Symbol: ER_KILL_DENIED_ERROR; SQLSTATE: HY000

    Message: You are not owner of thread %lu

  • Error number: 1096; Symbol: ER_NO_TABLES_USED; SQLSTATE: HY000

    Message: No tables used

  • Error number: 1097; Symbol: ER_TOO_BIG_SET; SQLSTATE: HY000

    Message: Too many strings for column %s and SET

  • Error number: 1098; Symbol: ER_NO_UNIQUE_LOGFILE; SQLSTATE: HY000

    Message: Can't generate a unique log-filename %s.(1-999)

  • Error number: 1099; Symbol: ER_TABLE_NOT_LOCKED_FOR_WRITE; SQLSTATE: HY000

    Message: Table '%s' was locked with a READ lock and can't be updated

  • Error number: 1100; Symbol: ER_TABLE_NOT_LOCKED; SQLSTATE: HY000

    Message: Table '%s' was not locked with LOCK TABLES

  • Error number: 1101; Symbol: ER_BLOB_CANT_HAVE_DEFAULT; SQLSTATE: 42000

    Message: BLOB, TEXT, GEOMETRY or JSON column '%s' can't have a default value

  • Error number: 1102; Symbol: ER_WRONG_DB_NAME; SQLSTATE: 42000

    Message: Incorrect database name '%s'

  • Error number: 1103; Symbol: ER_WRONG_TABLE_NAME; SQLSTATE: 42000

    Message: Incorrect table name '%s'

  • Error number: 1104; Symbol: ER_TOO_BIG_SELECT; SQLSTATE: 42000

    Message: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

  • Error number: 1105; Symbol: ER_UNKNOWN_ERROR; SQLSTATE: HY000

    Message: Unknown error

  • Error number: 1106; Symbol: ER_UNKNOWN_PROCEDURE; SQLSTATE: 42000

    Message: Unknown procedure '%s'

  • Error number: 1107; Symbol: ER_WRONG_PARAMCOUNT_TO_PROCEDURE; SQLSTATE: 42000

    Message: Incorrect parameter count to procedure '%s'

  • Error number: 1108; Symbol: ER_WRONG_PARAMETERS_TO_PROCEDURE; SQLSTATE: HY000

    Message: Incorrect parameters to procedure '%s'

  • Error number: 1109; Symbol: ER_UNKNOWN_TABLE; SQLSTATE: 42S02

    Message: Unknown table '%s' in %s

  • Error number: 1110; Symbol: ER_FIELD_SPECIFIED_TWICE; SQLSTATE: 42000

    Message: Column '%s' specified twice

  • Error number: 1111; Symbol: ER_INVALID_GROUP_FUNC_USE; SQLSTATE: HY000

    Message: Invalid use of group function

  • Error number: 1112; Symbol: ER_UNSUPPORTED_EXTENSION; SQLSTATE: 42000

    Message: Table '%s' uses an extension that doesn't exist in this MySQL version

  • Error number: 1113; Symbol: ER_TABLE_MUST_HAVE_COLUMNS; SQLSTATE: 42000

    Message: A table must have at least 1 column

  • Error number: 1114; Symbol: ER_RECORD_FILE_FULL; SQLSTATE: HY000

    Message: The table '%s' is full

    InnoDB reports this error when the system tablespace runs out of free space. Reconfigure the system tablespace to add a new data file.

  • Error number: 1115; Symbol: ER_UNKNOWN_CHARACTER_SET; SQLSTATE: 42000

    Message: Unknown character set: '%s'

  • Error number: 1116; Symbol: ER_TOO_MANY_TABLES; SQLSTATE: HY000

    Message: Too many tables; MySQL can only use %d tables in a join

  • Error number: 1117; Symbol: ER_TOO_MANY_FIELDS; SQLSTATE: HY000

    Message: Too many columns

  • Error number: 1118; Symbol: ER_TOO_BIG_ROWSIZE; SQLSTATE: 42000

    Message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

  • Error number: 1119; Symbol: ER_STACK_OVERRUN; SQLSTATE: HY000

    Message: Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed

  • Error number: 1120; Symbol: ER_WRONG_OUTER_JOIN; SQLSTATE: 42000

    Message: Cross dependency found in OUTER JOIN; examine your ON conditions

  • Error number: 1121; Symbol: ER_NULL_COLUMN_IN_INDEX; SQLSTATE: 42000

    Message: Table handler doesn't support NULL in given index. Please change column '%s' to be NOT NULL or use another handler

  • Error number: 1122; Symbol: ER_CANT_FIND_UDF; SQLSTATE: HY000

    Message: Can't load function '%s'

  • Error number: 1123; Symbol: ER_CANT_INITIALIZE_UDF; SQLSTATE: HY000

    Message: Can't initialize function '%s'; %s

  • Error number: 1124; Symbol: ER_UDF_NO_PATHS; SQLSTATE: HY000

    Message: No paths allowed for shared library

  • Error number: 1125; Symbol: ER_UDF_EXISTS; SQLSTATE: HY000

    Message: Function '%s' already exists

  • Error number: 1126; Symbol: ER_CANT_OPEN_LIBRARY; SQLSTATE: HY000

    Message: Can't open shared library '%s' (errno: %d %s)

  • Error number: 1127; Symbol: ER_CANT_FIND_DL_ENTRY; SQLSTATE: HY000

    Message: Can't find symbol '%s' in library

  • Error number: 1128; Symbol: ER_FUNCTION_NOT_DEFINED; SQLSTATE: HY000

    Message: Function '%s' is not defined

  • Error number: 1129; Symbol: ER_HOST_IS_BLOCKED; SQLSTATE: HY000

    Message: Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

  • Error number: 1130; Symbol: ER_HOST_NOT_PRIVILEGED; SQLSTATE: HY000

    Message: Host '%s' is not allowed to connect to this MySQL server

  • Error number: 1131; Symbol: ER_PASSWORD_ANONYMOUS_USER; SQLSTATE: 42000

    Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords

  • Error number: 1132; Symbol: ER_PASSWORD_NOT_ALLOWED; SQLSTATE: 42000

    Message: You must have privileges to update tables in the mysql database to be able to change passwords for others

  • Error number: 1133; Symbol: ER_PASSWORD_NO_MATCH; SQLSTATE: 42000

    Message: Can't find any matching row in the user table

  • Error number: 1134; Symbol: ER_UPDATE_INFO; SQLSTATE: HY000

    Message: Rows matched: %ld Changed: %ld Warnings: %ld

  • Error number: 1135; Symbol: ER_CANT_CREATE_THREAD; SQLSTATE: HY000

    Message: Can't create a new thread (errno %d); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

  • Error number: 1136; Symbol: ER_WRONG_VALUE_COUNT_ON_ROW; SQLSTATE: 21S01

    Message: Column count doesn't match value count at row %ld

  • Error number: 1137; Symbol: ER_CANT_REOPEN_TABLE; SQLSTATE: HY000

    Message: Can't reopen table: '%s'

  • Error number: 1138; Symbol: ER_INVALID_USE_OF_NULL; SQLSTATE: 22004

    Message: Invalid use of NULL value

  • Error number: 1139; Symbol: ER_REGEXP_ERROR; SQLSTATE: 42000

    Message: Got error '%s' from regexp

  • Error number: 1140; Symbol: ER_MIX_OF_GROUP_FUNC_AND_FIELDS; SQLSTATE: 42000

    Message: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

  • Error number: 1141; Symbol: ER_NONEXISTING_GRANT; SQLSTATE: 42000

    Message: There is no such grant defined for user '%s' on host '%s'

  • Error number: 1142; Symbol: ER_TABLEACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: %s command denied to user '%s'@'%s' for table '%s'

  • Error number: 1143; Symbol: ER_COLUMNACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: %s command denied to user '%s'@'%s' for column '%s' in table '%s'

  • Error number: 1144; Symbol: ER_ILLEGAL_GRANT_FOR_TABLE; SQLSTATE: 42000

    Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

  • Error number: 1145; Symbol: ER_GRANT_WRONG_HOST_OR_USER; SQLSTATE: 42000

    Message: The host or user argument to GRANT is too long

  • Error number: 1146; Symbol: ER_NO_SUCH_TABLE; SQLSTATE: 42S02

    Message: Table '%s.%s' doesn't exist

  • Error number: 1147; Symbol: ER_NONEXISTING_TABLE_GRANT; SQLSTATE: 42000

    Message: There is no such grant defined for user '%s' on host '%s' on table '%s'

  • Error number: 1148; Symbol: ER_NOT_ALLOWED_COMMAND; SQLSTATE: 42000

    Message: The used command is not allowed with this MySQL version

  • Error number: 1149; Symbol: ER_SYNTAX_ERROR; SQLSTATE: 42000

    Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

  • Error number: 1150; Symbol: ER_UNUSED1; SQLSTATE: HY000

    Message: Delayed insert thread couldn't get requested lock for table %s

  • Error number: 1151; Symbol: ER_UNUSED2; SQLSTATE: HY000

    Message: Too many delayed threads in use

  • Error number: 1152; Symbol: ER_ABORTING_CONNECTION; SQLSTATE: 08S01

    Message: Aborted connection %ld to db: '%s' user: '%s' (%s)

  • Error number: 1153; Symbol: ER_NET_PACKET_TOO_LARGE; SQLSTATE: 08S01

    Message: Got a packet bigger than 'max_allowed_packet' bytes

  • Error number: 1154; Symbol: ER_NET_READ_ERROR_FROM_PIPE; SQLSTATE: 08S01

    Message: Got a read error from the connection pipe

  • Error number: 1155; Symbol: ER_NET_FCNTL_ERROR; SQLSTATE: 08S01

    Message: Got an error from fcntl()

  • Error number: 1156; Symbol: ER_NET_PACKETS_OUT_OF_ORDER; SQLSTATE: 08S01

    Message: Got packets out of order

  • Error number: 1157; Symbol: ER_NET_UNCOMPRESS_ERROR; SQLSTATE: 08S01

    Message: Couldn't uncompress communication packet

  • Error number: 1158; Symbol: ER_NET_READ_ERROR; SQLSTATE: 08S01

    Message: Got an error reading communication packets

  • Error number: 1159; Symbol: ER_NET_READ_INTERRUPTED; SQLSTATE: 08S01

    Message: Got timeout reading communication packets

  • Error number: 1160; Symbol: ER_NET_ERROR_ON_WRITE; SQLSTATE: 08S01

    Message: Got an error writing communication packets

  • Error number: 1161; Symbol: ER_NET_WRITE_INTERRUPTED; SQLSTATE: 08S01

    Message: Got timeout writing communication packets

  • Error number: 1162; Symbol: ER_TOO_LONG_STRING; SQLSTATE: 42000

    Message: Result string is longer than 'max_allowed_packet' bytes

  • Error number: 1163; Symbol: ER_TABLE_CANT_HANDLE_BLOB; SQLSTATE: 42000

    Message: The used table type doesn't support BLOB/TEXT columns

  • Error number: 1164; Symbol: ER_TABLE_CANT_HANDLE_AUTO_INCREMENT; SQLSTATE: 42000

    Message: The used table type doesn't support AUTO_INCREMENT columns

  • Error number: 1165; Symbol: ER_UNUSED3; SQLSTATE: HY000

    Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES

  • Error number: 1166; Symbol: ER_WRONG_COLUMN_NAME; SQLSTATE: 42000

    Message: Incorrect column name '%s'

  • Error number: 1167; Symbol: ER_WRONG_KEY_COLUMN; SQLSTATE: 42000

    Message: The used storage engine can't index column '%s'

  • Error number: 1168; Symbol: ER_WRONG_MRG_TABLE; SQLSTATE: HY000

    Message: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

  • Error number: 1169; Symbol: ER_DUP_UNIQUE; SQLSTATE: 23000

    Message: Can't write, because of unique constraint, to table '%s'

  • Error number: 1170; Symbol: ER_BLOB_KEY_WITHOUT_LENGTH; SQLSTATE: 42000

    Message: BLOB/TEXT column '%s' used in key specification without a key length

  • Error number: 1171; Symbol: ER_PRIMARY_CANT_HAVE_NULL; SQLSTATE: 42000

    Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

  • Error number: 1172; Symbol: ER_TOO_MANY_ROWS; SQLSTATE: 42000

    Message: Result consisted of more than one row

  • Error number: 1173; Symbol: ER_REQUIRES_PRIMARY_KEY; SQLSTATE: 42000

    Message: This table type requires a primary key

  • Error number: 1174; Symbol: ER_NO_RAID_COMPILED; SQLSTATE: HY000

    Message: This version of MySQL is not compiled with RAID support

  • Error number: 1175; Symbol: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE; SQLSTATE: HY000

    Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. %s

  • Error number: 1176; Symbol: ER_KEY_DOES_NOT_EXITS; SQLSTATE: 42000

    Message: Key '%s' doesn't exist in table '%s'

  • Error number: 1177; Symbol: ER_CHECK_NO_SUCH_TABLE; SQLSTATE: 42000

    Message: Can't open table

  • Error number: 1178; Symbol: ER_CHECK_NOT_IMPLEMENTED; SQLSTATE: 42000

    Message: The storage engine for the table doesn't support %s

  • Error number: 1179; Symbol: ER_CANT_DO_THIS_DURING_AN_TRANSACTION; SQLSTATE: 25000

    Message: You are not allowed to execute this command in a transaction

  • Error number: 1180; Symbol: ER_ERROR_DURING_COMMIT; SQLSTATE: HY000

    Message: Got error %d during COMMIT

  • Error number: 1181; Symbol: ER_ERROR_DURING_ROLLBACK; SQLSTATE: HY000

    Message: Got error %d during ROLLBACK

  • Error number: 1182; Symbol: ER_ERROR_DURING_FLUSH_LOGS; SQLSTATE: HY000

    Message: Got error %d during FLUSH_LOGS

  • Error number: 1183; Symbol: ER_ERROR_DURING_CHECKPOINT; SQLSTATE: HY000

    Message: Got error %d during CHECKPOINT

  • Error number: 1184; Symbol: ER_NEW_ABORTING_CONNECTION; SQLSTATE: 08S01

    Message: Aborted connection %u to db: '%s' user: '%s' host: '%s' (%s)

  • Error number: 1185; Symbol: ER_DUMP_NOT_IMPLEMENTED; SQLSTATE: HY000

    Message: The storage engine for the table does not support binary table dump

  • Error number: 1186; Symbol: ER_FLUSH_MASTER_BINLOG_CLOSED; SQLSTATE: HY000

    Message: Binlog closed, cannot RESET MASTER

  • Error number: 1187; Symbol: ER_INDEX_REBUILD; SQLSTATE: HY000

    Message: Failed rebuilding the index of dumped table '%s'

  • Error number: 1188; Symbol: ER_MASTER; SQLSTATE: HY000

    Message: Error from master: '%s'

  • Error number: 1189; Symbol: ER_MASTER_NET_READ; SQLSTATE: 08S01

    Message: Net error reading from master

  • Error number: 1190; Symbol: ER_MASTER_NET_WRITE; SQLSTATE: 08S01

    Message: Net error writing to master

  • Error number: 1191; Symbol: ER_FT_MATCHING_KEY_NOT_FOUND; SQLSTATE: HY000

    Message: Can't find FULLTEXT index matching the column list

  • Error number: 1192; Symbol: ER_LOCK_OR_ACTIVE_TRANSACTION; SQLSTATE: HY000

    Message: Can't execute the given command because you have active locked tables or an active transaction

  • Error number: 1193; Symbol: ER_UNKNOWN_SYSTEM_VARIABLE; SQLSTATE: HY000

    Message: Unknown system variable '%s'

  • Error number: 1194; Symbol: ER_CRASHED_ON_USAGE; SQLSTATE: HY000

    Message: Table '%s' is marked as crashed and should be repaired

  • Error number: 1195; Symbol: ER_CRASHED_ON_REPAIR; SQLSTATE: HY000

    Message: Table '%s' is marked as crashed and last (automatic?) repair failed

  • Error number: 1196; Symbol: ER_WARNING_NOT_COMPLETE_ROLLBACK; SQLSTATE: HY000

    Message: Some non-transactional changed tables couldn't be rolled back

  • Error number: 1197; Symbol: ER_TRANS_CACHE_FULL; SQLSTATE: HY000

    Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again

  • Error number: 1198; Symbol: ER_SLAVE_MUST_STOP; SQLSTATE: HY000

    Message: This operation cannot be performed with a running slave; run STOP SLAVE first

  • Error number: 1199; Symbol: ER_SLAVE_NOT_RUNNING; SQLSTATE: HY000

    Message: This operation requires a running slave; configure slave and do START SLAVE

  • Error number: 1200; Symbol: ER_BAD_SLAVE; SQLSTATE: HY000

    Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

  • Error number: 1201; Symbol: ER_MASTER_INFO; SQLSTATE: HY000

    Message: Could not initialize master info structure; more error messages can be found in the MySQL error log

  • Error number: 1202; Symbol: ER_SLAVE_THREAD; SQLSTATE: HY000

    Message: Could not create slave thread; check system resources

  • Error number: 1203; Symbol: ER_TOO_MANY_USER_CONNECTIONS; SQLSTATE: 42000

    Message: User %s already has more than 'max_user_connections' active connections

  • Error number: 1204; Symbol: ER_SET_CONSTANTS_ONLY; SQLSTATE: HY000

    Message: You may only use constant expressions with SET

  • Error number: 1205; Symbol: ER_LOCK_WAIT_TIMEOUT; SQLSTATE: HY000

    Message: Lock wait timeout exceeded; try restarting transaction

    InnoDB reports this error when lock wait timeout expires. The statement that waited too long was rolled back (not the entire transaction). You can increase the value of the innodb_lock_wait_timeout configuration option if SQL statements should wait longer for other transactions to complete, or decrease it if too many long-running transactions are causing locking problems and reducing concurrency on a busy system.

  • Error number: 1206; Symbol: ER_LOCK_TABLE_FULL; SQLSTATE: HY000

    Message: The total number of locks exceeds the lock table size

    InnoDB reports this error when the total number of locks exceeds the amount of memory devoted to managing locks. To avoid this error, increase the value of innodb_buffer_pool_size. Within an individual application, a workaround may be to break a large operation into smaller pieces. For example, if the error occurs for a large INSERT, perform several smaller INSERT operations.

  • Error number: 1207; Symbol: ER_READ_ONLY_TRANSACTION; SQLSTATE: 25000

    Message: Update locks cannot be acquired during a READ UNCOMMITTED transaction

  • Error number: 1208; Symbol: ER_DROP_DB_WITH_READ_LOCK; SQLSTATE: HY000

    Message: DROP DATABASE not allowed while thread is holding global read lock

  • Error number: 1209; Symbol: ER_CREATE_DB_WITH_READ_LOCK; SQLSTATE: HY000

    Message: CREATE DATABASE not allowed while thread is holding global read lock

  • Error number: 1210; Symbol: ER_WRONG_ARGUMENTS; SQLSTATE: HY000

    Message: Incorrect arguments to %s

  • Error number: 1211; Symbol: ER_NO_PERMISSION_TO_CREATE_USER; SQLSTATE: 42000

    Message: '%s'@'%s' is not allowed to create new users

  • Error number: 1212; Symbol: ER_UNION_TABLES_IN_DIFFERENT_DIR; SQLSTATE: HY000

    Message: Incorrect table definition; all MERGE tables must be in the same database

  • Error number: 1213; Symbol: ER_LOCK_DEADLOCK; SQLSTATE: 40001

    Message: Deadlock found when trying to get lock; try restarting transaction

    InnoDB reports this error when a transaction encounters a deadlock and is automatically rolled back so that your application can take corrective action. To recover from this error, run all the operations in this transaction again. A deadlock occurs when requests for locks arrive in inconsistent order between transactions. The transaction that was rolled back released all its locks, and the other transaction can now get all the locks it requested. Thus, when you re-run the transaction that was rolled back, it might have to wait for other transactions to complete, but typically the deadlock does not recur. If you encounter frequent deadlocks, make the sequence of locking operations (LOCK TABLES, SELECT ... FOR UPDATE, and so on) consistent between the different transactions or applications that experience the issue. See Section 14.7.5, “Deadlocks in InnoDB” for details.

  • Error number: 1214; Symbol: ER_TABLE_CANT_HANDLE_FT; SQLSTATE: HY000

    Message: The used table type doesn't support FULLTEXT indexes

  • Error number: 1215; Symbol: ER_CANNOT_ADD_FOREIGN; SQLSTATE: HY000

    Message: Cannot add foreign key constraint

  • Error number: 1216; Symbol: ER_NO_REFERENCED_ROW; SQLSTATE: 23000

    Message: Cannot add or update a child row: a foreign key constraint fails

    InnoDB reports this error when you try to add a row but there is no parent row, and a foreign key constraint fails. Add the parent row first.

  • Error number: 1217; Symbol: ER_ROW_IS_REFERENCED; SQLSTATE: 23000

    Message: Cannot delete or update a parent row: a foreign key constraint fails

    InnoDB reports this error when you try to delete a parent row that has children, and a foreign key constraint fails. Delete the children first.

  • Error number: 1218; Symbol: ER_CONNECT_TO_MASTER; SQLSTATE: 08S01

    Message: Error connecting to master: %s

  • Error number: 1219; Symbol: ER_QUERY_ON_MASTER; SQLSTATE: HY000

    Message: Error running query on master: %s

  • Error number: 1220; Symbol: ER_ERROR_WHEN_EXECUTING_COMMAND; SQLSTATE: HY000

    Message: Error when executing command %s: %s

  • Error number: 1221; Symbol: ER_WRONG_USAGE; SQLSTATE: HY000

    Message: Incorrect usage of %s and %s

  • Error number: 1222; Symbol: ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT; SQLSTATE: 21000

    Message: The used SELECT statements have a different number of columns

  • Error number: 1223; Symbol: ER_CANT_UPDATE_WITH_READLOCK; SQLSTATE: HY000

    Message: Can't execute the query because you have a conflicting read lock

  • Error number: 1224; Symbol: ER_MIXING_NOT_ALLOWED; SQLSTATE: HY000

    Message: Mixing of transactional and non-transactional tables is disabled

  • Error number: 1225; Symbol: ER_DUP_ARGUMENT; SQLSTATE: HY000

    Message: Option '%s' used twice in statement

  • Error number: 1226; Symbol: ER_USER_LIMIT_REACHED; SQLSTATE: 42000

    Message: User '%s' has exceeded the '%s' resource (current value: %ld)

  • Error number: 1227; Symbol: ER_SPECIFIC_ACCESS_DENIED_ERROR; SQLSTATE: 42000

    Message: Access denied; you need (at least one of) the %s privilege(s) for this operation

  • Error number: 1228; Symbol: ER_LOCAL_VARIABLE; SQLSTATE: HY000

    Message: Variable '%s' is a SESSION variable and can't be used with SET GLOBAL

  • Error number: 1229; Symbol: ER_GLOBAL_VARIABLE; SQLSTATE: HY000

    Message: Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL

  • Error number: 1230; Symbol: ER_NO_DEFAULT; SQLSTATE: 42000

    Message: Variable '%s' doesn't have a default value

  • Error number: 1231; Symbol: ER_WRONG_VALUE_FOR_VAR; SQLSTATE: 42000

    Message: Variable '%s' can't be set to the value of '%s'

  • Error number: 1232; Symbol: ER_WRONG_TYPE_FOR_VAR; SQLSTATE: 42000

    Message: Incorrect argument type to variable '%s'

  • Error number: 1233; Symbol: ER_VAR_CANT_BE_READ; SQLSTATE: HY000

    Message: Variable '%s' can only be set, not read

  • Error number: 1234; Symbol: ER_CANT_USE_OPTION_HERE; SQLSTATE: 42000

    Message: Incorrect usage/placement of '%s'

  • Error number: 1235; Symbol: ER_NOT_SUPPORTED_YET; SQLSTATE: 42000

    Message: This version of MySQL doesn't yet support '%s'

  • Error number: 1236; Symbol: ER_MASTER_FATAL_ERROR_READING_BINLOG; SQLSTATE: HY000

    Message: Got fatal error %d from master when reading data from binary log: '%s'

  • Error number: 1237; Symbol: ER_SLAVE_IGNORED_TABLE; SQLSTATE: HY000

    Message: Slave SQL thread ignored the query because of replicate-*-table rules

  • Error number: 1238; Symbol: ER_INCORRECT_GLOBAL_LOCAL_VAR; SQLSTATE: HY000

    Message: Variable '%s' is a %s variable

  • Error number: 1239; Symbol: ER_WRONG_FK_DEF; SQLSTATE: 42000

    Message: Incorrect foreign key definition for '%s': %s

  • Error number: 1240; Symbol: ER_KEY_REF_DO_NOT_MATCH_TABLE_REF; SQLSTATE: HY000

    Message: Key reference and table reference don't match

  • Error number: 1241; Symbol: ER_OPERAND_COLUMNS; SQLSTATE: 21000

    Message: Operand should contain %d column(s)

  • Error number: 1242; Symbol: ER_SUBQUERY_NO_1_ROW; SQLSTATE: 21000

    Message: Subquery returns more than 1 row

  • Error number: 1243; Symbol: ER_UNKNOWN_STMT_HANDLER; SQLSTATE: HY000

    Message: Unknown prepared statement handler (%.*s) given to %s

  • Error number: 1244; Symbol: ER_CORRUPT_HELP_DB; SQLSTATE: HY000

    Message: Help database is corrupt or does not exist

  • Error number: 1245; Symbol: ER_CYCLIC_REFERENCE; SQLSTATE: HY000

    Message: Cyclic reference on subqueries

  • Error number: 1246; Symbol: ER_AUTO_CONVERT; SQLSTATE: HY000

    Message: Converting column '%s' from %s to %s

  • Error number: 1247; Symbol: ER_ILLEGAL_REFERENCE; SQLSTATE: 42S22

    Message: Reference '%s' not supported (%s)

  • Error number: 1248; Symbol: ER_DERIVED_MUST_HAVE_ALIAS; SQLSTATE: 42000

    Message: Every derived table must have its own alias

  • Error number: 1249; Symbol: ER_SELECT_REDUCED; SQLSTATE: 01000

    Message: Select %u was reduced during optimization

  • Error number: 1250; Symbol: ER_TABLENAME_NOT_ALLOWED_HERE; SQLSTATE: 42000

    Message: Table '%s' from one of the SELECTs cannot be used in %s

  • Error number: 1251; Symbol: ER_NOT_SUPPORTED_AUTH_MODE; SQLSTATE: 08004

    Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client

  • Error number: 1252; Symbol: ER_SPATIAL_CANT_HAVE_NULL; SQLSTATE: 42000

    Message: All parts of a SPATIAL index must be NOT NULL

  • Error number: 1253; Symbol: ER_COLLATION_CHARSET_MISMATCH; SQLSTATE: 42000

    Message: COLLATION '%s' is not valid for CHARACTER SET '%s'

  • Error number: 1254; Symbol: ER_SLAVE_WAS_RUNNING; SQLSTATE: HY000

    Message: Slave is already running

  • Error number: 1255; Symbol: ER_SLAVE_WAS_NOT_RUNNING; SQLSTATE: HY000

    Message: Slave already has been stopped

  • Error number: 1256; Symbol: ER_TOO_BIG_FOR_UNCOMPRESS; SQLSTATE: HY000

    Message: Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)

  • Error number: 1257; Symbol: ER_ZLIB_Z_MEM_ERROR; SQLSTATE: HY000

    Message: ZLIB: Not enough memory

  • Error number: 1258; Symbol: ER_ZLIB_Z_BUF_ERROR; SQLSTATE: HY000

    Message: ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)

  • Error number: 1259; Symbol: ER_ZLIB_Z_DATA_ERROR; SQLSTATE: HY000

    Message: ZLIB: Input data corrupted

  • Error number: 1260; Symbol: ER_CUT_VALUE_GROUP_CONCAT; SQLSTATE: HY000

    Message: Row %u was cut by GROUP_CONCAT()

  • Error number: 1261; Symbol: ER_WARN_TOO_FEW_RECORDS; SQLSTATE: 01000

    Message: Row %ld doesn't contain data for all columns

  • Error number: 1262; Symbol: ER_WARN_TOO_MANY_RECORDS; SQLSTATE: 01000

    Message: Row %ld was truncated; it contained more data than there were input columns

  • Error number: 1263; Symbol: ER_WARN_NULL_TO_NOTNULL; SQLSTATE: 22004

    Message: Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld

  • Error number: 1264; Symbol: ER_WARN_DATA_OUT_OF_RANGE; SQLSTATE: 22003

    Message: Out of range value for column '%s' at row %ld

  • Error number: 1265; Symbol: WARN_DATA_TRUNCATED; SQLSTATE: 01000

    Message: Data truncated for column '%s' at row %ld

  • Error number: 1266; Symbol: ER_WARN_USING_OTHER_HANDLER; SQLSTATE: HY000

    Message: Using storage engine %s for table '%s'

  • Error number: 1267; Symbol: ER_CANT_AGGREGATE_2COLLATIONS; SQLSTATE: HY000

    Message: Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'

  • Error number: 1268; Symbol: ER_DROP_USER; SQLSTATE: HY000

    Message: Cannot drop one or more of the requested users

  • Error number: 1269; Symbol: ER_REVOKE_GRANTS; SQLSTATE: HY000

    Message: Can't revoke all privileges for one or more of the requested users

  • Error number: 1270; Symbol: ER_CANT_AGGREGATE_3COLLATIONS; SQLSTATE: HY000

    Message: Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'

  • Error number: 1271; Symbol: ER_CANT_AGGREGATE_NCOLLATIONS; SQLSTATE: HY000

    Message: Illegal mix of collations for operation '%s'

  • Error number: 1272; Symbol: ER_VARIABLE_IS_NOT_STRUCT; SQLSTATE: HY000

    Message: Variable '%s' is not a variable component (can't be used as XXXX.variable_name)

  • Error number: 1273; Symbol: ER_UNKNOWN_COLLATION; SQLSTATE: HY000

    Message: Unknown collation: '%s'

  • Error number: 1274; Symbol: ER_SLAVE_IGNORED_SSL_PARAMS; SQLSTATE: HY000

    Message: SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support; they can be used later if MySQL slave with SSL is started

  • Error number: 1275; Symbol: ER_SERVER_IS_IN_SECURE_AUTH_MODE; SQLSTATE: HY000

    Message: Server is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format

  • Error number: 1276; Symbol: ER_WARN_FIELD_RESOLVED; SQLSTATE: HY000

    Message: Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d

  • Error number: 1277; Symbol: ER_BAD_SLAVE_UNTIL_COND; SQLSTATE: HY000

    Message: Incorrect parameter or combination of parameters for START SLAVE UNTIL

  • Error number: 1278; Symbol: ER_MISSING_SKIP_SLAVE; SQLSTATE: HY000

    Message: It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart

  • Error number: 1279; Symbol: ER_UNTIL_COND_IGNORED; SQLSTATE: HY000

    Message: SQL thread is not to be started so UNTIL options are ignored

  • Error number: 1280; Symbol: ER_WRONG_NAME_FOR_INDEX; SQLSTATE: 42000

    Message: Incorrect index name '%s'

  • Error number: 1281; Symbol: ER_WRONG_NAME_FOR_CATALOG; SQLSTATE: 42000

    Message: Incorrect catalog name '%s'

  • Error number: 1282; Symbol: ER_WARN_QC_RESIZE; SQLSTATE: HY000

    Message: Query cache failed to set size %lu; new query cache size is %lu

  • Error number: 1283; Symbol: ER_BAD_FT_COLUMN; SQLSTATE: HY000

    Message: Column '%s' cannot be part of FULLTEXT index

  • Error number: 1284; Symbol: ER_UNKNOWN_KEY_CACHE; SQLSTATE: HY000

    Message: Unknown key cache '%s'

  • Error number: 1285; Symbol: ER_WARN_HOSTNAME_WONT_WORK; SQLSTATE: HY000

    Message: MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work

  • Error number: 1286; Symbol: ER_UNKNOWN_STORAGE_ENGINE; SQLSTATE: 42000

    Message: Unknown storage engine '%s'

  • Error number: 1287; Symbol: ER_WARN_DEPRECATED_SYNTAX; SQLSTATE: HY000

    Message: '%s' is deprecated and will be removed in a future release. Please use %s instead

  • Error number: 1288; Symbol: ER_NON_UPDATABLE_TABLE; SQLSTATE: HY000

    Message: The target table %s of the %s is not updatable

  • Error number: 1289; Symbol: ER_FEATURE_DISABLED; SQLSTATE: HY000

    Message: The '%s' feature is disabled; you need MySQL built with '%s' to have it working

  • Error number: 1290; Symbol: ER_OPTION_PREVENTS_STATEMENT; SQLSTATE: HY000

    Message: The MySQL server is running with the %s option so it cannot execute this statement

  • Error number: 1291; Symbol: ER_DUPLICATED_VALUE_IN_TYPE; SQLSTATE: HY000

    Message: Column '%s' has duplicated value '%s' in %s

  • Error number: 1292; Symbol: