List of MySQL Errors with codes

1000

SQLSTATE: HY000 (ER_HASHCHK) hashchk

1001

SQLSTATE: HY000 (ER_NISAMCHK) isamchk

1002

SQLSTATE: HY000 (ER_NO) NO

1003

SQLSTATE: HY000 (ER_YES) YES

1004

SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can’t create file ‘%s’ (errno: %d)

1005

SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Can’t create table ‘%s’ (errno: %d)

1006

SQLSTATE: HY000 (ER_CANT_CREATE_DB) Can’t create database ‘%s’ (errno: %d)

1007

SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Can’t create database ‘%s’; database exists

1008

SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Can’t drop database ‘%s’; database doesn’t exist

1009

SQLSTATE: HY000 (ER_DB_DROP_DELETE) Error dropping database (can’t delete ‘%s’, errno: %d)

1010

SQLSTATE: HY000 (ER_DB_DROP_RMDIR) Error dropping database (can’t rmdir ‘%s’, errno: %d)

1011

SQLSTATE: HY000 (ER_CANT_DELETE_FILE) Error on delete of ‘%s’ (errno: %d)

1012

SQLSTATE: HY000 (ER_CANT_FIND_SYSTEM_REC) Can’t read record in system table

1013

SQLSTATE: HY000 (ER_CANT_GET_STAT) Can’t get status of ‘%s’ (errno: %d)

1014

SQLSTATE: HY000 (ER_CANT_GET_WD) Can’t get working directory (errno: %d)

1015

SQLSTATE: HY000 (ER_CANT_LOCK) Can’t lock file (errno: %d)

1016

SQLSTATE: HY000 (ER_CANT_OPEN_FILE) Can’t open file: ‘%s’ (errno: %d)

1017

SQLSTATE: HY000 (ER_FILE_NOT_FOUND) Can’t find file: ‘%s’ (errno: %d)

1018

SQLSTATE: HY000 (ER_CANT_READ_DIR) Can’t read dir of ‘%s’ (errno: %d)

1019

SQLSTATE: HY000 (ER_CANT_SET_WD) Can’t change dir to ‘%s’ (errno: %d)

1020

SQLSTATE: HY000 (ER_CHECKREAD) Record has changed since last read in table ‘%s’

1021

SQLSTATE: HY000 (ER_DISK_FULL) Disk full (%s); waiting for someone to free some space…

1022

SQLSTATE: 23000 (ER_DUP_KEY) Can’t write; duplicate key in table ‘%s’

1023

SQLSTATE: HY000 (ER_ERROR_ON_CLOSE) Error on close of ‘%s’ (errno: %d)

1024

SQLSTATE: HY000 (ER_ERROR_ON_READ) Error reading file ‘%s’ (errno: %d)

1025

SQLSTATE: HY000 (ER_ERROR_ON_RENAME) Error on rename of ‘%s’ to ‘%s’ (errno: %d)

1026

SQLSTATE: HY000 (ER_ERROR_ON_WRITE) Error writing file ‘%s’ (errno: %d)

1027

SQLSTATE: HY000 (ER_FILE_USED) ‘%s’ is locked against change

1028

SQLSTATE: HY000 (ER_FILSORT_ABORT) Sort aborted

1029

SQLSTATE: HY000 (ER_FORM_NOT_FOUND) View ‘%s’ doesn’t exist for ‘%s’

1030

SQLSTATE: HY000 (ER_GET_ERRNO) Got error %d from storage engine

1031

SQLSTATE: HY000 (ER_ILLEGAL_HA) Table storage engine for ‘%s’ doesn’t have this option

1032

SQLSTATE: HY000 (ER_KEY_NOT_FOUND) Can’t find record in ‘%s’

1033

SQLSTATE: HY000 (ER_NOT_FORM_FILE) Incorrect information in file: ‘%s’

1034

SQLSTATE: HY000 (ER_NOT_KEYFILE) Incorrect key file for table ‘%s’; try to repair it

1035

SQLSTATE: HY000 (ER_OLD_KEYFILE) Old key file for table ‘%s’; repair it!

1036

SQLSTATE: HY000 (ER_OPEN_AS_READONLY) Table ‘%s’ is read only

1037

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

1038

SQLSTATE: HY001 (ER_OUT_OF_SORTMEMORY) Out of sort memory; increase server sort buffer size

1039

SQLSTATE: HY000 (ER_UNEXPECTED_EOF) Unexpected EOF found when reading file ‘%s’ (errno: %d)

1040

SQLSTATE: 08004 (ER_CON_COUNT_ERROR) Too many connections

1041

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

1042

SQLSTATE: 08S01 (ER_BAD_HOST_ERROR) Can’t get hostname for your address

1043

SQLSTATE: 08S01 (ER_HANDSHAKE_ERROR) Bad handshake

1044

SQLSTATE: 42000 (ER_DBACCESS_DENIED_ERROR) Access denied for user ‘%s’@’%s’ to database ‘%s’

1045

SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR) Access denied for user ‘%s’@’%s’ (using password: %s)

1046

SQLSTATE: 3D000 (ER_NO_DB_ERROR) No database selected

1047

SQLSTATE: 08S01 (ER_UNKNOWN_COM_ERROR) Unknown command

1048

SQLSTATE: 23000 (ER_BAD_NULL_ERROR) Column ‘%s’ cannot be null

1049

SQLSTATE: 42000 (ER_BAD_DB_ERROR) Unknown database ‘%s’

1050

SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR) Table ‘%s’ already exists

1051

SQLSTATE: 42S02 (ER_BAD_TABLE_ERROR) Unknown table ‘%s’

1052

SQLSTATE: 23000 (ER_NON_UNIQ_ERROR) Column ‘%s’ in %s is ambiguous

1053

SQLSTATE: 08S01 (ER_SERVER_SHUTDOWN) Server shutdown in progress

1054

SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) Unknown column ‘%s’ in ‘%s’

1055

SQLSTATE: 42000 (ER_WRONG_FIELD_WITH_GROUP) ‘%s’ isn’t in GROUP BY

1056

SQLSTATE: 42000 (ER_WRONG_GROUP_FIELD) Can’t group on ‘%s’

1057

SQLSTATE: 42000 (ER_WRONG_SUM_SELECT) Statement has sum functions and columns in same statement

1058

SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT) Column count doesn’t match value count

1059

SQLSTATE: 42000 (ER_TOO_LONG_IDENT) Identifier name ‘%s’ is too long

1060

SQLSTATE: 42S21 (ER_DUP_FIELDNAME) Duplicate column name ‘%s’

1061

SQLSTATE: 42000 (ER_DUP_KEYNAME) Duplicate key name ‘%s’

1062

SQLSTATE: 23000 (ER_DUP_ENTRY) Duplicate entry ‘%s’ for key %d

1063

SQLSTATE: 42000 (ER_WRONG_FIELD_SPEC) Incorrect column specifier for column ‘%s’

1064

SQLSTATE: 42000 (ER_PARSE_ERROR) %s near ‘%s’ at line %d

1065

SQLSTATE: HY000 (ER_EMPTY_QUERY) Query was empty

1066

SQLSTATE: 42000 (ER_NONUNIQ_TABLE) Not unique table/alias: ‘%s’

1067

SQLSTATE: 42000 (ER_INVALID_DEFAULT) Invalid default value for ‘%s’

1068

SQLSTATE: 42000 (ER_MULTIPLE_PRI_KEY) Multiple primary key defined

1069

SQLSTATE: 42000 (ER_TOO_MANY_KEYS) Too many keys specified; max %d keys allowed

1070

SQLSTATE: 42000 (ER_TOO_MANY_KEY_PARTS) Too many key parts specified; max %d parts allowed

1071

SQLSTATE: 42000 (ER_TOO_LONG_KEY) Specified key was too long; max key length is %d bytes

1072

SQLSTATE: 42000 (ER_KEY_COLUMN_DOES_NOT_EXITS) Key column ‘%s’ doesn’t exist in table

1073

SQLSTATE: 42000 (ER_BLOB_USED_AS_KEY) BLOB column ‘%s’ can’t be used in key specification with the used table type

1074

SQLSTATE: 42000 (ER_TOO_BIG_FIELDLENGTH) Column length too big for column ‘%s’ (max = %d); use BLOB instead

1075

SQLSTATE: 42000 (ER_WRONG_AUTO_KEY) Incorrect table definition; there can be only one auto column and it must be defined as a key

1076

SQLSTATE: HY000 (ER_READY) %s: ready for connections. Version: ‘%s’ socket: ‘%s’ port: %d

1077

SQLSTATE: HY000 (ER_NORMAL_SHUTDOWN) %s: Normal shutdown

1078

SQLSTATE: HY000 (ER_GOT_SIGNAL) %s: Got signal %d. Aborting!

1079

SQLSTATE: HY000 (ER_SHUTDOWN_COMPLETE) %s: Shutdown complete

1080

SQLSTATE: 08S01 (ER_FORCING_CLOSE) %s: Forcing close of thread %ld user: ‘%s’

1081

SQLSTATE: 08S01 (ER_IPSOCK_ERROR) Can’t create IP socket

1082

SQLSTATE: 42S12 (ER_NO_SUCH_INDEX) Table ‘%s’ has no index like the one used in CREATE INDEX; recreate the table

1083

SQLSTATE: 42000 (ER_WRONG_FIELD_TERMINATORS) Field separator argument is not what is expected; check the manual

1084

SQLSTATE: 42000 (ER_BLOBS_AND_NO_TERMINATED) You can’t use fixed rowlength with BLOBs; please use ‘fields terminated by’

1085

SQLSTATE: HY000 (ER_TEXTFILE_NOT_READABLE) The file ‘%s’ must be in the database directory or be readable by all

1086

SQLSTATE: HY000 (ER_FILE_EXISTS_ERROR) File ‘%s’ already exists

1087

SQLSTATE: HY000 (ER_LOAD_INFO) Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld

1088

SQLSTATE: HY000 (ER_ALTER_INFO) Records: %ld Duplicates: %ld

1089

SQLSTATE: HY000 (ER_WRONG_SUB_KEY) 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

SQLSTATE: 42000 (ER_CANT_REMOVE_ALL_FIELDS) You can’t delete all columns with ALTER TABLE; use DROP TABLE instead

1091

SQLSTATE: 42000 (ER_CANT_DROP_FIELD_OR_KEY) Can’t DROP ‘%s’; check that column/key exists

1092

SQLSTATE: HY000 (ER_INSERT_INFO) Records: %ld Duplicates: %ld Warnings: %ld

1093

SQLSTATE: HY000 (ER_UPDATE_TABLE_USED) You can’t specify target table ‘%s’ for update in FROM clause

1094

SQLSTATE: HY000 (ER_NO_SUCH_THREAD) Unknown thread id: %lu

1095

SQLSTATE: HY000 (ER_KILL_DENIED_ERROR) You are not owner of thread %lu

1096

SQLSTATE: HY000 (ER_NO_TABLES_USED) No tables used

1097

SQLSTATE: HY000 (ER_TOO_BIG_SET) Too many strings for column %s and SET

1098

SQLSTATE: HY000 (ER_NO_UNIQUE_LOGFILE) Can’t generate a unique log-filename %s.(1-999)

1099

SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED_FOR_WRITE) Table ‘%s’ was locked with a READ lock and can’t be updated

1100

SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED) Table ‘%s’ was not locked with LOCK TABLES

1101

SQLSTATE: 42000 (ER_BLOB_CANT_HAVE_DEFAULT) BLOB/TEXT column ‘%s’ can’t have a default value

1102

SQLSTATE: 42000 (ER_WRONG_DB_NAME) Incorrect database name ‘%s’

1103

SQLSTATE: 42000 (ER_WRONG_TABLE_NAME) Incorrect table name ‘%s’

1104

SQLSTATE: 42000 (ER_TOO_BIG_SELECT) 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

SQLSTATE: HY000 (ER_UNKNOWN_ERROR) Unknown error

1106

SQLSTATE: 42000 (ER_UNKNOWN_PROCEDURE) Unknown procedure ‘%s’

1107

SQLSTATE: 42000 (ER_WRONG_PARAMCOUNT_TO_PROCEDURE) Incorrect parameter count to procedure ‘%s’

1108

SQLSTATE: HY000 (ER_WRONG_PARAMETERS_TO_PROCEDURE) Incorrect parameters to procedure ‘%s’

1109

SQLSTATE: 42S02 (ER_UNKNOWN_TABLE) Unknown table ‘%s’ in %s

1110

SQLSTATE: 42000 (ER_FIELD_SPECIFIED_TWICE) Column ‘%s’ specified twice

1111

SQLSTATE: HY000 (ER_INVALID_GROUP_FUNC_USE) Invalid use of group function

1112

SQLSTATE: 42000 (ER_UNSUPPORTED_EXTENSION) Table ‘%s’ uses an extension that doesn’t exist in this MySQL version

1113

SQLSTATE: 42000 (ER_TABLE_MUST_HAVE_COLUMNS) A table must have at least 1 column

1114

SQLSTATE: HY000 (ER_RECORD_FILE_FULL) The table ‘%s’ is full

1115

SQLSTATE: 42000 (ER_UNKNOWN_CHARACTER_SET) Unknown character set: ‘%s’

1116

SQLSTATE: HY000 (ER_TOO_MANY_TABLES) Too many tables; MySQL can only use %d tables in a join

1117

SQLSTATE: HY000 (ER_TOO_MANY_FIELDS) Too many columns

1118

SQLSTATE: 42000 (ER_TOO_BIG_ROWSIZE) 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

SQLSTATE: HY000 (ER_STACK_OVERRUN) Thread stack overrun: Used: %ld of a %ld stack. Use ‘mysqld -O thread_stack=#’ to specify a bigger stack if needed

1120

SQLSTATE: 42000 (ER_WRONG_OUTER_JOIN) Cross dependency found in OUTER JOIN; examine your ON conditions

1121

SQLSTATE: 42000 (ER_NULL_COLUMN_IN_INDEX) Column ‘%s’ is used with UNIQUE or INDEX but is not defined as NOT NULL

1122

SQLSTATE: HY000 (ER_CANT_FIND_UDF) Can’t load function ‘%s’

1123

SQLSTATE: HY000 (ER_CANT_INITIALIZE_UDF) Can’t initialize function ‘%s’; %s

1124

SQLSTATE: HY000 (ER_UDF_NO_PATHS) No paths allowed for shared library

1125

SQLSTATE: HY000 (ER_UDF_EXISTS) Function ‘%s’ already exists

1126

SQLSTATE: HY000 (ER_CANT_OPEN_LIBRARY) Can’t open shared library ‘%s’ (errno: %d %s)

1127

SQLSTATE: HY000 (ER_CANT_FIND_DL_ENTRY) Can’t find function ‘%s’ in library’

1128

SQLSTATE: HY000 (ER_FUNCTION_NOT_DEFINED) Function ‘%s’ is not defined

1129

SQLSTATE: HY000 (ER_HOST_IS_BLOCKED) Host ‘%s’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

1130

SQLSTATE: HY000 (ER_HOST_NOT_PRIVILEGED) Host ‘%s’ is not allowed to connect to this MySQL server

1131

SQLSTATE: 42000 (ER_PASSWORD_ANONYMOUS_USER) You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords

1132

SQLSTATE: 42000 (ER_PASSWORD_NOT_ALLOWED) You must have privileges to update tables in the mysql database to be able to change passwords for others

1133

SQLSTATE: 42000 (ER_PASSWORD_NO_MATCH) Can’t find any matching row in the user table

1134

SQLSTATE: HY000 (ER_UPDATE_INFO) Rows matched: %ld Changed: %ld Warnings: %ld

1135

SQLSTATE: HY000 (ER_CANT_CREATE_THREAD) 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

SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT_ON_ROW) Column count doesn’t match value count at row %ld

1137

SQLSTATE: HY000 (ER_CANT_REOPEN_TABLE) Can’t reopen table: ‘%s’

1138

SQLSTATE: 42000 (ER_INVALID_USE_OF_NULL) Invalid use of NULL value

1139

SQLSTATE: 42000 (ER_REGEXP_ERROR) Got error ‘%s’ from regexp

1140

SQLSTATE: 42000 (ER_MIX_OF_GROUP_FUNC_AND_FIELDS) Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause

1141

SQLSTATE: 42000 (ER_NONEXISTING_GRANT) There is no such grant defined for user ‘%s’ on host ‘%s’

1142

SQLSTATE: 42000 (ER_TABLEACCESS_DENIED_ERROR) %s command denied to user ‘%s’@’%s’ for table ‘%s’

1143

SQLSTATE: 42000 (ER_COLUMNACCESS_DENIED_ERROR) %s command denied to user ‘%s’@’%s’ for column ‘%s’ in table ‘%s’

1144

SQLSTATE: 42000 (ER_ILLEGAL_GRANT_FOR_TABLE) Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

1145

SQLSTATE: 42000 (ER_GRANT_WRONG_HOST_OR_USER) The host or user argument to GRANT is too long

1146

SQLSTATE: 42S02 (ER_NO_SUCH_TABLE) Table ‘%s.%s’ doesn’t exist

1147

SQLSTATE: 42000 (ER_NONEXISTING_TABLE_GRANT) There is no such grant defined for user ‘%s’ on host ‘%s’ on table ‘%s’

1148

SQLSTATE: 42000 (ER_NOT_ALLOWED_COMMAND) The used command is not allowed with this MySQL version

1149

SQLSTATE: 42000 (ER_SYNTAX_ERROR) 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

SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK) Delayed insert thread couldn’t get requested lock for table %s

1151

SQLSTATE: HY000 (ER_TOO_MANY_DELAYED_THREADS) Too many delayed threads in use

1152

SQLSTATE: 08S01 (ER_ABORTING_CONNECTION) Aborted connection %ld to db: ‘%s’ user: ‘%s’ (%s)

1153

SQLSTATE: 08S01 (ER_NET_PACKET_TOO_LARGE) Got a packet bigger than ‘max_allowed_packet’ bytes

1154

SQLSTATE: 08S01 (ER_NET_READ_ERROR_FROM_PIPE) Got a read error from the connection pipe

1155

SQLSTATE: 08S01 (ER_NET_FCNTL_ERROR) Got an error from fcntl()

1156

SQLSTATE: 08S01 (ER_NET_PACKETS_OUT_OF_ORDER) Got packets out of order

1157

SQLSTATE: 08S01 (ER_NET_UNCOMPRESS_ERROR) Couldn’t uncompress communication packet

1158

SQLSTATE: 08S01 (ER_NET_READ_ERROR) Got an error reading communication packets

1159

SQLSTATE: 08S01 (ER_NET_READ_INTERRUPTED) Got timeout reading communication packets

1160

SQLSTATE: 08S01 (ER_NET_ERROR_ON_WRITE) Got an error writing communication packets

1161

SQLSTATE: 08S01 (ER_NET_WRITE_INTERRUPTED) Got timeout writing communication packets

1162

SQLSTATE: 42000 (ER_TOO_LONG_STRING) Result string is longer than ‘max_allowed_packet’ bytes

1163

SQLSTATE: 42000 (ER_TABLE_CANT_HANDLE_BLOB) The used table type doesn’t support BLOB/TEXT columns

1164

SQLSTATE: 42000 (ER_TABLE_CANT_HANDLE_AUTO_INCREMENT) The used table type doesn’t support AUTO_INCREMENT columns

1165

SQLSTATE: HY000 (ER_DELAYED_INSERT_TABLE_LOCKED) INSERT DELAYED can’t be used with table ‘%s’ because it is locked with LOCK TABLES

1166

SQLSTATE: 42000 (ER_WRONG_COLUMN_NAME) Incorrect column name ‘%s’

1167

SQLSTATE: 42000 (ER_WRONG_KEY_COLUMN) The used storage engine can’t index column ‘%s’

1168

SQLSTATE: HY000 (ER_WRONG_MRG_TABLE) All tables in the MERGE table are not identically defined

1169

SQLSTATE: 23000 (ER_DUP_UNIQUE) Can’t write, because of unique constraint, to table ‘%s’

1170

SQLSTATE: 42000 (ER_BLOB_KEY_WITHOUT_LENGTH) BLOB/TEXT column ‘%s’ used in key specification without a key length

1171

SQLSTATE: 42000 (ER_PRIMARY_CANT_HAVE_NULL) All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

1172

SQLSTATE: 42000 (ER_TOO_MANY_ROWS) Result consisted of more than one row

1173

SQLSTATE: 42000 (ER_REQUIRES_PRIMARY_KEY) This table type requires a primary key

1174

SQLSTATE: HY000 (ER_NO_RAID_COMPILED) This version of MySQL is not compiled with RAID support

1175

SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

1176

SQLSTATE: HY000 (ER_KEY_DOES_NOT_EXITS) Key ‘%s’ doesn’t exist in table ‘%s’

1177

SQLSTATE: 42000 (ER_CHECK_NO_SUCH_TABLE) Can’t open table

1178

SQLSTATE: 42000 (ER_CHECK_NOT_IMPLEMENTED) The storage engine for the table doesn’t support %s

1179

SQLSTATE: 25000 (ER_CANT_DO_THIS_DURING_AN_TRANSACTION) You are not allowed to execute this command in a transaction

1180

SQLSTATE: HY000 (ER_ERROR_DURING_COMMIT) Got error %d during COMMIT

1181

SQLSTATE: HY000 (ER_ERROR_DURING_ROLLBACK) Got error %d during ROLLBACK

1182

SQLSTATE: HY000 (ER_ERROR_DURING_FLUSH_LOGS) Got error %d during FLUSH_LOGS

1183

SQLSTATE: HY000 (ER_ERROR_DURING_CHECKPOINT) Got error %d during CHECKPOINT

1184

SQLSTATE: 08S01 (ER_NEW_ABORTING_CONNECTION) Aborted connection %ld to db: ‘%s’ user: ‘%s’ host: `%s’ (%s)

1185

SQLSTATE: HY000 (ER_DUMP_NOT_IMPLEMENTED) The storage engine for the table does not support binary table dump

1186

SQLSTATE: HY000 (ER_FLUSH_MASTER_BINLOG_CLOSED) Binlog closed, cannot RESET MASTER

1187

SQLSTATE: HY000 (ER_INDEX_REBUILD) Failed rebuilding the index of dumped table ‘%s’

1188

SQLSTATE: HY000 (ER_MASTER) Error from master: ‘%s’

1189

SQLSTATE: 08S01 (ER_MASTER_NET_READ) Net error reading from master

1190

SQLSTATE: 08S01 (ER_MASTER_NET_WRITE) Net error writing to master

1191

SQLSTATE: HY000 (ER_FT_MATCHING_KEY_NOT_FOUND) Can’t find FULLTEXT index matching the column list

1192

SQLSTATE: HY000 (ER_LOCK_OR_ACTIVE_TRANSACTION) Can’t execute the given command because you have active locked tables or an active transaction

1193

SQLSTATE: HY000 (ER_UNKNOWN_SYSTEM_VARIABLE) Unknown system variable ‘%s’

1194

SQLSTATE: HY000 (ER_CRASHED_ON_USAGE) Table ‘%s’ is marked as crashed and should be repaired

1195

SQLSTATE: HY000 (ER_CRASHED_ON_REPAIR) Table ‘%s’ is marked as crashed and last (automatic?) repair failed

1196

SQLSTATE: HY000 (ER_WARNING_NOT_COMPLETE_ROLLBACK) Some non-transactional changed tables couldn’t be rolled back

1197

SQLSTATE: HY000 (ER_TRANS_CACHE_FULL) Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage; increase this mysqld variable and try again

1198

SQLSTATE: HY000 (ER_SLAVE_MUST_STOP) This operation cannot be performed with a running slave; run STOP SLAVE first

1199

SQLSTATE: HY000 (ER_SLAVE_NOT_RUNNING) This operation requires a running slave; configure slave and do START SLAVE

1200

SQLSTATE: HY000 (ER_BAD_SLAVE) The server is not configured as slave; fix in config file or with CHANGE MASTER TO

1201

SQLSTATE: HY000 (ER_MASTER_INFO) Could not initialize master info structure; more error messages can be found in the MySQL error log

1202

SQLSTATE: HY000 (ER_SLAVE_THREAD) Could not create slave thread; check system resources

1203

SQLSTATE: 42000 (ER_TOO_MANY_USER_CONNECTIONS) User %s has already more than ‘max_user_connections’ active connections

1204

SQLSTATE: HY000 (ER_SET_CONSTANTS_ONLY) You may only use constant expressions with SET

1205

SQLSTATE: HY000 (ER_LOCK_WAIT_TIMEOUT) Lock wait timeout exceeded; try restarting transaction

1206

SQLSTATE: HY000 (ER_LOCK_TABLE_FULL) The total number of locks exceeds the lock table size

1207

SQLSTATE: 25000 (ER_READ_ONLY_TRANSACTION) Update locks cannot be acquired during a READ UNCOMMITTED transaction

1208

SQLSTATE: HY000 (ER_DROP_DB_WITH_READ_LOCK) DROP DATABASE not allowed while thread is holding global read lock

1209

SQLSTATE: HY000 (ER_CREATE_DB_WITH_READ_LOCK) CREATE DATABASE not allowed while thread is holding global read lock

1210

SQLSTATE: HY000 (ER_WRONG_ARGUMENTS) Incorrect arguments to %s

1211

SQLSTATE: 42000 (ER_NO_PERMISSION_TO_CREATE_USER) ‘%s’@’%s’ is not allowed to create new users

1212

SQLSTATE: HY000 (ER_UNION_TABLES_IN_DIFFERENT_DIR) Incorrect table definition; all MERGE tables must be in the same database

1213

SQLSTATE: 40001 (ER_LOCK_DEADLOCK) Deadlock found when trying to get lock; try restarting transaction

1214

SQLSTATE: HY000 (ER_TABLE_CANT_HANDLE_FT) The used table type doesn’t support FULLTEXT indexes

1215

SQLSTATE: HY000 (ER_CANNOT_ADD_FOREIGN) Cannot add foreign key constraint

1216

SQLSTATE: 23000 (ER_NO_REFERENCED_ROW) Cannot add or update a child row: a foreign key constraint fails

1217

SQLSTATE: 23000 (ER_ROW_IS_REFERENCED) Cannot delete or update a parent row: a foreign key constraint fails

1218

SQLSTATE: 08S01 (ER_CONNECT_TO_MASTER) Error connecting to master: %s

1219

SQLSTATE: HY000 (ER_QUERY_ON_MASTER) Error running query on master: %s

1220

SQLSTATE: HY000 (ER_ERROR_WHEN_EXECUTING_COMMAND) Error when executing command %s: %s

1221

SQLSTATE: HY000 (ER_WRONG_USAGE) Incorrect usage of %s and %s

1222

SQLSTATE: 21000 (ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT) The used SELECT statements have a different number of columns

1223

SQLSTATE: HY000 (ER_CANT_UPDATE_WITH_READLOCK) Can’t execute the query because you have a conflicting read lock

1224

SQLSTATE: HY000 (ER_MIXING_NOT_ALLOWED) Mixing of transactional and non-transactional tables is disabled

1225

SQLSTATE: HY000 (ER_DUP_ARGUMENT) Option ‘%s’ used twice in statement

1226

SQLSTATE: 42000 (ER_USER_LIMIT_REACHED) User ‘%s’ has exceeded the ‘%s’ resource (current value: %ld)

1227

SQLSTATE: HY000 (ER_SPECIFIC_ACCESS_DENIED_ERROR) Access denied; you need the %s privilege for this operation

1228

SQLSTATE: HY000 (ER_LOCAL_VARIABLE) Variable ‘%s’ is a SESSION variable and can’t be used with SET GLOBAL

1229

SQLSTATE: HY000 (ER_GLOBAL_VARIABLE) Variable ‘%s’ is a GLOBAL variable and should be set with SET GLOBAL

1230

SQLSTATE: 42000 (ER_NO_DEFAULT) Variable ‘%s’ doesn’t have a default value

1231

SQLSTATE: 42000 (ER_WRONG_VALUE_FOR_VAR) Variable ‘%s’ can’t be set to the value of ‘%s’

1232

SQLSTATE: 42000 (ER_WRONG_TYPE_FOR_VAR) Incorrect argument type to variable ‘%s’

1233

SQLSTATE: HY000 (ER_VAR_CANT_BE_READ) Variable ‘%s’ can only be set, not read

1234

SQLSTATE: 42000 (ER_CANT_USE_OPTION_HERE) Incorrect usage/placement of ‘%s’

1235

SQLSTATE: 42000 (ER_NOT_SUPPORTED_YET) This version of MySQL doesn’t yet support ‘%s’

1236

SQLSTATE: HY000 (ER_MASTER_FATAL_ERROR_READING_BINLOG) Got fatal error %d: ‘%s’ from master when reading data from binary log

1237

SQLSTATE: HY000 (ER_SLAVE_IGNORED_TABLE) Slave SQL thread ignored the query because of replicate-*-table rules

1238

SQLSTATE: HY000 (ER_INCORRECT_GLOBAL_LOCAL_VAR) Variable ‘%s’ is a %s variable

1239

SQLSTATE: 42000 (ER_WRONG_FK_DEF) Incorrect foreign key definition for ‘%s’: %s

1240

SQLSTATE: HY000 (ER_KEY_REF_DO_NOT_MATCH_TABLE_REF) Key reference and table reference don’t match

1241

SQLSTATE: 21000 (ER_OPERAND_COLUMNS) Operand should contain %d column(s)

1242

SQLSTATE: 21000 (ER_SUBQUERY_NO_1_ROW) Subquery returns more than 1 row

1243

SQLSTATE: HY000 (ER_UNKNOWN_STMT_HANDLER) Unknown prepared statement handler (%.*s) given to %s

1244

SQLSTATE: HY000 (ER_CORRUPT_HELP_DB) Help database is corrupt or does not exist

1245

SQLSTATE: HY000 (ER_CYCLIC_REFERENCE) Cyclic reference on subqueries

1246

SQLSTATE: HY000 (ER_AUTO_CONVERT) Converting column ‘%s’ from %s to %s

1247

SQLSTATE: 42S22 (ER_ILLEGAL_REFERENCE) Reference ‘%s’ not supported (%s)

1248

SQLSTATE: 42000 (ER_DERIVED_MUST_HAVE_ALIAS) Every derived table must have its own alias

1249

SQLSTATE: 01000 (ER_SELECT_REDUCED) Select %u was reduced during optimization

1250

SQLSTATE: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE) Table ‘%s’ from one of the SELECTs cannot be used in %s

1251

SQLSTATE: 08004 (ER_NOT_SUPPORTED_AUTH_MODE) Client does not support authentication protocol requested by server; consider upgrading MySQL client

1252

SQLSTATE: 42000 (ER_SPATIAL_CANT_HAVE_NULL) All parts of a SPATIAL index must be NOT NULL

1253

SQLSTATE: 42000 (ER_COLLATION_CHARSET_MISMATCH) COLLATION ‘%s’ is not valid for CHARACTER SET ‘%s’

1254

SQLSTATE: HY000 (ER_SLAVE_WAS_RUNNING) Slave is already running

1255

SQLSTATE: HY000 (ER_SLAVE_WAS_NOT_RUNNING) Slave has already been stopped

1256

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

1257

SQLSTATE: HY000 (ER_ZLIB_Z_MEM_ERROR) ZLIB: Not enough memory

1258

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

1259

SQLSTATE: HY000 (ER_ZLIB_Z_DATA_ERROR) ZLIB: Input data corrupted

1260

SQLSTATE: HY000 (ER_CUT_VALUE_GROUP_CONCAT) %d line(s) were cut by GROUP_CONCAT()

1261

SQLSTATE: 01000 (ER_WARN_TOO_FEW_RECORDS) Row %ld doesn’t contain data for all columns

1262

SQLSTATE: 01000 (ER_WARN_TOO_MANY_RECORDS) Row %ld was truncated; it contained more data than there were input columns

1263

SQLSTATE: 01000 (ER_WARN_NULL_TO_NOTNULL) Data truncated; NULL supplied to NOT NULL column ‘%s’ at row %ld

1264

SQLSTATE: 01000 (ER_WARN_DATA_OUT_OF_RANGE) Data truncated; out of range for column ‘%s’ at row %ld

1265

SQLSTATE: 01000 (ER_WARN_DATA_TRUNCATED) Data truncated for column ‘%s’ at row %ld

1266

SQLSTATE: HY000 (ER_WARN_USING_OTHER_HANDLER) Using storage engine %s for table ‘%s’

1267

SQLSTATE: HY000 (ER_CANT_AGGREGATE_2COLLATIONS) Illegal mix of collations (%s,%s) and (%s,%s) for operation ‘%s’

1268

SQLSTATE: HY000 (ER_DROP_USER) Can’t drop one or more of the requested users

1269

SQLSTATE: HY000 (ER_REVOKE_GRANTS) Can’t revoke all privileges, grant for one or more of the requested users

1270

SQLSTATE: HY000 (ER_CANT_AGGREGATE_3COLLATIONS) Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation ‘%s’

1271

SQLSTATE: HY000 (ER_CANT_AGGREGATE_NCOLLATIONS) Illegal mix of collations for operation ‘%s’

1272

SQLSTATE: HY000 (ER_VARIABLE_IS_NOT_STRUCT) Variable ‘%s’ is not a variable component (can’t be used as XXXX.variable_name)

1273

SQLSTATE: HY000 (ER_UNKNOWN_COLLATION) Unknown collation: ‘%s’

1274

SQLSTATE: HY000 (ER_SLAVE_IGNORED_SSL_PARAMS) 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

SQLSTATE: HY000 (ER_SERVER_IS_IN_SECURE_AUTH_MODE) 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

SQLSTATE: HY000 (ER_WARN_FIELD_RESOLVED) Field or reference ‘%s%s%s%s%s’ of SELECT #%d was resolved in SELECT #%d

1277

SQLSTATE: HY000 (ER_BAD_SLAVE_UNTIL_COND) Incorrect parameter or combination of parameters for START SLAVE UNTIL

1278

SQLSTATE: HY000 (ER_MISSING_SKIP_SLAVE) 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

SQLSTATE: HY000 (ER_UNTIL_COND_IGNORED) SQL thread is not to be started so UNTIL options are ignored

1280

SQLSTATE: 42000 (ER_WRONG_NAME_FOR_INDEX) Incorrect index name ‘%s’

1281

SQLSTATE: 42000 (ER_WRONG_NAME_FOR_CATALOG) Incorrect catalog name ‘%s’

1282

SQLSTATE: HY000 (ER_WARN_QC_RESIZE) Query cache failed to set size %lu; new query cache size is %lu

1283

SQLSTATE: HY000 (ER_BAD_FT_COLUMN) Column ‘%s’ cannot be part of FULLTEXT index

1284

SQLSTATE: HY000 (ER_UNKNOWN_KEY_CACHE) Unknown key cache ‘%s’

1285

SQLSTATE: HY000 (ER_WARN_HOSTNAME_WONT_WORK) MySQL is started in –skip-name-resolve mode; you must restart it without this switch for this grant to work

1286

SQLSTATE: 42000 (ER_UNKNOWN_STORAGE_ENGINE) Unknown table engine ‘%s’

1287

SQLSTATE: HY000 (ER_WARN_DEPRECATED_SYNTAX) ‘%s’ is deprecated; use ‘%s’ instead

1288

SQLSTATE: HY000 (ER_NON_UPDATABLE_TABLE) The target table %s of the %s is not updatable

1289

SQLSTATE: HY000 (ER_FEATURE_DISABLED) The ‘%s’ feature is disabled; you need MySQL built with ‘%s’ to have it working

1290

SQLSTATE: HY000 (ER_OPTION_PREVENTS_STATEMENT) The MySQL server is running with the %s option so it cannot execute this statement

1291

SQLSTATE: HY000 (ER_DUPLICATED_VALUE_IN_TYPE) Column ‘%s’ has duplicated value ‘%s’ in %s

1292

SQLSTATE: HY000 (ER_TRUNCATED_WRONG_VALUE) Truncated incorrect %s value: ‘%s’

1293

SQLSTATE: HY000 (ER_TOO_MUCH_AUTO_TIMESTAMP_COLS) Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

1294

SQLSTATE: HY000 (ER_INVALID_ON_UPDATE) Invalid ON UPDATE clause for ‘%s’ column

1295

SQLSTATE: HY000 (ER_UNSUPPORTED_PS) This command is not supported in the prepared statement protocol yet

1296

SQLSTATE: HY000 (ER_GET_ERRMSG) Got error %d ‘%s’ from %s

1297

SQLSTATE: HY000 (ER_GET_TEMPORARY_ERRMSG) Got temporary error %d ‘%s’ from %s

1298

SQLSTATE: HY000 (ER_UNKNOWN_TIME_ZONE) Unknown or incorrect time zone: ‘%s’

1299

SQLSTATE: HY000 (ER_WARN_INVALID_TIMESTAMP) Invalid TIMESTAMP value in column ‘%s’ at row %ld

1300

SQLSTATE: HY000 (ER_INVALID_CHARACTER_STRING) Invalid %s character string: ‘%s’

1301

SQLSTATE: HY000 (ER_WARN_ALLOWED_PACKET_OVERFLOWED) Result of %s() was larger than max_allowed_packet (%d) – truncated

1302

SQLSTATE: 2F003 (ER_SP_NO_RECURSIVE_CREATE) Can’t create a %s from within another stored routine

1303

SQLSTATE: 42000 (ER_SP_ALREADY_EXISTS) %s %s already exists

1304

SQLSTATE: 42000 (ER_SP_DOES_NOT_EXIST) %s %s does not exist

1305

SQLSTATE: HY000 (ER_SP_DROP_FAILED) Failed to DROP %s %s

1306

SQLSTATE: HY000 (ER_SP_STORE_FAILED) Failed to CREATE %s %s

1307

SQLSTATE: 42000 (ER_SP_LILABEL_MISMATCH) %s with no matching label: %s

1308

SQLSTATE: 42000 (ER_SP_LABEL_REDEFINE) Redefining label %s

1309

SQLSTATE: 42000 (ER_SP_LABEL_MISMATCH) End-label %s without match

1310

SQLSTATE: 01000 (ER_SP_UNINIT_VAR) Referring to uninitialized variable %s

1311

SQLSTATE: 0A000 (ER_SP_BADSELECT) SELECT in a stored procedure must have INTO

1312

SQLSTATE: 42000 (ER_SP_BADRETURN) RETURN is only allowed in a FUNCTION

1313

SQLSTATE: 0A000 (ER_SP_BADSTATEMENT) Statements like SELECT, INSERT, UPDATE (and others) are not allowed in a FUNCTION

1314

SQLSTATE: 42000 (ER_UPDATE_LOG_DEPRECATED_IGNORED) The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored

1315

SQLSTATE: 42000 (ER_UPDATE_LOG_DEPRECATED_TRANSLATED) The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN

1316

SQLSTATE: 70100 (ER_QUERY_INTERRUPTED) Query execution was interrupted

1317

SQLSTATE: 42000 (ER_SP_WRONG_NO_OF_ARGS) Incorrect number of arguments for %s %s; expected %u, got %u

1318

SQLSTATE: 42000 (ER_SP_COND_MISMATCH) Undefined CONDITION: %s

1319

SQLSTATE: 42000 (ER_SP_NORETURN) No RETURN found in FUNCTION %s

1320

SQLSTATE: 2F005 (ER_SP_NORETURNEND) FUNCTION %s ended without RETURN

1321

SQLSTATE: 42000 (ER_SP_BAD_CURSOR_QUERY) Cursor statement must be a SELECT

1322

SQLSTATE: 42000 (ER_SP_BAD_CURSOR_SELECT) Cursor SELECT must not have INTO

1323

SQLSTATE: 42000 (ER_SP_CURSOR_MISMATCH) Undefined CURSOR: %s

1324

SQLSTATE: 24000 (ER_SP_CURSOR_ALREADY_OPEN) Cursor is already open

1325

SQLSTATE: 24000 (ER_SP_CURSOR_NOT_OPEN) Cursor is not open

1326

SQLSTATE: 42000 (ER_SP_UNDECLARED_VAR) Undeclared variable: %s

1327

SQLSTATE: HY000 (ER_SP_WRONG_NO_OF_FETCH_ARGS) Incorrect number of FETCH variables

1328

SQLSTATE: 02000 (ER_SP_FETCH_NO_DATA) No data to FETCH

1329

SQLSTATE: 42000 (ER_SP_DUP_PARAM) Duplicate parameter: %s

1330

SQLSTATE: 42000 (ER_SP_DUP_VAR) Duplicate variable: %s

1331

SQLSTATE: 42000 (ER_SP_DUP_COND) Duplicate condition: %s

1332

SQLSTATE: 42000 (ER_SP_DUP_CURS) Duplicate cursor: %s

1333

SQLSTATE: HY000 (ER_SP_CANT_ALTER) Failed to ALTER %s %s

1334

SQLSTATE: 0A000 (ER_SP_SUBSELECT_NYI) Subselect value not supported

1335

SQLSTATE: 42000 (ER_SP_NO_USE) USE is not allowed in a stored procedure

1336

SQLSTATE: 42000 (ER_SP_VARCOND_AFTER_CURSHNDLR) Variable or condition declaration after cursor or handler declaration

1337

SQLSTATE: 42000 (ER_SP_CURSOR_AFTER_HANDLER) Cursor declaration after handler declaration

1338

SQLSTATE: 20000 (ER_SP_CASE_NOT_FOUND) Case not found for CASE statement

1339

SQLSTATE: HY000 (ER_FPARSER_TOO_BIG_FILE) Configuration file ‘%s’ is too big

1340

SQLSTATE: HY000 (ER_FPARSER_BAD_HEADER) Malformed file type header in file ‘%s’

1341

SQLSTATE: HY000 (ER_FPARSER_EOF_IN_COMMENT) Unexpected end of file while parsing comment ‘%s’

1342

SQLSTATE: HY000 (ER_FPARSER_ERROR_IN_PARAMETER) Error while parsing parameter ‘%s’ (line: ‘%s’)

1343

SQLSTATE: HY000 (ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER) Unexpected end of file while skipping unknown parameter ‘%s’

1344

SQLSTATE: HY000 (ER_VIEW_NO_EXPLAIN) EXPLAIN/SHOW can not be issued; lacking privileges for underlying table

1345

SQLSTATE: HY000 (ER_FRM_UNKNOWN_TYPE) File ‘%s’ has unknown type ‘%s’ in its header

1346

SQLSTATE: HY000 (ER_WRONG_OBJECT) ‘%s.%s’ is not %s

1347

SQLSTATE: HY000 (ER_NONUPDATEABLE_COLUMN) Column ‘%s’ is not updatable

1348

SQLSTATE: HY000 (ER_VIEW_SELECT_DERIVED) View’s SELECT contains a subquery in the FROM clause

1349

SQLSTATE: HY000 (ER_VIEW_SELECT_PROCEDURE) View’s SELECT contains a PROCEDURE clause

1350

SQLSTATE: HY000 (ER_VIEW_SELECT_VARIABLE) View’s SELECT contains a variable or parameter

1351

SQLSTATE: HY000 (ER_VIEW_SELECT_TMPTABLE) View’s SELECT contains a temporary table ‘%s’

1352

SQLSTATE: HY000 (ER_VIEW_WRONG_LIST) View’s SELECT and view’s field list have different column counts

1353

SQLSTATE: HY000 (ER_WARN_VIEW_MERGE) View merge algorithm can’t be used here for now (assumed undefined algorithm)

1354

SQLSTATE: HY000 (ER_WARN_VIEW_WITHOUT_KEY) View being updated does not have complete key of underlying table in it

1355

SQLSTATE: HY000 (ER_VIEW_INVALID) View ‘%s.%s’ references invalid table(s) or column(s)

1356

SQLSTATE: HY000 (ER_SP_NO_DROP_SP) Can’t drop a %s from within another stored routine

1357

SQLSTATE: HY000 (ER_SP_GOTO_IN_HNDLR) GOTO is not allowed in a stored procedure handler

2000

(CR_UNKNOWN_ERROR) Unknown MySQL error

2001

(CR_SOCKET_CREATE_ERROR) Can’t create UNIX socket (%d)

2002

(CR_CONNECTION_ERROR) Can’t connect to local MySQL server through socket ‘%s’ (%d)

2003

(CR_CONN_HOST_ERROR) Can’t connect to MySQL server on ‘%s’ (%d)

2004

(CR_IPSOCK_ERROR) Can’t create TCP/IP socket (%d)

2005

(CR_UNKNOWN_HOST) Unknown MySQL server host ‘%s’ (%d)

2006

(CR_SERVER_GONE_ERROR) MySQL server has gone away

2007

(CR_VERSION_ERROR) Protocol mismatch; server version = %d, client version = %d

2008

(CR_OUT_OF_MEMORY) MySQL client ran out of memory

2009

(CR_WRONG_HOST_INFO) Wrong host info

2010

(CR_LOCALHOST_CONNECTION) Localhost via UNIX socket

2011

(CR_TCP_CONNECTION) %s via TCP/IP

2012

(CR_SERVER_HANDSHAKE_ERR) Error in server handshake

2013

(CR_SERVER_LOST) Lost connection to MySQL server during query

2014

(CR_COMMANDS_OUT_OF_SYNC) Commands out of sync; you can’t run this command now

2015

(CR_NAMEDPIPE_CONNECTION) %s via named pipe

2016

(CR_NAMEDPIPEWAIT_ERROR) Can’t wait for named pipe to host: %s pipe: %s (%lu)

2017

(CR_NAMEDPIPEOPEN_ERROR) Can’t open named pipe to host: %s pipe: %s (%lu)

2018

(CR_NAMEDPIPESETSTATE_ERROR) Can’t set state of named pipe to host: %s pipe: %s (%lu)

2019

(CR_CANT_READ_CHARSET) Can’t initialize character set %s (path: %s)

2020

(CR_NET_PACKET_TOO_LARGE) Got packet bigger than ‘max_allowed_packet’ bytes

2021

(CR_EMBEDDED_CONNECTION) Embedded server

2022

(CR_PROBE_SLAVE_STATUS) Error on SHOW SLAVE STATUS:

2023

(CR_PROBE_SLAVE_HOSTS) Error on SHOW SLAVE HOSTS:

2024

(CR_PROBE_SLAVE_CONNECT) Error connecting to slave:

2025

(CR_PROBE_MASTER_CONNECT) Error connecting to master:

2026

(CR_SSL_CONNECTION_ERROR) SSL connection error

2027

(CR_MALFORMED_PACKET) Malformed packet

2028

(CR_WRONG_LICENSE) This client library is licensed only for use with MySQL servers having ‘%s’ license

2029

(CR_NULL_POINTER) Invalid use of null pointer

2030

(CR_NO_PREPARE_STMT) Statement not prepared

2031

(CR_PARAMS_NOT_BOUND) No data supplied for parameters in prepared statement

2032

(CR_DATA_TRUNCATED) Data truncated

2033

(CR_NO_PARAMETERS_EXISTS) No parameters exist in the statement

2034

(CR_INVALID_PARAMETER_NO) Invalid parameter number

2035

(CR_INVALID_BUFFER_USE) Can’t send long data for non-string/non-binary data types (parameter: %d)

2036

(CR_UNSUPPORTED_PARAM_TYPE) Using unsupported buffer type: %d (parameter: %d)

2037

(CR_SHARED_MEMORY_CONNECTION) Shared memory (%lu)

2038

(CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR) Can’t open shared memory; client could not create request event (%lu)

2039

(CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR) Can’t open shared memory; no answer event received from server (%lu)

2040

(CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR) Can’t open shared memory; server could not allocate file mapping (%lu)

2041

(CR_SHARED_MEMORY_CONNECT_MAP_ERROR) Can’t open shared memory; server could not get pointer to file mapping (%lu)

2042

(CR_SHARED_MEMORY_FILE_MAP_ERROR) Can’t open shared memory; client could not allocate file mapping (%lu)

2043

(CR_SHARED_MEMORY_MAP_ERROR) Can’t open shared memory; client could not get pointer to file mapping (%lu)

2044

(CR_SHARED_MEMORY_EVENT_ERROR) Can’t open shared memory; client could not create %s event (%lu)

2045

(CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR) Can’t open shared memory; no answer from server (%lu)

2046

(CR_SHARED_MEMORY_CONNECT_SET_ERROR) Can’t open shared memory; cannot send request event to server (%lu)

2047

(CR_CONN_UNKNOW_PROTOCOL) Wrong or unknown protocol

2048

(CR_INVALID_CONN_HANDLE) Invalid connection handle

2049

(CR_SECURE_AUTH) Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)

2050

(CR_FETCH_CANCELED) Row retrieval was canceled by mysql_stmt_close() call

2051

(CR_NO_DATA) Attempt to read column without prior row fetch

Author: Jay

Advertisements

Difference between div and span

The basic difference between them is ,div is block level element and span is inline level element. Most of us do not know what is block level and inline level elements.

As their name implies , block level elements make their presence like a block , like a photo frame, whereas inline element make their presence like a chain, one by one.

This can be illustrated more by HTML example. Suppose we have two divs and two spans in following orders:

<div>This is block one</div>
<div>This is block two </div>
<br />
<span>This is inline element one </span>
<span>This is inline element two </span>


div{border:1px solid #000; padding:10px;}
span{border:1px solid #000; padding:10px;}

Here is the output:

demo

You will notice that div elements are coming in a row, in other words automatic break is inserted. Whereas in case of span elements all are coming one after the other without any breaks.

    Tips:

  • Inline elements does not take margin from top and bottom unless you change them into block level element.
  • You can change inline element into block level element through CSS and vise-versa. That is :
div{display:inline}
span{display:block}

Author: Steve