MySQL Status-Codes

Im Folgenden sind die Statuscodes des MySQL - Datenbanksystems aufgelistet.

Die Fehlercodes stehen in "include/mysqld_error.h", der SQL-Status ist in "include/sql_state.h" definiert und die Fehlertexte sind in "mysql/share/english/errmsg.txt" beschrieben.

Zum Teil sind die Fehlerbeschreibungen auch ins Deutsche übersetzt. Dann befinden sich die Fehlertexte im Ordner "mysql/share/german/errmsg.txt"

• 1000 SQL-Status: HY000 (ER_HASHCHK) Message: hashchk
• 1001 SQL-Status: HY000 (ER_NISAMCHK) Message: isamchk
• 1002 SQL-Status: HY000 (ER_NO) Message: NO
• 1003 SQL-Status: HY000 (ER_YES) Message: YES
• 1004 SQL-Status: HY000 (ER_CANT_CREATE_FILE) Message: Can't create file '%s' (errno: %d)
• 1005 SQL-Status: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: %d)
• 1006 SQL-Status: HY000 (ER_CANT_CREATE_DB) Message: Can't create database '%s' (errno: %d)
• 1007 SQL-Status: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
• 1008 SQL-Status: HY000 (ER_DB_DROP_EXISTS) Message: Can't drop database '%s'; database doesn't exist
• 1009 SQL-Status: HY000 (ER_DB_DROP_DELETE) Message: Error dropping database (can't delete '%s', errno: %d)
• 1010 SQL-Status: HY000 (ER_DB_DROP_RMDIR) Message: Error dropping database (can't rmdir '%s', errno: %d)
• 1011 SQL-Status: HY000 (ER_CANT_DELETE_FILE) Message: Error on delete of '%s' (errno: %d)
• 1012 SQL-Status: HY000 (ER_CANT_FIND_SYSTEM_REC) Message: Can't read record in system table
• 1013 SQL-Status: HY000 (ER_CANT_GET_STAT) Message: Can't get status of '%s' (errno: %d)
• 1014 SQL-Status: HY000 (ER_CANT_GET_WD) Message: Can't get working directory (errno: %d)
• 1015 SQL-Status: HY000 (ER_CANT_LOCK) Message: Can't lock file (errno: %d)
• 1016 SQL-Status: HY000 (ER_CANT_OPEN_FILE) Message: Can't open file: '%s' (errno: %d)
• 1017 SQL-Status: HY000 (ER_FILE_NOT_FOUND) Message: Can't find file: '%s' (errno: %d)
• 1018 SQL-Status: HY000 (ER_CANT_READ_DIR) Message: Can't read dir of '%s' (errno: %d)
• 1019 SQL-Status: HY000 (ER_CANT_SET_WD) Message: Can't change dir to '%s' (errno: %d)
• 1020 SQL-Status: HY000 (ER_CHECKREAD) Message: Record has changed since last read in table '%s'
• 1021 SQL-Status: HY000 (ER_DISK_FULL) Message: Disk full (%s); waiting for someone to free some space...
• 1022 SQL-Status: 23000 (ER_DUP_KEY) Message: Can't write; duplicate key in table '%s'
• 1023 SQL-Status: HY000 (ER_ERROR_ON_CLOSE) Message: Error on close of '%s' (errno: %d)
• 1024 SQL-Status: HY000 (ER_ERROR_ON_READ) Message: Error reading file '%s' (errno: %d)
• 1025 SQL-Status: HY000 (ER_ERROR_ON_RENAME) Message: Error on rename of '%s' to '%s' (errno: %d)
• 1026 SQL-Status: HY000 (ER_ERROR_ON_WRITE) Message: Error writing file '%s' (errno: %d)
• 1027 SQL-Status: HY000 (ER_FILE_USED) Message: '%s' is locked against change
• 1028 SQL-Status: HY000 (ER_FILSORT_ABORT) Message: Sort aborted
• 1029 SQL-Status: HY000 (ER_FORM_NOT_FOUND) Message: View '%s' doesn't exist for '%s'
• 1030 SQL-Status: HY000 (ER_GET_ERRNO) Message: Got error %d from storage engine
• 1031 SQL-Status: HY000 (ER_ILLEGAL_HA) Message: Table storage engine for '%s' doesn't have this option
• 1032 SQL-Status: HY000 (ER_KEY_NOT_FOUND) Message: Can't find record in '%s'
• 1033 SQL-Status: HY000 (ER_NOT_FORM_FILE) Message: Incorrect information in file: '%s'
• 1034 SQL-Status: HY000 (ER_NOT_KEYFILE) Message: Incorrect key file for table '%s'; try to repair it
• 1035 SQL-Status: HY000 (ER_OLD_KEYFILE) Message: Old key file for table '%s'; repair it!
• 1036 SQL-Status: HY000 (ER_OPEN_AS_READONLY) Message: Table '%s' is read only
• 1037 SQL-Status: HY001 (ER_OUTOFMEMORY) Message: Out of memory; restart server and try again (needed %d bytes)
• 1038 SQL-Status: HY001 (ER_OUT_OF_SORTMEMORY) Message: Out of sort memory; increase server sort buffer size
• 1039 SQL-Status: HY000 (ER_UNEXPECTED_EOF) Message: Unexpected EOF found when reading file '%s' (errno: %d)
• 1040 SQL-Status: 08004 (ER_CON_COUNT_ERROR) Message: Too many connections
• 1041 SQL-Status: HY000 (ER_OUT_OF_RESOURCES) 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
• 1042 SQL-Status: 08S01 (ER_BAD_HOST_ERROR) Message: Can't get hostname for your address
• 1043 SQL-Status: 08S01 (ER_HANDSHAKE_ERROR) Message: Bad handshake
• 1044 SQL-Status: 42000 (ER_DBACCESS_DENIED_ERROR) Message: Access denied for user '%s''%s' to database '%s'
• 1045 SQL-Status: 28000 (ER_ACCESS_DENIED_ERROR) Message: Access denied for user '%s''%s' (using password: %s)
• 1046 SQL-Status: 3D000 (ER_NO_DB_ERROR) Message: No database selected
• 1047 SQL-Status: 08S01 (ER_UNKNOWN_COM_ERROR) Message: Unknown command
• 1048 SQL-Status: 23000 (ER_BAD_NULL_ERROR) Message: Column '%s' cannot be null
• 1049 SQL-Status: 42000 (ER_BAD_DB_ERROR) Message: Unknown database '%s'
• 1050 SQL-Status: 42S01 (ER_TABLE_EXISTS_ERROR) Message: Table '%s' already exists
• 1051 SQL-Status: 42S02 (ER_BAD_TABLE_ERROR) Message: Unknown table '%s'
• 1052 SQL-Status: 23000 (ER_NON_UNIQ_ERROR) Message: Column '%s' in %s is ambiguous
• 1053 SQL-Status: 08S01 (ER_SERVER_SHUTDOWN) Message: Server shutdown in progress
• 1054 SQL-Status: 42S22 (ER_BAD_FIELD_ERROR) Message: Unknown column '%s' in '%s'
• 1055 SQL-Status: 42000 (ER_WRONG_FIELD_WITH_GROUP) Message: '%s' isn't in GROUP BY
• 1056 SQL-Status: 42000 (ER_WRONG_GROUP_FIELD) Message: Can't group on '%s'
• 1057 SQL-Status: 42000 (ER_WRONG_SUM_SELECT) Message: Statement has sum functions and columns in same statement
• 1058 SQL-Status: 21S01 (ER_WRONG_VALUE_COUNT) Message: Column count doesn't match value count
• 1059 SQL-Status: 42000 (ER_TOO_LONG_IDENT) Message: Identifier name '%s' is too long
• 1060 SQL-Status: 42S21 (ER_DUP_FIELDNAME) Message: Duplicate column name '%s'
• 1061 SQL-Status: 42000 (ER_DUP_KEYNAME) Message: Duplicate key name '%s'
• 1062 SQL-Status: 23000 (ER_DUP_ENTRY) Message: Duplicate entry '%s' for key %d
• 1063 SQL-Status: 42000 (ER_WRONG_FIELD_SPEC) Message: Incorrect column specifier for column '%s'
• 1064 SQL-Status: 42000 (ER_PARSE_ERROR) Message: %s near '%s' at line %d
• 1065 SQL-Status: HY000 (ER_EMPTY_QUERY) Message: Query was empty
• 1066 SQL-Status: 42000 (ER_NONUNIQ_TABLE) Message: Not unique table/alias: '%s'
• 1067 SQL-Status: 42000 (ER_INVALID_DEFAULT) Message: Invalid default value for '%s'
• 1068 SQL-Status: 42000 (ER_MULTIPLE_PRI_KEY) Message: Multiple primary key defined
• 1069 SQL-Status: 42000 (ER_TOO_MANY_KEYS) Message: Too many keys specified; max %d keys allowed
• 1070 SQL-Status: 42000 (ER_TOO_MANY_KEY_PARTS) Message: Too many key parts specified; max %d parts allowed
• 1071 SQL-Status: 42000 (ER_TOO_LONG_KEY) Message: Specified key was too long; max key length is %d bytes
• 1072 SQL-Status: 42000 (ER_KEY_COLUMN_DOES_NOT_EXITS) Message: Key column '%s' doesn't exist in table
• 1073 SQL-Status: 42000 (ER_BLOB_USED_AS_KEY) Message: BLOB column '%s' can't be used in key specification with the used table type
• 1074 SQL-Status: 42000 (ER_TOO_BIG_FIELDLENGTH) Message: Column length too big for column '%s' (max = %d); use BLOB instead
• 1075 SQL-Status: 42000 (ER_WRONG_AUTO_KEY) Message: Incorrect table definition; there can be only one auto column and it must be defined as a key
• 1076 SQL-Status: HY000 (ER_READY) Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d
• 1077 SQL-Status: HY000 (ER_NORMAL_SHUTDOWN) Message: %s: Normal shutdown
• 1078 SQL-Status: HY000 (ER_GOT_SIGNAL) Message: %s: Got signal %d. Aborting!
• 1079 SQL-Status: HY000 (ER_SHUTDOWN_COMPLETE) Message: %s: Shutdown complete
• 1080 SQL-Status: 08S01 (ER_FORCING_CLOSE) Message: %s: Forcing close of thread %ld user: '%s'
• 1081 SQL-Status: 08S01 (ER_IPSOCK_ERROR) Message: Can't create IP socket
• 1082 SQL-Status: 42S12 (ER_NO_SUCH_INDEX) Message: Table '%s' has no index like the one used in CREATE INDEX; recreate the table
• 1083 SQL-Status: 42000 (ER_WRONG_FIELD_TERMINATORS) Message: Field separator argument is not what is expected; check the manual
• 1084 SQL-Status: 42000 (ER_BLOBS_AND_NO_TERMINATED) Message: You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
• 1085 SQL-Status: HY000 (ER_TEXTFILE_NOT_READABLE) Message: The file '%s' must be in the database directory or be readable by all
• 1086 SQL-Status: HY000 (ER_FILE_EXISTS_ERROR) Message: File '%s' already exists
• 1087 SQL-Status: HY000 (ER_LOAD_INFO) Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
• 1088 SQL-Status: HY000 (ER_ALTER_INFO) Message: Records: %ld Duplicates: %ld
• 1089 SQL-Status: HY000 (ER_WRONG_SUB_KEY) Message: Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
• 1090 SQL-Status: 42000 (ER_CANT_REMOVE_ALL_FIELDS) Message: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
• 1091 SQL-Status: 42000 (ER_CANT_DROP_FIELD_OR_KEY) Message: Can't DROP '%s'; check that column/key exists
• 1092 SQL-Status: HY000 (ER_INSERT_INFO) Message: Records: %ld Duplicates: %ld Warnings: %ld
• 1093 SQL-Status: HY000 (ER_UPDATE_TABLE_USED) Message: You can't specify target table '%s' for update in FROM clause
• 1094 SQL-Status: HY000 (ER_NO_SUCH_THREAD) Message: Unknown thread id: %lu
• 1095 SQL-Status: HY000 (ER_KILL_DENIED_ERROR) Message: You are not owner of thread %lu
• 1096 SQL-Status: HY000 (ER_NO_TABLES_USED) Message: No tables used
• 1097 SQL-Status: HY000 (ER_TOO_BIG_SET) Message: Too many strings for column %s and SET
• 1098 SQL-Status: HY000 (ER_NO_UNIQUE_LOGFILE) Message: Can't generate a unique log-filename %s.(1-999)
• 1099 SQL-Status: HY000 (ER_TABLE_NOT_LOCKED_FOR_WRITE) Message: Table '%s' was locked with a READ lock and can't be updated
• 1100 SQL-Status: HY000 (ER_TABLE_NOT_LOCKED) Message: Table '%s' was not locked with LOCK TABLES
• 1101 SQL-Status: 42000 (ER_BLOB_CANT_HAVE_DEFAULT) Message: BLOB/TEXT column '%s' can't have a default value
• 1102 SQL-Status: 42000 (ER_WRONG_DB_NAME) Message: Incorrect database name '%s'
• 1103 SQL-Status: 42000 (ER_WRONG_TABLE_NAME) Message: Incorrect table name '%s'
• 1104 SQL-Status: 42000 (ER_TOO_BIG_SELECT) Message: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
• 1105 SQL-Status: HY000 (ER_UNKNOWN_ERROR) Message: Unknown error
• 1106 SQL-Status: 42000 (ER_UNKNOWN_PROCEDURE) Message: Unknown procedure '%s'
• 1107 SQL-Status: 42000 (ER_WRONG_PARAMCOUNT_TO_PROCEDURE) Message: Incorrect parameter count to procedure '%s'
• 1108 SQL-Status: HY000 (ER_WRONG_PARAMETERS_TO_PROCEDURE) Message: Incorrect parameters to procedure '%s'
• 1109 SQL-Status: 42S02 (ER_UNKNOWN_TABLE) Message: Unknown table '%s' in %s
• 1110 SQL-Status: 42000 (ER_FIELD_SPECIFIED_TWICE) Message: Column '%s' specified twice
• 1111 SQL-Status: HY000 (ER_INVALID_GROUP_FUNC_USE) Message: Invalid use of group function
• 1112 SQL-Status: 42000 (ER_UNSUPPORTED_EXTENSION) Message: Table '%s' uses an extension that doesn't exist in this MySQL version
• 1113 SQL-Status: 42000 (ER_TABLE_MUST_HAVE_COLUMNS) Message: A table must have at least 1 column
• 1114 SQL-Status: HY000 (ER_RECORD_FILE_FULL) Message: The table '%s' is full
• 1115 SQL-Status: 42000 (ER_UNKNOWN_CHARACTER_SET) Message: Unknown character set: '%s'
• 1116 SQL-Status: HY000 (ER_TOO_MANY_TABLES) Message: Too many tables; MySQL can only use %d tables in a join
• 1117 SQL-Status: HY000 (ER_TOO_MANY_FIELDS) Message: Too many columns
• 1118 SQL-Status: 42000 (ER_TOO_BIG_ROWSIZE) Message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs
• 1119 SQL-Status: HY000 (ER_STACK_OVERRUN) Message: Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed
• 1120 SQL-Status: 42000 (ER_WRONG_OUTER_JOIN) Message: Cross dependency found in OUTER JOIN; examine your ON conditions
• 1121 SQL-Status: 42000 (ER_NULL_COLUMN_IN_INDEX) Message: Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL
• 1122 SQL-Status: HY000 (ER_CANT_FIND_UDF) Message: Can't load function '%s'
• 1123 SQL-Status: HY000 (ER_CANT_INITIALIZE_UDF) Message: Can't initialize function '%s'; %s
• 1124 SQL-Status: HY000 (ER_UDF_NO_PATHS) Message: No paths allowed for shared library
• 1125 SQL-Status: HY000 (ER_UDF_EXISTS) Message: Function '%s' already exists
• 1126 SQL-Status: HY000 (ER_CANT_OPEN_LIBRARY) Message: Can't open shared library '%s' (errno: %d %s)
• 1127 SQL-Status: HY000 (ER_CANT_FIND_DL_ENTRY) Message: Can't find function '%s' in library'
• 1128 SQL-Status: HY000 (ER_FUNCTION_NOT_DEFINED) Message: Function '%s' is not defined
• 1129 SQL-Status: HY000 (ER_HOST_IS_BLOCKED) Message: Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
• 1130 SQL-Status: HY000 (ER_HOST_NOT_PRIVILEGED) Message: Host '%s' is not allowed to connect to this MySQL server
• 1131 SQL-Status: 42000 (ER_PASSWORD_ANONYMOUS_USER) Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords
• 1132 SQL-Status: 42000 (ER_PASSWORD_NOT_ALLOWED) Message: You must have privileges to update tables in the mysql database to be able to change passwords for others
• 1133 SQL-Status: 42000 (ER_PASSWORD_NO_MATCH) Message: Can't find any matching row in the user table
• 1134 SQL-Status: HY000 (ER_UPDATE_INFO) Message: Rows matched: %ld Changed: %ld Warnings: %ld
• 1135 SQL-Status: HY000 (ER_CANT_CREATE_THREAD) 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
• 1136 SQL-Status: 21S01 (ER_WRONG_VALUE_COUNT_ON_ROW) Message: Column count doesn't match value count at row %ld
• 1137 SQL-Status: HY000 (ER_CANT_REOPEN_TABLE) Message: Can't reopen table: '%s'
• 1138 SQL-Status: 42000 (ER_INVALID_USE_OF_NULL) Message: Invalid use of NULL value
• 1139 SQL-Status: 42000 (ER_REGEXP_ERROR) Message: Got error '%s' from regexp
• 1140 SQL-Status: 42000 (ER_MIX_OF_GROUP_FUNC_AND_FIELDS) Message: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
• 1141 SQL-Status: 42000 (ER_NONEXISTING_GRANT) Message: There is no such grant defined for user '%s' on host '%s'
• 1142 SQL-Status: 42000 (ER_TABLEACCESS_DENIED_ERROR) Message: %s command denied to user '%s''%s' for table '%s'
• 1143 SQL-Status: 42000 (ER_COLUMNACCESS_DENIED_ERROR) Message: %s command denied to user '%s''%s' for column '%s' in table '%s'
• 1144 SQL-Status: 42000 (ER_ILLEGAL_GRANT_FOR_TABLE) Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
• 1145 SQL-Status: 42000 (ER_GRANT_WRONG_HOST_OR_USER) Message: The host or user argument to GRANT is too long
• 1146 SQL-Status: 42S02 (ER_NO_SUCH_TABLE) Message: Table '%s.%s' doesn't exist
• 1147 SQL-Status: 42000 (ER_NONEXISTING_TABLE_GRANT) Message: There is no such grant defined for user '%s' on host '%s' on table '%s'
• 1148 SQL-Status: 42000 (ER_NOT_ALLOWED_COMMAND) Message: The used command is not allowed with this MySQL version
• 1149 SQL-Status: 42000 (ER_SYNTAX_ERROR) 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
• 1150 SQL-Status: HY000 (ER_DELAYED_CANT_CHANGE_LOCK) Message: Delayed insert thread couldn't get requested lock for table %s
• 1151 SQL-Status: HY000 (ER_TOO_MANY_DELAYED_THREADS) Message: Too many delayed threads in use
• 1152 SQL-Status: 08S01 (ER_ABORTING_CONNECTION) Message: Aborted connection %ld to db: '%s' user: '%s' (%s)
• 1153 SQL-Status: 08S01 (ER_NET_PACKET_TOO_LARGE) Message: Got a packet bigger than 'max_allowed_packet' bytes
• 1154 SQL-Status: 08S01 (ER_NET_READ_ERROR_FROM_PIPE) Message: Got a read error from the connection pipe
• 1155 SQL-Status: 08S01 (ER_NET_FCNTL_ERROR) Message: Got an error from fcntl()
• 1156 SQL-Status: 08S01 (ER_NET_PACKETS_OUT_OF_ORDER) Message: Got packets out of order
• 1157 SQL-Status: 08S01 (ER_NET_UNCOMPRESS_ERROR) Message: Couldn't uncompress communication packet
• 1158 SQL-Status: 08S01 (ER_NET_READ_ERROR) Message: Got an error reading communication packets
• 1159 SQL-Status: 08S01 (ER_NET_READ_INTERRUPTED) Message: Got timeout reading communication packets
• 1160 SQL-Status: 08S01 (ER_NET_ERROR_ON_WRITE) Message: Got an error writing communication packets
• 1161 SQL-Status: 08S01 (ER_NET_WRITE_INTERRUPTED) Message: Got timeout writing communication packets
• 1162 SQL-Status: 42000 (ER_TOO_LONG_STRING) Message: Result string is longer than 'max_allowed_packet' bytes
• 1163 SQL-Status: 42000 (ER_TABLE_CANT_HANDLE_BLOB) Message: The used table type doesn't support BLOB/TEXT columns
• 1164 SQL-Status: 42000 (ER_TABLE_CANT_HANDLE_AUTO_INCREMENT) Message: The used table type doesn't support AUTO_INCREMENT columns
• 1165 SQL-Status: HY000 (ER_DELAYED_INSERT_TABLE_LOCKED) Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES
• 1166 SQL-Status: 42000 (ER_WRONG_COLUMN_NAME) Message: Incorrect column name '%s'
• 1167 SQL-Status: 42000 (ER_WRONG_KEY_COLUMN) Message: The used storage engine can't index column '%s'
• 1168 SQL-Status: HY000 (ER_WRONG_MRG_TABLE) Message: All tables in the MERGE table are not identically defined
• 1169 SQL-Status: 23000 (ER_DUP_UNIQUE) Message: Can't write, because of unique constraint, to table '%s'
• 1170 SQL-Status: 42000 (ER_BLOB_KEY_WITHOUT_LENGTH) Message: BLOB/TEXT column '%s' used in key specification without a key length
• 1171 SQL-Status: 42000 (ER_PRIMARY_CANT_HAVE_NULL) Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
• 1172 SQL-Status: 42000 (ER_TOO_MANY_ROWS) Message: Result consisted of more than one row
• 1173 SQL-Status: 42000 (ER_REQUIRES_PRIMARY_KEY) Message: This table type requires a primary key
• 1174 SQL-Status: HY000 (ER_NO_RAID_COMPILED) Message: This version of MySQL is not compiled with RAID support
• 1175 SQL-Status: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
• 1176 SQL-Status: HY000 (ER_KEY_DOES_NOT_EXITS) Message: Key '%s' doesn't exist in table '%s'
• 1177 SQL-Status: 42000 (ER_CHECK_NO_SUCH_TABLE) Message: Can't open table
• 1178 SQL-Status: 42000 (ER_CHECK_NOT_IMPLEMENTED) Message: The storage engine for the table doesn't support %s
• 1179 SQL-Status: 25000 (ER_CANT_DO_THIS_DURING_AN_TRANSACTION) Message: You are not allowed to execute this command in a transaction
• 1180 SQL-Status: HY000 (ER_ERROR_DURING_COMMIT) Message: Got error %d during COMMIT
• 1181 SQL-Status: HY000 (ER_ERROR_DURING_ROLLBACK) Message: Got error %d during ROLLBACK
• 1182 SQL-Status: HY000 (ER_ERROR_DURING_FLUSH_LOGS) Message: Got error %d during FLUSH_LOGS
• 1183 SQL-Status: HY000 (ER_ERROR_DURING_CHECKPOINT) Message: Got error %d during CHECKPOINT
• 1184 SQL-Status: 08S01 (ER_NEW_ABORTING_CONNECTION) Message: Aborted connection %ld to db: '%s' user: '%s' host: `%s' (%s)
• 1185 SQL-Status: HY000 (ER_DUMP_NOT_IMPLEMENTED) Message: The storage engine for the table does not support binary table dump
• 1186 SQL-Status: HY000 (ER_FLUSH_MASTER_BINLOG_CLOSED) Message: Binlog closed, cannot RESET MASTER
• 1187 SQL-Status: HY000 (ER_INDEX_REBUILD) Message: Failed rebuilding the index of dumped table '%s'
• 1188 SQL-Status: HY000 (ER_MASTER) Message: Error from master: '%s'
• 1189 SQL-Status: 08S01 (ER_MASTER_NET_READ) Message: Net error reading from master
• 1190 SQL-Status: 08S01 (ER_MASTER_NET_WRITE) Message: Net error writing to master
• 1191 SQL-Status: HY000 (ER_FT_MATCHING_KEY_NOT_FOUND) Message: Can't find FULLTEXT index matching the column list
• 1192 SQL-Status: HY000 (ER_LOCK_OR_ACTIVE_TRANSACTION) Message: Can't execute the given command because you have active locked tables or an active transaction
• 1193 SQL-Status: HY000 (ER_UNKNOWN_SYSTEM_VARIABLE) Message: Unknown system variable '%s'
• 1194 SQL-Status: HY000 (ER_CRASHED_ON_USAGE) Message: Table '%s' is marked as crashed and should be repaired
• 1195 SQL-Status: HY000 (ER_CRASHED_ON_REPAIR) Message: Table '%s' is marked as crashed and last (automatic?) repair failed
• 1196 SQL-Status: HY000 (ER_WARNING_NOT_COMPLETE_ROLLBACK) Message: Some non-transactional changed tables couldn't be rolled back
• 1197 SQL-Status: HY000 (ER_TRANS_CACHE_FULL) Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
• 1198 SQL-Status: HY000 (ER_SLAVE_MUST_STOP) Message: This operation cannot be performed with a running slave; run STOP SLAVE first
• 1199 SQL-Status: HY000 (ER_SLAVE_NOT_RUNNING) Message: This operation requires a running slave; configure slave and do START SLAVE
• 1200 SQL-Status: HY000 (ER_BAD_SLAVE) Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO
• 1201 SQL-Status: HY000 (ER_MASTER_INFO) Message: Could not initialize master info structure; more error messages can be found in the MySQL error log
• 1202 SQL-Status: HY000 (ER_SLAVE_THREAD) Message: Could not create slave thread; check system resources
• 1203 SQL-Status: 42000 (ER_TOO_MANY_USER_CONNECTIONS) Message: User %s has already more than 'max_user_connections' active connections
• 1204 SQL-Status: HY000 (ER_SET_CONSTANTS_ONLY) Message: You may only use constant expressions with SET
• 1205 SQL-Status: HY000 (ER_LOCK_WAIT_TIMEOUT) Message: Lock wait timeout exceeded; try restarting transaction
• 1206 SQL-Status: HY000 (ER_LOCK_TABLE_FULL) Message: The total number of locks exceeds the lock table size
• 1207 SQL-Status: 25000 (ER_READ_ONLY_TRANSACTION) Message: Update locks cannot be acquired during a READ UNCOMMITTED transaction
• 1208 SQL-Status: HY000 (ER_DROP_DB_WITH_READ_LOCK) Message: DROP DATABASE not allowed while thread is holding global read lock
• 1209 SQL-Status: HY000 (ER_CREATE_DB_WITH_READ_LOCK) Message: CREATE DATABASE not allowed while thread is holding global read lock
• 1210 SQL-Status: HY000 (ER_WRONG_ARGUMENTS) Message: Incorrect arguments to %s
• 1211 SQL-Status: 42000 (ER_NO_PERMISSION_TO_CREATE_USER) Message: '%s''%s' is not allowed to create new users
• 1212 SQL-Status: HY000 (ER_UNION_TABLES_IN_DIFFERENT_DIR) Message: Incorrect table definition; all MERGE tables must be in the same database
• 1213 SQL-Status: 40001 (ER_LOCK_DEADLOCK) Message: Deadlock found when trying to get lock; try restarting transaction
• 1214 SQL-Status: HY000 (ER_TABLE_CANT_HANDLE_FT) Message: The used table type doesn't support FULLTEXT indexes
• 1215 SQL-Status: HY000 (ER_CANNOT_ADD_FOREIGN) Message: Cannot add foreign key constraint
• 1216 SQL-Status: 23000 (ER_NO_REFERENCED_ROW) Message: Cannot add or update a child row: a foreign key constraint fails
• 1217 SQL-Status: 23000 (ER_ROW_IS_REFERENCED) Message: Cannot delete or update a parent row: a foreign key constraint fails
• 1218 SQL-Status: 08S01 (ER_CONNECT_TO_MASTER) Message: Error connecting to master: %s
• 1219 SQL-Status: HY000 (ER_QUERY_ON_MASTER) Message: Error running query on master: %s
• 1220 SQL-Status: HY000 (ER_ERROR_WHEN_EXECUTING_COMMAND) Message: Error when executing command %s: %s
• 1221 SQL-Status: HY000 (ER_WRONG_USAGE) Message: Incorrect usage of %s and %s
• 1222 SQL-Status: 21000 (ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT) Message: The used SELECT statements have a different number of columns
• 1223 SQL-Status: HY000 (ER_CANT_UPDATE_WITH_READLOCK) Message: Can't execute the query because you have a conflicting read lock
• 1224 SQL-Status: HY000 (ER_MIXING_NOT_ALLOWED) Message: Mixing of transactional and non-transactional tables is disabled
• 1225 SQL-Status: HY000 (ER_DUP_ARGUMENT) Message: Option '%s' used twice in statement
• 1226 SQL-Status: 42000 (ER_USER_LIMIT_REACHED) Message: User '%s' has exceeded the '%s' resource (current value: %ld)
• 1227 SQL-Status: HY000 (ER_SPECIFIC_ACCESS_DENIED_ERROR) Message: Access denied; you need the %s privilege for this operation
• 1228 SQL-Status: HY000 (ER_LOCAL_VARIABLE) Message: Variable '%s' is a SESSION variable and can't be used with SET GLOBAL
• 1229 SQL-Status: HY000 (ER_GLOBAL_VARIABLE) Message: Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL
• 1230 SQL-Status: 42000 (ER_NO_DEFAULT) Message: Variable '%s' doesn't have a default value
• 1231 SQL-Status: 42000 (ER_WRONG_VALUE_FOR_VAR) Message: Variable '%s' can't be set to the value of '%s'
• 1232 SQL-Status: 42000 (ER_WRONG_TYPE_FOR_VAR) Message: Incorrect argument type to variable '%s'
• 1233 SQL-Status: HY000 (ER_VAR_CANT_BE_READ) Message: Variable '%s' can only be set, not read
• 1234 SQL-Status: 42000 (ER_CANT_USE_OPTION_HERE) Message: Incorrect usage/placement of '%s'
• 1235 SQL-Status: 42000 (ER_NOT_SUPPORTED_YET) Message: This version of MySQL doesn't yet support '%s'
• 1236 SQL-Status: HY000 (ER_MASTER_FATAL_ERROR_READING_BINLOG) Message: Got fatal error %d: '%s' from master when reading data from binary log
• 1237 SQL-Status: HY000 (ER_SLAVE_IGNORED_TABLE) Message: Slave SQL thread ignored the query because of replicate-*-table rules
• 1238 SQL-Status: HY000 (ER_INCORRECT_GLOBAL_LOCAL_VAR) Message: Variable '%s' is a %s variable
• 1239 SQL-Status: 42000 (ER_WRONG_FK_DEF) Message: Incorrect foreign key definition for '%s': %s
• 1240 SQL-Status: HY000 (ER_KEY_REF_DO_NOT_MATCH_TABLE_REF) Message: Key reference and table reference don't match
• 1241 SQL-Status: 21000 (ER_OPERAND_COLUMNS) Message: Operand should contain %d column(s)
• 1242 SQL-Status: 21000 (ER_SUBQUERY_NO_1_ROW) Message: Subquery returns more than 1 row
• 1243 SQL-Status: HY000 (ER_UNKNOWN_STMT_HANDLER) Message: Unknown prepared statement handler (%.*s) given to %s
• 1244 SQL-Status: HY000 (ER_CORRUPT_HELP_DB) Message: Help database is corrupt or does not exist
• 1245 SQL-Status: HY000 (ER_CYCLIC_REFERENCE) Message: Cyclic reference on subqueries
• 1246 SQL-Status: HY000 (ER_AUTO_CONVERT) Message: Converting column '%s' from %s to %s
• 1247 SQL-Status: 42S22 (ER_ILLEGAL_REFERENCE) Message: Reference '%s' not supported (%s)
• 1248 SQL-Status: 42000 (ER_DERIVED_MUST_HAVE_ALIAS) Message: Every derived table must have its own alias
• 1249 SQL-Status: 01000 (ER_SELECT_REDUCED) Message: Select %u was reduced during optimization
• 1250 SQL-Status: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE) Message: Table '%s' from one of the SELECTs cannot be used in %s
• 1251 SQL-Status: 08004 (ER_NOT_SUPPORTED_AUTH_MODE) Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client
• 1252 SQL-Status: 42000 (ER_SPATIAL_CANT_HAVE_NULL) Message: All parts of a SPATIAL index must be NOT NULL
• 1253 SQL-Status: 42000 (ER_COLLATION_CHARSET_MISMATCH) Message: COLLATION '%s' is not valid for CHARACTER SET '%s'
• 1254 SQL-Status: HY000 (ER_SLAVE_WAS_RUNNING) Message: Slave is already running
• 1255 SQL-Status: HY000 (ER_SLAVE_WAS_NOT_RUNNING) Message: Slave has already been stopped
• 1256 SQL-Status: HY000 (ER_TOO_BIG_FOR_UNCOMPRESS) Message: Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)
• 1257 SQL-Status: HY000 (ER_ZLIB_Z_MEM_ERROR) Message: ZLIB: Not enough memory
• 1258 SQL-Status: HY000 (ER_ZLIB_Z_BUF_ERROR) Message: ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)
• 1259 SQL-Status: HY000 (ER_ZLIB_Z_DATA_ERROR) Message: ZLIB: Input data corrupted
• 1260 SQL-Status: HY000 (ER_CUT_VALUE_GROUP_CONCAT) Message: %d line(s) were cut by GROUP_CONCAT()
• 1261 SQL-Status: 01000 (ER_WARN_TOO_FEW_RECORDS) Message: Row %ld doesn't contain data for all columns
• 1262 SQL-Status: 01000 (ER_WARN_TOO_MANY_RECORDS) Message: Row %ld was truncated; it contained more data than there were input columns
• 1263 SQL-Status: 01000 (ER_WARN_NULL_TO_NOTNULL) Message: Data truncated; NULL supplied to NOT NULL column '%s' at row %ld
• 1264 SQL-Status: 01000 (ER_WARN_DATA_OUT_OF_RANGE) Message: Data truncated; out of range for column '%s' at row %ld
• 1265 SQL-Status: 01000 (ER_WARN_DATA_TRUNCATED) Message: Data truncated for column '%s' at row %ld
• 1266 SQL-Status: HY000 (ER_WARN_USING_OTHER_HANDLER) Message: Using storage engine %s for table '%s'
• 1267 SQL-Status: HY000 (ER_CANT_AGGREGATE_2COLLATIONS) Message: Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
• 1268 SQL-Status: HY000 (ER_DROP_USER) Message: Can't drop one or more of the requested users
• 1269 SQL-Status: HY000 (ER_REVOKE_GRANTS) Message: Can't revoke all privileges, grant for one or more of the requested users
• 1270 SQL-Status: HY000 (ER_CANT_AGGREGATE_3COLLATIONS) Message: Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'
• 1271 SQL-Status: HY000 (ER_CANT_AGGREGATE_NCOLLATIONS) Message: Illegal mix of collations for operation '%s'
• 1272 SQL-Status: HY000 (ER_VARIABLE_IS_NOT_STRUCT) Message: Variable '%s' is not a variable component (can't be used as XXXX.variable_name)
• 1273 SQL-Status: HY000 (ER_UNKNOWN_COLLATION) Message: Unknown collation: '%s'
• 1274 SQL-Status: HY000 (ER_SLAVE_IGNORED_SSL_PARAMS) 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
• 1275 SQL-Status: HY000 (ER_SERVER_IS_IN_SECURE_AUTH_MODE) 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
• 1276 SQL-Status: HY000 (ER_WARN_FIELD_RESOLVED) Message: Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d
• 1277 SQL-Status: HY000 (ER_BAD_SLAVE_UNTIL_COND) Message: Incorrect parameter or combination of parameters for START SLAVE UNTIL
• 1278 SQL-Status: HY000 (ER_MISSING_SKIP_SLAVE) 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
• 1279 SQL-Status: HY000 (ER_UNTIL_COND_IGNORED) Message: SQL thread is not to be started so UNTIL options are ignored
• 1280 SQL-Status: 42000 (ER_WRONG_NAME_FOR_INDEX) Message: Incorrect index name '%s'
• 1281 SQL-Status: 42000 (ER_WRONG_NAME_FOR_CATALOG) Message: Incorrect catalog name '%s'
• 1282 SQL-Status: HY000 (ER_WARN_QC_RESIZE) Message: Query cache failed to set size %lu; new query cache size is %lu
• 1283 SQL-Status: HY000 (ER_BAD_FT_COLUMN) Message: Column '%s' cannot be part of FULLTEXT index
• 1284 SQL-Status: HY000 (ER_UNKNOWN_KEY_CACHE) Message: Unknown key cache '%s'
• 1285 SQL-Status: HY000 (ER_WARN_HOSTNAME_WONT_WORK) Message: MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work
• 1286 SQL-Status: 42000 (ER_UNKNOWN_STORAGE_ENGINE) Message: Unknown table engine '%s'
• 1287 SQL-Status: HY000 (ER_WARN_DEPRECATED_SYNTAX) Message: '%s' is deprecated; use '%s' instead
• 1288 SQL-Status: HY000 (ER_NON_UPDATABLE_TABLE) Message: The target table %s of the %s is not updatable
• 1289 SQL-Status: HY000 (ER_FEATURE_DISABLED) Message: The '%s' feature is disabled; you need MySQL built with '%s' to have it working
• 1290 SQL-Status: HY000 (ER_OPTION_PREVENTS_STATEMENT) Message: The MySQL server is running with the %s option so it cannot execute this statement
• 1291 SQL-Status: HY000 (ER_DUPLICATED_VALUE_IN_TYPE) Message: Column '%s' has duplicated value '%s' in %s
• 1292 SQL-Status: HY000 (ER_TRUNCATED_WRONG_VALUE) Message: Truncated incorrect %s value: '%s'
• 1293 SQL-Status: HY000 (ER_TOO_MUCH_AUTO_TIMESTAMP_COLS) Message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
• 1294 SQL-Status: HY000 (ER_INVALID_ON_UPDATE) Message: Invalid ON UPDATE clause for '%s' column
• 1295 SQL-Status: HY000 (ER_UNSUPPORTED_PS) Message: This command is not supported in the prepared statement protocol yet
• 1296 SQL-Status: 2F003 (ER_SP_NO_RECURSIVE_CREATE) Message: Can't create a %s from within another stored routine
• 1297 SQL-Status: 42000 (ER_SP_ALREADY_EXISTS) Message: %s %s already exists
• 1298 SQL-Status: 42000 (ER_SP_DOES_NOT_EXIST) Message: %s %s does not exist
• 1299 SQL-Status: HY000 (ER_SP_DROP_FAILED) Message: Failed to DROP %s %s
• 1300 SQL-Status: HY000 (ER_SP_STORE_FAILED) Message: Failed to CREATE %s %s
• 1301 SQL-Status: 42000 (ER_SP_LILABEL_MISMATCH) Message: %s with no matching label: %s
• 1302 SQL-Status: 42000 (ER_SP_LABEL_REDEFINE) Message: Redefining label %s
• 1303 SQL-Status: 42000 (ER_SP_LABEL_MISMATCH) Message: End-label %s without match
• 1304 SQL-Status: 01000 (ER_SP_UNINIT_VAR) Message: Referring to uninitialized variable %s
• 1305 SQL-Status: 0A000 (ER_SP_BADSELECT) Message: SELECT in a stored procedure must have INTO
• 1306 SQL-Status: 42000 (ER_SP_BADRETURN) Message: RETURN is only allowed in a FUNCTION
• 1307 SQL-Status: 0A000 (ER_SP_BADSTATEMENT) Message: Statements like SELECT, INSERT, UPDATE (and others) are not allowed in a FUNCTION
• 1308 SQL-Status: 42000 (ER_UPDATE_LOG_DEPRECATED_IGNORED) Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored
• 1309 SQL-Status: 42000 (ER_UPDATE_LOG_DEPRECATED_TRANSLATED) Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN
• 1310 SQL-Status: 70100 (ER_QUERY_INTERRUPTED) Message: Query execution was interrupted
• 1311 SQL-Status: 42000 (ER_SP_WRONG_NO_OF_ARGS) Message: Incorrect number of arguments for %s %s; expected %u, got %u
• 1312 SQL-Status: 42000 (ER_SP_COND_MISMATCH) Message: Undefined CONDITION: %s
• 1313 SQL-Status: 42000 (ER_SP_NORETURN) Message: No RETURN found in FUNCTION %s
• 1314 SQL-Status: 2F005 (ER_SP_NORETURNEND) Message: FUNCTION %s ended without RETURN
• 1315 SQL-Status: 42000 (ER_SP_BAD_CURSOR_QUERY) Message: Cursor statement must be a SELECT
• 1316 SQL-Status: 42000 (ER_SP_BAD_CURSOR_SELECT) Message: Cursor SELECT must not have INTO
• 1317 SQL-Status: 42000 (ER_SP_CURSOR_MISMATCH) Message: Undefined CURSOR: %s
• 1318 SQL-Status: 24000 (ER_SP_CURSOR_ALREADY_OPEN) Message: Cursor is already open
• 1319 SQL-Status: 24000 (ER_SP_CURSOR_NOT_OPEN) Message: Cursor is not open
• 1320 SQL-Status: 42000 (ER_SP_UNDECLARED_VAR) Message: Undeclared variable: %s
• 1321 SQL-Status: HY000 (ER_SP_WRONG_NO_OF_FETCH_ARGS) Message: Incorrect number of FETCH variables
• 1322 SQL-Status: 02000 (ER_SP_FETCH_NO_DATA) Message: No data to FETCH
• 1323 SQL-Status: 42000 (ER_SP_DUP_PARAM) Message: Duplicate parameter: %s
• 1324 SQL-Status: 42000 (ER_SP_DUP_VAR) Message: Duplicate variable: %s
• 1325 SQL-Status: 42000 (ER_SP_DUP_COND) Message: Duplicate condition: %s
• 1326 SQL-Status: 42000 (ER_SP_DUP_CURS) Message: Duplicate cursor: %s
• 1327 SQL-Status: HY000 (ER_SP_CANT_ALTER) Message: Failed to ALTER %s %s
• 1328 SQL-Status: 0A000 (ER_SP_SUBSELECT_NYI) Message: Subselect value not supported
• 1329 SQL-Status: 42000 (ER_SP_NO_USE) Message: USE is not allowed in a stored procedure
• 1330 SQL-Status: 42000 (ER_SP_VARCOND_AFTER_CURSHNDLR) Message: Variable or condition declaration after cursor or handler declaration
• 1331 SQL-Status: 42000 (ER_SP_CURSOR_AFTER_HANDLER) Message: Cursor declaration after handler declaration
• 1332 SQL-Status: 20000 (ER_SP_CASE_NOT_FOUND) Message: Case not found for CASE statement
• 1333 SQL-Status: HY000 (ER_FPARSER_TOO_BIG_FILE) Message: Configuration file '%s' is too big
• 1334 SQL-Status: HY000 (ER_FPARSER_BAD_HEADER) Message: Malformed file type header in file '%s'
• 1335 SQL-Status: HY000 (ER_FPARSER_EOF_IN_COMMENT) Message: Unexpected end of file while parsing comment '%s'
• 1336 SQL-Status: HY000 (ER_FPARSER_ERROR_IN_PARAMETER) Message: Error while parsing parameter '%s' (line: '%s')
• 1337 SQL-Status: HY000 (ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER) Message: Unexpected end of file while skipping unknown parameter '%s'