MySQL Forums
Forum List  »  Stored Procedures

Re: HOW CAN I CAPTURE DE ERROR
Posted by: Claudio G
Date: April 06, 2006 02:37PM

Hi:

I have edited some lines of code from the error list that could be useful :

Part I:
/* need to be edited to change EXIT to CONTINUE when required :NOT FOUND ... */

DECLARE EXIT HANDLER FOR 1000 SELECT "HY000 (ER_HASHCHK) hashchk" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1001 SELECT "HY000 (ER_NISAMCHK) isamchk" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1002 SELECT "HY000 (ER_NO) NO" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1003 SELECT "HY000 (ER_YES) YES" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1004 SELECT "HY000 (ER_CANT_CREATE_FILE) Can't create file '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1005 SELECT "HY000 (ER_CANT_CREATE_TABLE) Can't create table '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1006 SELECT "HY000 (ER_CANT_CREATE_DB) Can't create database '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1007 SELECT "HY000 (ER_DB_CREATE_EXISTS) Can't create database '%s'; database exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1008 SELECT "HY000 (ER_DB_DROP_EXISTS) Can't drop database '%s'; database doesn't exist" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1012 SELECT "HY000 (ER_CANT_FIND_SYSTEM_REC) Can't read record in system table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1013 SELECT "HY000 (ER_CANT_GET_STAT) Can't get status of '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1014 SELECT "HY000 (ER_CANT_GET_WD) Can't get working directory (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1015 SELECT "HY000 (ER_CANT_LOCK) Can't lock file (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1016 SELECT "HY000 (ER_CANT_OPEN_FILE) Can't open fil" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1017 SELECT "HY000 (ER_FILE_NOT_FOUND) Can't find fil" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1018 SELECT "HY000 (ER_CANT_READ_DIR) Can't read dir of '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1019 SELECT "HY000 (ER_CANT_SET_WD) Can't change dir to '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1020 SELECT "HY000 (ER_CHECKREAD) Record has changed since last read in table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1021 SELECT "HY000 (ER_DISK_FULL) Disk full (%s); waiting for someone to free some space..." as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1022 SELECT "23000 (ER_DUP_KEY) Can't write; duplicate key in table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1027 SELECT "HY000 (ER_FILE_USED) '%s' is locked against change" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1028 SELECT "HY000 (ER_FILSORT_ABORT) Sort aborted" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1029 SELECT "HY000 (ER_FORM_NOT_FOUND) View '%s' doesn't exist for '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1030 SELECT "HY000 (ER_GET_ERRNO) Got error %d from storage engine" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1031 SELECT "HY000 (ER_ILLEGAL_HA) Table storage engine for '%s' doesn't have this option" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1032 SELECT "HY000 (ER_KEY_NOT_FOUND) Can't find record in '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1033 SELECT "HY000 (ER_NOT_FORM_FILE) Incorrect information in fil" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1034 SELECT "HY000 (ER_NOT_KEYFILE) Incorrect key file for table '%s'; try to repair it" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1035 SELECT "HY000 (ER_OLD_KEYFILE) Old key file for table '%s'; repair it!" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1036 SELECT "HY000 (ER_OPEN_AS_READONLY) Table '%s' is read only" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1037 SELECT "HY001 (ER_OUTOFMEMORY) Out of memory; restart server and try again (needed %d bytes)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1038 SELECT "HY001 (ER_OUT_OF_SORTMEMORY) Out of sort memory; increase server sort buffer size" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1039 SELECT "HY000 (ER_UNEXPECTED_EOF) Unexpected EOF found when reading file '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1040 SELECT "08004 (ER_CON_COUNT_ERROR) Too many connections" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1041 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1042 SELECT "08S01 (ER_BAD_HOST_ERROR) Can't get hostname for your address" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1043 SELECT "08S01 (ER_HANDSHAKE_ERROR) Bad handshake" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1044 SELECT "42000 (ER_DBACCESS_DENIED_ERROR) Access denied for user '%s'@'%s' to database '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1045 SELECT "28000 (ER_ACCESS_DENIED_ERROR) Access denied for user '%s'@'%s' (using passwor" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1046 SELECT "3D000 (ER_NO_DB_ERROR) No database selected" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1047 SELECT "08S01 (ER_UNKNOWN_COM_ERROR) Unknown command" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1048 SELECT "23000 (ER_BAD_NULL_ERROR) Column '%s' cannot be null" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1049 SELECT "42000 (ER_BAD_DB_ERROR) Unknown database '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1050 SELECT "42S01 (ER_TABLE_EXISTS_ERROR) Table '%s' already exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1051 SELECT "42S02 (ER_BAD_TABLE_ERROR) Unknown table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1052 SELECT "23000 (ER_NON_UNIQ_ERROR) Column '%s' in %s is ambiguous" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1053 SELECT "08S01 (ER_SERVER_SHUTDOWN) Server shutdown in progress" as 'ERROR_NO SQLSTATE';
/*DECLARE EXIT HANDLER FOR 1054 SELECT "42S22 (ER_BAD_FIELD_ERROR) Unknown column '%s' in '%s'" as 'ERROR_NO SQLSTATE';*/
DECLARE CONTINUE HANDLER FOR 1054 SELECT "42S22 (ER_BAD_FIELD_ERROR) Unknown column '%s' in '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1055 SELECT "42000 (ER_WRONG_FIELD_WITH_GROUP) '%s' isn't in GROUP BY" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1056 SELECT "42000 (ER_WRONG_GROUP_FIELD) Can't group on '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1057 SELECT "42000 (ER_WRONG_SUM_SELECT) Statement has sum functions and columns in same statement" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1058 SELECT "21S01 (ER_WRONG_VALUE_COUNT) Column count doesn't match value count" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1059 SELECT "42000 (ER_TOO_LONG_IDENT) Identifier name '%s' is too long" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1060 SELECT "42S21 (ER_DUP_FIELDNAME) Duplicate column name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1061 SELECT "42000 (ER_DUP_KEYNAME) Duplicate key name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1062 SELECT "23000 (ER_DUP_ENTRY) Duplicate entry '%s' for key '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1063 SELECT "42000 (ER_WRONG_FIELD_SPEC) Incorrect column specifier for column '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1064 SELECT "42000 (ER_PARSE_ERROR) %s near '%s' at line %d" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1065 SELECT "42000 (ER_EMPTY_QUERY) Query was empty" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1066 SELECT "42000 (ER_NONUNIQ_TABLE) Not unique table/alia" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1067 SELECT "42000 (ER_INVALID_DEFAULT) Invalid default value for '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1068 SELECT "42000 (ER_MULTIPLE_PRI_KEY) Multiple primary key defined" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1069 SELECT "42000 (ER_TOO_MANY_KEYS) Too many keys specified; max %d keys allowed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1070 SELECT "42000 (ER_TOO_MANY_KEY_PARTS) Too many key parts specified; max %d parts allowed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1071 SELECT "42000 (ER_TOO_LONG_KEY) Specified key was too long; max key length is %d bytes" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1072 SELECT "42000 (ER_KEY_COLUMN_DOES_NOT_EXITS) Key column '%s' doesn't exist in table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1073 SELECT "42000 (ER_BLOB_USED_AS_KEY) BLOB column '%s' can't be used in key specification with the used table type" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1074 SELECT "42000 (ER_TOO_BIG_FIELDLENGTH) Column length too big for column '%s' (max = %d); use BLOB or TEXT instead" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1075 SELECT "42000 (ER_WRONG_AUTO_KEY) Incorrect table definition; there can be only one auto column and it must be defined as a key" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1076 SELECT "HY000 (ER_READY) %" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1077 SELECT "HY000 (ER_NORMAL_SHUTDOWN) %" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1078 SELECT "HY000 (ER_GOT_SIGNAL) %" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1079 SELECT "HY000 (ER_SHUTDOWN_COMPLETE) %" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1080 SELECT "08S01 (ER_FORCING_CLOSE) %" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1081 SELECT "08S01 (ER_IPSOCK_ERROR) Can't create IP socket" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1082 SELECT "42S12 (ER_NO_SUCH_INDEX) Table '%s' has no index like the one used in CREATE INDEX; recreate the table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1083 SELECT "42000 (ER_WRONG_FIELD_TERMINATORS) Field separator argument is not what is expected; check the manual" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1084 SELECT "42000 (ER_BLOBS_AND_NO_TERMINATED) You can't use fixed rowlength with BLOBs; please use 'fields terminated by'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1085 SELECT "HY000 (ER_TEXTFILE_NOT_READABLE) The file '%s' must be in the database directory or be readable by all" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1086 SELECT "HY000 (ER_FILE_EXISTS_ERROR) File '%s' already exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1087 SELECT "HY000 (ER_LOAD_INFO) Record" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1088 SELECT "HY000 (ER_ALTER_INFO) Record" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1089 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1090 SELECT "42000 (ER_CANT_REMOVE_ALL_FIELDS) You can't delete all columns with ALTER TABLE; use DROP TABLE instead" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1091 SELECT "42000 (ER_CANT_DROP_FIELD_OR_KEY) Can't DROP '%s'; check that column/key exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1092 SELECT "HY000 (ER_INSERT_INFO) Record" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1093 SELECT "HY000 (ER_UPDATE_TABLE_USED) You can't specify target table '%s' for update in FROM clause" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1094 SELECT "HY000 (ER_NO_SUCH_THREAD) Unknown thread i" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1095 SELECT "HY000 (ER_KILL_DENIED_ERROR) You are not owner of thread %lu" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1096 SELECT "HY000 (ER_NO_TABLES_USED) No tables used" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1097 SELECT "HY000 (ER_TOO_BIG_SET) Too many strings for column %s and SET" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1098 SELECT "HY000 (ER_NO_UNIQUE_LOGFILE) Can't generate a unique log-filename %s.(1-999)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1099 SELECT "HY000 (ER_TABLE_NOT_LOCKED_FOR_WRITE) Table '%s' was locked with a READ lock and can't be updated" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1100 SELECT "HY000 (ER_TABLE_NOT_LOCKED) Table '%s' was not locked with LOCK TABLES" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1101 SELECT "42000 (ER_BLOB_CANT_HAVE_DEFAULT) BLOB/TEXT column '%s' can't have a default value" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1102 SELECT "42000 (ER_WRONG_DB_NAME) Incorrect database name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1103 SELECT "42000 (ER_WRONG_TABLE_NAME) Incorrect table name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1104 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1105 SELECT "HY000 (ER_UNKNOWN_ERROR) Unknown error" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1106 SELECT "42000 (ER_UNKNOWN_PROCEDURE) Unknown procedure '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1107 SELECT "42000 (ER_WRONG_PARAMCOUNT_TO_PROCEDURE) Incorrect parameter count to procedure '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1108 SELECT "HY000 (ER_WRONG_PARAMETERS_TO_PROCEDURE) Incorrect parameters to procedure '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1109 SELECT "42S02 (ER_UNKNOWN_TABLE) Unknown table '%s' in %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1110 SELECT "42000 (ER_FIELD_SPECIFIED_TWICE) Column '%s' specified twice" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1111 SELECT "HY000 (ER_INVALID_GROUP_FUNC_USE) Invalid use of group function" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1112 SELECT "42000 (ER_UNSUPPORTED_EXTENSION) Table '%s' uses an extension that doesn't exist in this MySQL version" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1113 SELECT "42000 (ER_TABLE_MUST_HAVE_COLUMNS) A table must have at least 1 column" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1114 SELECT "HY000 (ER_RECORD_FILE_FULL) The table '%s' is full" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1115 SELECT "42000 (ER_UNKNOWN_CHARACTER_SET) Unknown character se" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1116 SELECT "HY000 (ER_TOO_MANY_TABLES) Too many tables; MySQL can only use %d tables in a join" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1117 SELECT "HY000 (ER_TOO_MANY_FIELDS) Too many columns" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1118 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1119 SELECT "HY000 (ER_STACK_OVERRUN) Thread stack overru" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1120 SELECT "42000 (ER_WRONG_OUTER_JOIN) Cross dependency found in OUTER JOIN; examine your ON conditions" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1121 SELECT "42000 (ER_NULL_COLUMN_IN_INDEX) Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1122 SELECT "HY000 (ER_CANT_FIND_UDF) Can't load function '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1123 SELECT "HY000 (ER_CANT_INITIALIZE_UDF) Can't initialize function '%s'; %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1124 SELECT "HY000 (ER_UDF_NO_PATHS) No paths allowed for shared library" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1125 SELECT "HY000 (ER_UDF_EXISTS) Function '%s' already exists" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1126 SELECT "HY000 (ER_CANT_OPEN_LIBRARY) Can't open shared library '%s' (errn" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1127 SELECT "HY000 (ER_CANT_FIND_DL_ENTRY) Can't find symbol '%s' in library" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1128 SELECT "HY000 (ER_FUNCTION_NOT_DEFINED) Function '%s' is not defined" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1129 SELECT "HY000 (ER_HOST_IS_BLOCKED) Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1130 SELECT "HY000 (ER_HOST_NOT_PRIVILEGED) Host '%s' is not allowed to connect to this MySQL server" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1131 SELECT "42000 (ER_PASSWORD_ANONYMOUS_USER) You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1132 SELECT "42000 (ER_PASSWORD_NOT_ALLOWED) You must have privileges to update tables in the mysql database to be able to change passwords for others" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1133 SELECT "42000 (ER_PASSWORD_NO_MATCH) Can't find any matching row in the user table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1134 SELECT "HY000 (ER_UPDATE_INFO) Rows matche" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1135 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1136 SELECT "21S01 (ER_WRONG_VALUE_COUNT_ON_ROW) Column count doesn't match value count at row %ld" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1137 SELECT "HY000 (ER_CANT_REOPEN_TABLE) Can't reopen tabl" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1138 SELECT "22004 (ER_INVALID_USE_OF_NULL) Invalid use of NULL value" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1139 SELECT "42000 (ER_REGEXP_ERROR) Got error '%s' from regexp" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1140 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1141 SELECT "42000 (ER_NONEXISTING_GRANT) There is no such grant defined for user '%s' on host '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1142 SELECT "42000 (ER_TABLEACCESS_DENIED_ERROR) %s command denied to user '%s'@'%s' for table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1143 SELECT "42000 (ER_COLUMNACCESS_DENIED_ERROR) %s command denied to user '%s'@'%s' for column '%s' in table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1144 SELECT "42000 (ER_ILLEGAL_GRANT_FOR_TABLE) Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1145 SELECT "42000 (ER_GRANT_WRONG_HOST_OR_USER) The host or user argument to GRANT is too long" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1146 SELECT "42S02 (ER_NO_SUCH_TABLE) Table '%s.%s' doesn't exist" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1147 SELECT "42000 (ER_NONEXISTING_TABLE_GRANT) There is no such grant defined for user '%s' on host '%s' on table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1148 SELECT "42000 (ER_NOT_ALLOWED_COMMAND) The used command is not allowed with this MySQL version" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1149 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1150 SELECT "HY000 (ER_DELAYED_CANT_CHANGE_LOCK) Delayed insert thread couldn't get requested lock for table %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1151 SELECT "HY000 (ER_TOO_MANY_DELAYED_THREADS) Too many delayed threads in use" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1152 SELECT "08S01 (ER_ABORTING_CONNECTION) Aborted connection %ld to d" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1153 SELECT "08S01 (ER_NET_PACKET_TOO_LARGE) Got a packet bigger than 'max_allowed_packet' bytes" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1154 SELECT "08S01 (ER_NET_READ_ERROR_FROM_PIPE) Got a read error from the connection pipe" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1155 SELECT "08S01 (ER_NET_FCNTL_ERROR) Got an error from fcntl()" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1156 SELECT "08S01 (ER_NET_PACKETS_OUT_OF_ORDER) Got packets out of order" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1157 SELECT "08S01 (ER_NET_UNCOMPRESS_ERROR) Couldn't uncompress communication packet" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1158 SELECT "08S01 (ER_NET_READ_ERROR) Got an error reading communication packets" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1159 SELECT "08S01 (ER_NET_READ_INTERRUPTED) Got timeout reading communication packets" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1160 SELECT "08S01 (ER_NET_ERROR_ON_WRITE) Got an error writing communication packets" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1161 SELECT "08S01 (ER_NET_WRITE_INTERRUPTED) Got timeout writing communication packets" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1162 SELECT "42000 (ER_TOO_LONG_STRING) Result string is longer than 'max_allowed_packet' bytes" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1163 SELECT "42000 (ER_TABLE_CANT_HANDLE_BLOB) The used table type doesn't support BLOB/TEXT columns" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1164 SELECT "42000 (ER_TABLE_CANT_HANDLE_AUTO_INCREMENT) The used table type doesn't support AUTO_INCREMENT columns" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1165 SELECT "HY000 (ER_DELAYED_INSERT_TABLE_LOCKED) INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1166 SELECT "42000 (ER_WRONG_COLUMN_NAME) Incorrect column name '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1167 SELECT "42000 (ER_WRONG_KEY_COLUMN) The used storage engine can't index column '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1168 SELECT "HY000 (ER_WRONG_MRG_TABLE) All tables in the MERGE table are not identically defined" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1169 SELECT "23000 (ER_DUP_UNIQUE) Can't write, because of unique constraint, to table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1170 SELECT "42000 (ER_BLOB_KEY_WITHOUT_LENGTH) BLOB/TEXT column '%s' used in key specification without a key length" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1171 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1172 SELECT "42000 (ER_TOO_MANY_ROWS) Result consisted of more than one row" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1173 SELECT "42000 (ER_REQUIRES_PRIMARY_KEY) This table type requires a primary key" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1174 SELECT "HY000 (ER_NO_RAID_COMPILED) This version of MySQL is not compiled with RAID support" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1175 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1176 SELECT "HY000 (ER_KEY_DOES_NOT_EXITS) Key '%s' doesn't exist in table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1177 SELECT "42000 (ER_CHECK_NO_SUCH_TABLE) Can't open table" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1178 SELECT "42000 (ER_CHECK_NOT_IMPLEMENTED) The storage engine for the table doesn't support %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1179 SELECT "25000 (ER_CANT_DO_THIS_DURING_AN_TRANSACTION) You are not allowed to execute this command in a transaction" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1180 SELECT "HY000 (ER_ERROR_DURING_COMMIT) Got error %d during COMMIT" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1181 SELECT "HY000 (ER_ERROR_DURING_ROLLBACK) Got error %d during ROLLBACK" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1182 SELECT "HY000 (ER_ERROR_DURING_FLUSH_LOGS) Got error %d during FLUSH_LOGS" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1183 SELECT "HY000 (ER_ERROR_DURING_CHECKPOINT) Got error %d during CHECKPOINT" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1184 SELECT "08S01 (ER_NEW_ABORTING_CONNECTION) Aborted connection %ld to d" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1185 SELECT "HY000 (ER_DUMP_NOT_IMPLEMENTED) The storage engine for the table does not support binary table dump" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1186 SELECT "HY000 (ER_FLUSH_MASTER_BINLOG_CLOSED) Binlog closed, cannot RESET MASTER" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1187 SELECT "HY000 (ER_INDEX_REBUILD) Failed rebuilding the index of dumped table '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1189 SELECT "08S01 (ER_MASTER_NET_READ) Net error reading from master" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1190 SELECT "08S01 (ER_MASTER_NET_WRITE) Net error writing to master" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1191 SELECT "HY000 (ER_FT_MATCHING_KEY_NOT_FOUND) Can't find FULLTEXT index matching the column list" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1192 SELECT "HY000 (ER_LOCK_OR_ACTIVE_TRANSACTION) Can't execute the given command because you have active locked tables or an active transaction" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1193 SELECT "HY000 (ER_UNKNOWN_SYSTEM_VARIABLE) Unknown system variable '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1194 SELECT "HY000 (ER_CRASHED_ON_USAGE) Table '%s' is marked as crashed and should be repaired" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1195 SELECT "HY000 (ER_CRASHED_ON_REPAIR) Table '%s' is marked as crashed and last (automatic?) repair failed" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1196 SELECT "HY000 (ER_WARNING_NOT_COMPLETE_ROLLBACK) Some non-transactional changed tables couldn't be rolled back" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1197 SELECT "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" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1198 SELECT "HY000 (ER_SLAVE_MUST_STOP) This operation cannot be performed with a running slave; run STOP SLAVE first" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1199 SELECT "HY000 (ER_SLAVE_NOT_RUNNING) This operation requires a running slave; configure slave and do START SLAVE" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1200 SELECT "HY000 (ER_BAD_SLAVE) The server is not configured as slave; fix in config file or with CHANGE MASTER TO" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1201 SELECT "HY000 (ER_MASTER_INFO) Could not initialize master info structure; more error messages can be found in the MySQL error log" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1202 SELECT "HY000 (ER_SLAVE_THREAD) Could not create slave thread; check system resources" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1203 SELECT "42000 (ER_TOO_MANY_USER_CONNECTIONS) User %s already has more than 'max_user_connections' active connections" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1204 SELECT "HY000 (ER_SET_CONSTANTS_ONLY) You may only use constant expressions with SET" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1205 SELECT "HY000 (ER_LOCK_WAIT_TIMEOUT) Lock wait timeout exceeded; try restarting transaction" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1206 SELECT "HY000 (ER_LOCK_TABLE_FULL) The total number of locks exceeds the lock table size" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1207 SELECT "25000 (ER_READ_ONLY_TRANSACTION) Update locks cannot be acquired during a READ UNCOMMITTED transaction" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1208 SELECT "HY000 (ER_DROP_DB_WITH_READ_LOCK) DROP DATABASE not allowed while thread is holding global read lock" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1209 SELECT "HY000 (ER_CREATE_DB_WITH_READ_LOCK) CREATE DATABASE not allowed while thread is holding global read lock" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1210 SELECT "HY000 (ER_WRONG_ARGUMENTS) Incorrect arguments to %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1211 SELECT "42000 (ER_NO_PERMISSION_TO_CREATE_USER) '%s'@'%s' is not allowed to create new users" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1212 SELECT "HY000 (ER_UNION_TABLES_IN_DIFFERENT_DIR) Incorrect table definition; all MERGE tables must be in the same database" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1213 SELECT "40001 (ER_LOCK_DEADLOCK) Deadlock found when trying to get lock; try restarting transaction" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1214 SELECT "HY000 (ER_TABLE_CANT_HANDLE_FT) The used table type doesn't support FULLTEXT indexes" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1215 SELECT "HY000 (ER_CANNOT_ADD_FOREIGN) Cannot add foreign key constraint" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1216 SELECT "23000 (ER_NO_REFERENCED_ROW) Cannot add or update a child ro" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1217 SELECT "23000 (ER_ROW_IS_REFERENCED) Cannot delete or update a parent ro" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1221 SELECT "HY000 (ER_WRONG_USAGE) Incorrect usage of %s and %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1222 SELECT "21000 (ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT) The used SELECT statements have a different number of columns" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1223 SELECT "HY000 (ER_CANT_UPDATE_WITH_READLOCK) Can't execute the query because you have a conflicting read lock" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1224 SELECT "HY000 (ER_MIXING_NOT_ALLOWED) Mixing of transactional and non-transactional tables is disabled" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1225 SELECT "HY000 (ER_DUP_ARGUMENT) Option '%s' used twice in statement" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1226 SELECT "42000 (ER_USER_LIMIT_REACHED) User '%s' has exceeded the '%s' resource (current valu" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1227 SELECT "42000 (ER_SPECIFIC_ACCESS_DENIED_ERROR) Access denied; you need the %s privilege for this operation" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1228 SELECT "HY000 (ER_LOCAL_VARIABLE) Variable '%s' is a SESSION variable and can't be used with SET GLOBAL" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1229 SELECT "HY000 (ER_GLOBAL_VARIABLE) Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1230 SELECT "42000 (ER_NO_DEFAULT) Variable '%s' doesn't have a default value" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1231 SELECT "42000 (ER_WRONG_VALUE_FOR_VAR) Variable '%s' can't be set to the value of '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1232 SELECT "42000 (ER_WRONG_TYPE_FOR_VAR) Incorrect argument type to variable '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1233 SELECT "HY000 (ER_VAR_CANT_BE_READ) Variable '%s' can only be set, not read" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1234 SELECT "42000 (ER_CANT_USE_OPTION_HERE) Incorrect usage/placement of '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1235 SELECT "42000 (ER_NOT_SUPPORTED_YET) This version of MySQL doesn't yet support '%s'" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1236 SELECT "HY000 (ER_MASTER_FATAL_ERROR_READING_BINLOG) Got fatal error %" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1237 SELECT "HY000 (ER_SLAVE_IGNORED_TABLE) Slave SQL thread ignored the query because of replicate-*-table rules" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1238 SELECT "HY000 (ER_INCORRECT_GLOBAL_LOCAL_VAR) Variable '%s' is a %s variable" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1239 SELECT "42000 (ER_WRONG_FK_DEF) Incorrect foreign key definition for '%s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1240 SELECT "HY000 (ER_KEY_REF_DO_NOT_MATCH_TABLE_REF) Key reference and table reference don't match" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1241 SELECT "21000 (ER_OPERAND_COLUMNS) Operand should contain %d column(s)" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1242 SELECT "21000 (ER_SUBQUERY_NO_1_ROW) Subquery returns more than 1 row" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1243 SELECT "HY000 (ER_UNKNOWN_STMT_HANDLER) Unknown prepared statement handler (%.*s) given to %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1244 SELECT "HY000 (ER_CORRUPT_HELP_DB) Help database is corrupt or does not exist" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1245 SELECT "HY000 (ER_CYCLIC_REFERENCE) Cyclic reference on subqueries" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1246 SELECT "HY000 (ER_AUTO_CONVERT) Converting column '%s' from %s to %s" as 'ERROR_NO SQLSTATE';
DECLARE EXIT HANDLER FOR 1247 SELECT "42S22 (ER_ILLEGAL_REFERENCE) Reference '%s' not supported (%s)" as 'ERROR_NO SQLSTATE';

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.