MySQL 프로시져 오류구문 처리 방법

분류없음 2015.05.21 09:07

BEGIN    

-- Declare variables to hold diagnostics area information

DECLARE code CHAR(5) DEFAULT '00000';

DECLARE msg TEXT;

DECLARE rows INT;

DECLARE result TEXT;

-- Declare exception handler for failed insert

DECLARE CONTINUE HANDLER FOR SQLEXCEPTION

BEGIN

GET DIAGNOSTICS CONDITION 1

code = RETURNED_SQLSTATE, msg = MESSAGE_TEXT;

END;

DECLARE CONTINUE HANDLER FOR SQLWARNING

BEGIN

GET DIAGNOSTICS CONDITION 1

code = RETURNED_SQLSTATE, msg = MESSAGE_TEXT;

END;


-- Perform the insert


-- Check whether the insert was successful

IF code = '00000' THEN

GET DIAGNOSTICS rows = ROW_COUNT;

SET result = CONCAT('insert succeeded, row count = ',rows);

ELSE

SET result = CONCAT('insert failed, error = ',code,', message = ',msg);

END IF;

-- Say what happened

SELECT result;

END

Trackback 0 : Comment 0

DECLARE CONTINUE HANDLER FOR

분류없음 2015.05.15 17:06
https://gist.github.com/mmdemirbas/3656288

-- Declare exception handler for failed insert
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN
GET DIAGNOSTICS CONDITION 1
code = RETURNED_SQLSTATE, msg = MESSAGE_TEXT;
END;
DECLARE CONTINUE HANDLER FOR SQLWARNING
BEGIN
GET DIAGNOSTICS CONDITION 1
code = RETURNED_SQLSTATE, msg = MESSAGE_TEXT;
END;

        DECLARE CONTINUE HANDLER FOR 1000 SET code='1000', msg="hashchk";
DECLARE CONTINUE HANDLER FOR 1001 SET code='1001', msg="isamchk";
DECLARE CONTINUE HANDLER FOR 1002 SET code='1002', msg="NO";
DECLARE CONTINUE HANDLER FOR 1003 SET code='1003', msg="YES";
DECLARE CONTINUE HANDLER FOR 1004 SET code='1004', msg="Can't create file '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1005 SET code='1005', msg="Can't create table '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1006 SET code='1006', msg="Can't create database '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1007 SET code='1007', msg="Can't create database '%s'; database exists";
DECLARE CONTINUE HANDLER FOR 1008 SET code='1008', msg="Can't drop database '%s'; database doesn't exist";
DECLARE CONTINUE HANDLER FOR 1009 SET code='1009', msg="Error dropping database (can't delete '%s', errno: %d)";
DECLARE CONTINUE HANDLER FOR 1010 SET code='1010', msg="Error dropping database (can't rmdir '%s', errno: %d)";
DECLARE CONTINUE HANDLER FOR 1011 SET code='1011', msg="Error on delete of '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1012 SET code='1012', msg="Can't read record in system table";
DECLARE CONTINUE HANDLER FOR 1013 SET code='1013', msg="Can't get status of '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1014 SET code='1014', msg="Can't get working directory (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1015 SET code='1015', msg="Can't lock file (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1016 SET code='1016', msg="Can't open file: '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1017 SET code='1017', msg="Can't find file: '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1018 SET code='1018', msg="Can't read dir of '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1019 SET code='1019', msg="Can't change dir to '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1020 SET code='1020', msg="Record has changed since last read in table '%s'";
DECLARE CONTINUE HANDLER FOR 1021 SET code='1021', msg="Disk full (%s); waiting for someone to free some space...";
DECLARE CONTINUE HANDLER FOR 1022 SET code='1022', msg="Can't write; duplicate key in table '%s'";
DECLARE CONTINUE HANDLER FOR 1023 SET code='1023', msg="Error on close of '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1024 SET code='1024', msg="Error reading file '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1025 SET code='1025', msg="Error on rename of '%s' to '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1026 SET code='1026', msg="Error writing file '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1027 SET code='1027', msg="'%s' is locked against change";
DECLARE CONTINUE HANDLER FOR 1028 SET code='1028', msg="Sort aborted";
DECLARE CONTINUE HANDLER FOR 1029 SET code='1029', msg="View '%s' doesn't exist for '%s'";
DECLARE CONTINUE HANDLER FOR 1030 SET code='1030', msg="Got error %d from storage engine";
DECLARE CONTINUE HANDLER FOR 1031 SET code='1031', msg="Table storage engine for '%s' doesn't have this option";
DECLARE CONTINUE HANDLER FOR 1032 SET code='1032', msg="Can't find record in '%s'";
DECLARE CONTINUE HANDLER FOR 1033 SET code='1033', msg="Incorrect information in file: '%s'";
DECLARE CONTINUE HANDLER FOR 1034 SET code='1034', msg="Incorrect key file for table '%s'; try to repair it";
DECLARE CONTINUE HANDLER FOR 1035 SET code='1035', msg="Old key file for table '%s'; repair it!";
DECLARE CONTINUE HANDLER FOR 1036 SET code='1036', msg="Table '%s' is read only";
DECLARE CONTINUE HANDLER FOR 1037 SET code='1037', msg="Out of memory; restart server and try again (needed %d bytes)";
DECLARE CONTINUE HANDLER FOR 1038 SET code='1038', msg="Out of sort memory; increase server sort buffer size";
DECLARE CONTINUE HANDLER FOR 1039 SET code='1039', msg="Unexpected EOF found when reading file '%s' (errno: %d)";
DECLARE CONTINUE HANDLER FOR 1040 SET code='1040', msg="Too many connections";
DECLARE CONTINUE HANDLER FOR 1041 SET code='1041', msg="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";
DECLARE CONTINUE HANDLER FOR 1042 SET code='1042', msg="Can't get hostname for your address";
DECLARE CONTINUE HANDLER FOR 1043 SET code='1043', msg="Bad handshake";
DECLARE CONTINUE HANDLER FOR 1044 SET code='1044', msg="Access denied for user '%s'@'%s' to database '%s'";
DECLARE CONTINUE HANDLER FOR 1045 SET code='1045', msg="Access denied for user '%s'@'%s' (using password: %s)";
DECLARE CONTINUE HANDLER FOR 1046 SET code='1046', msg="No database selected";
DECLARE CONTINUE HANDLER FOR 1047 SET code='1047', msg="Unknown command";
DECLARE CONTINUE HANDLER FOR 1048 SET code='1048', msg="Column '%s' cannot be null";
DECLARE CONTINUE HANDLER FOR 1049 SET code='1049', msg="Unknown database '%s'";
DECLARE CONTINUE HANDLER FOR 1050 SET code='1050', msg="Table '%s' already exists";
DECLARE CONTINUE HANDLER FOR 1051 SET code='1051', msg="Unknown table '%s'";
DECLARE CONTINUE HANDLER FOR 1052 SET code='1052', msg="Column '%s' in %s is ambiguous";
DECLARE CONTINUE HANDLER FOR 1053 SET code='1053', msg="Server shutdown in progress";
DECLARE CONTINUE HANDLER FOR 1054 SET code='1054', msg="Unknown column '%s' in '%s'";
DECLARE CONTINUE HANDLER FOR 1055 SET code='1055', msg="'%s' isn't in GROUP BY";
DECLARE CONTINUE HANDLER FOR 1056 SET code='1056', msg="Can't group on '%s'";
DECLARE CONTINUE HANDLER FOR 1057 SET code='1057', msg="Statement has sum functions and columns in same statement";
DECLARE CONTINUE HANDLER FOR 1058 SET code='1058', msg="Column count doesn't match value count";
DECLARE CONTINUE HANDLER FOR 1059 SET code='1059', msg="Identifier name '%s' is too long";
DECLARE CONTINUE HANDLER FOR 1060 SET code='1060', msg="Duplicate column name '%s'";
DECLARE CONTINUE HANDLER FOR 1061 SET code='1061', msg="Duplicate key name '%s'";
DECLARE CONTINUE HANDLER FOR 1062 SET code='1062', msg="Duplicate entry '%s' for key %d";
DECLARE CONTINUE HANDLER FOR 1063 SET code='1063', msg="Incorrect column specifier for column '%s'";
DECLARE CONTINUE HANDLER FOR 1064 SET code='1064', msg="%s near '%s' at line %d";
DECLARE CONTINUE HANDLER FOR 1065 SET code='1065', msg="Query was empty";
DECLARE CONTINUE HANDLER FOR 1066 SET code='1066', msg="Not unique table/alias: '%s'";
DECLARE CONTINUE HANDLER FOR 1067 SET code='1067', msg="Invalid default value for '%s'";
DECLARE CONTINUE HANDLER FOR 1068 SET code='1068', msg="Multiple primary key defined";
DECLARE CONTINUE HANDLER FOR 1069 SET code='1069', msg="Too many keys specified; max %d keys allowed";
DECLARE CONTINUE HANDLER FOR 1070 SET code='1070', msg="Too many key parts specified; max %d parts allowed";
DECLARE CONTINUE HANDLER FOR 1071 SET code='1071', msg="Specified key was too long; max key length is %d bytes";
DECLARE CONTINUE HANDLER FOR 1072 SET code='1072', msg="Key column '%s' doesn't exist in table";
DECLARE CONTINUE HANDLER FOR 1073 SET code='1073', msg="BLOB column '%s' can't be used in key specification with the used table type";
DECLARE CONTINUE HANDLER FOR 1074 SET code='1074', msg="Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead";
DECLARE CONTINUE HANDLER FOR 1075 SET code='1075', msg="Incorrect table definition; there can be only one auto column and it must be defined as a key";
DECLARE CONTINUE HANDLER FOR 1076 SET code='1076', msg="%s: ready for connections. Version: '%s' socket: '%s' port: %d";
DECLARE CONTINUE HANDLER FOR 1077 SET code='1077', msg="%s: Normal shutdown";
DECLARE CONTINUE HANDLER FOR 1078 SET code='1078', msg="%s: Got signal %d. Aborting!";
DECLARE CONTINUE HANDLER FOR 1079 SET code='1079', msg="%s: Shutdown complete";
DECLARE CONTINUE HANDLER FOR 1080 SET code='1080', msg="%s: Forcing close of thread %ld user: '%s'";
DECLARE CONTINUE HANDLER FOR 1081 SET code='1081', msg="Can't create IP socket";
DECLARE CONTINUE HANDLER FOR 1082 SET code='1082', msg="Table '%s' has no index like the one used in CREATE INDEX; recreate the table";
DECLARE CONTINUE HANDLER FOR 1083 SET code='1083', msg="Field separator argument is not what is expected; check the manual";
DECLARE CONTINUE HANDLER FOR 1084 SET code='1084', msg="You can't use fixed rowlength with BLOBs; please use 'fields terminated by'";
DECLARE CONTINUE HANDLER FOR 1085 SET code='1085', msg="The file '%s' must be in the database directory or be readable by all";
DECLARE CONTINUE HANDLER FOR 1086 SET code='1086', msg="File '%s' already exists";
DECLARE CONTINUE HANDLER FOR 1087 SET code='1087', msg="Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld";
DECLARE CONTINUE HANDLER FOR 1088 SET code='1088', msg="Records: %ld Duplicates: %ld";
DECLARE CONTINUE HANDLER FOR 1089 SET code='1089', msg="Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys";
DECLARE CONTINUE HANDLER FOR 1090 SET code='1090', msg="You can't delete all columns with ALTER TABLE; use DROP TABLE instead";
DECLARE CONTINUE HANDLER FOR 1091 SET code='1091', msg="Can't DROP '%s'; check that column/key exists";
DECLARE CONTINUE HANDLER FOR 1092 SET code='1092', msg="Records: %ld Duplicates: %ld Warnings: %ld";
DECLARE CONTINUE HANDLER FOR 1093 SET code='1093', msg="You can't specify target table '%s' for update in FROM clause";
DECLARE CONTINUE HANDLER FOR 1094 SET code='1094', msg="Unknown thread id: %lu";
DECLARE CONTINUE HANDLER FOR 1095 SET code='1095', msg="You are not owner of thread %lu";
DECLARE CONTINUE HANDLER FOR 1096 SET code='1096', msg="No tables used";
DECLARE CONTINUE HANDLER FOR 1097 SET code='1097', msg="Too many strings for column %s and SET";
DECLARE CONTINUE HANDLER FOR 1098 SET code='1098', msg="Can't generate a unique log-filename %s.(1-999)";
DECLARE CONTINUE HANDLER FOR 1099 SET code='1099', msg="Table '%s' was locked with a READ lock and can't be updated";
DECLARE CONTINUE HANDLER FOR 1100 SET code='1100', msg="Table '%s' was not locked with LOCK TABLES";
DECLARE CONTINUE HANDLER FOR 1101 SET code='1101', msg="BLOB/TEXT column '%s' can't have a default value";
DECLARE CONTINUE HANDLER FOR 1102 SET code='1102', msg="Incorrect database name '%s'";
DECLARE CONTINUE HANDLER FOR 1103 SET code='1103', msg="Incorrect table name '%s'";
DECLARE CONTINUE HANDLER FOR 1104 SET code='1104', msg="The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZcode=# if the SELECT is okay";
DECLARE CONTINUE HANDLER FOR 1105 SET code='1105', msg="Unknown error";
DECLARE CONTINUE HANDLER FOR 1106 SET code='1106', msg="Unknown procedure '%s'";
DECLARE CONTINUE HANDLER FOR 1107 SET code='1107', msg="Incorrect parameter count to procedure '%s'";
DECLARE CONTINUE HANDLER FOR 1108 SET code='1108', msg="Incorrect parameters to procedure '%s'";
DECLARE CONTINUE HANDLER FOR 1109 SET code='1109', msg="Unknown table '%s' in %s";
DECLARE CONTINUE HANDLER FOR 1110 SET code='1110', msg="Column '%s' specified twice";
DECLARE CONTINUE HANDLER FOR 1111 SET code='1111', msg="Invalid use of group function";
DECLARE CONTINUE HANDLER FOR 1112 SET code='1112', msg="Table '%s' uses an extension that doesn't exist in this MySQL version";
DECLARE CONTINUE HANDLER FOR 1113 SET code='1113', msg="A table must have at least 1 column";
DECLARE CONTINUE HANDLER FOR 1114 SET code='1114', msg="The table '%s' is full";
DECLARE CONTINUE HANDLER FOR 1115 SET code='1115', msg="Unknown character set: '%s'";
DECLARE CONTINUE HANDLER FOR 1116 SET code='1116', msg="Too many tables; MySQL can only use %d tables in a join";
DECLARE CONTINUE HANDLER FOR 1117 SET code='1117', msg="Too many columns";
DECLARE CONTINUE HANDLER FOR 1118 SET code='1118', msg="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";
DECLARE CONTINUE HANDLER FOR 1119 SET code='1119', msg="Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed";
DECLARE CONTINUE HANDLER FOR 1120 SET code='1120', msg="Cross dependency found in OUTER JOIN; examine your ON conditions";
DECLARE CONTINUE HANDLER FOR 1121 SET code='1121', msg="Table handler doesn't support NULL in given index. Please change column '%s' to be NOT NULL or use another handler";
DECLARE CONTINUE HANDLER FOR 1122 SET code='1122', msg="Can't load function '%s'";
DECLARE CONTINUE HANDLER FOR 1123 SET code='1123', msg="Can't initialize function '%s'; %s";
DECLARE CONTINUE HANDLER FOR 1124 SET code='1124', msg="No paths allowed for shared library";
DECLARE CONTINUE HANDLER FOR 1125 SET code='1125', msg="Function '%s' already exists";
DECLARE CONTINUE HANDLER FOR 1126 SET code='1126', msg="Can't open shared library '%s' (errno: %d %s)";
DECLARE CONTINUE HANDLER FOR 1127 SET code='1127', msg="Can't find symbol '%s' in library";
DECLARE CONTINUE HANDLER FOR 1128 SET code='1128', msg="Function '%s' is not defined";
DECLARE CONTINUE HANDLER FOR 1129 SET code='1129', msg="Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'";
DECLARE CONTINUE HANDLER FOR 1130 SET code='1130', msg="Host '%s' is not allowed to connect to this MySQL server";
DECLARE CONTINUE HANDLER FOR 1131 SET code='1131', msg="You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords";
DECLARE CONTINUE HANDLER FOR 1132 SET code='1132', msg="You must have privileges to update tables in the mysql database to be able to change passwords for others";
DECLARE CONTINUE HANDLER FOR 1133 SET code='1133', msg="Can't find any matching row in the user table";
DECLARE CONTINUE HANDLER FOR 1134 SET code='1134', msg="Rows matched: %ld Changed: %ld Warnings: %ld";
DECLARE CONTINUE HANDLER FOR 1135 SET code='1135', msg="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";
DECLARE CONTINUE HANDLER FOR 1136 SET code='1136', msg="Column count doesn't match value count at row %ld";
DECLARE CONTINUE HANDLER FOR 1137 SET code='1137', msg="Can't reopen table: '%s'";
DECLARE CONTINUE HANDLER FOR 1138 SET code='1138', msg="Invalid use of NULL value";
DECLARE CONTINUE HANDLER FOR 1139 SET code='1139', msg="Got error '%s' from regexp";
DECLARE CONTINUE HANDLER FOR 1140 SET code='1140', msg="Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause";
DECLARE CONTINUE HANDLER FOR 1141 SET code='1141', msg="There is no such grant defined for user '%s' on host '%s'";
DECLARE CONTINUE HANDLER FOR 1142 SET code='1142', msg="%s command denied to user '%s'@'%s' for table '%s'";
DECLARE CONTINUE HANDLER FOR 1143 SET code='1143', msg="%s command denied to user '%s'@'%s' for column '%s' in table '%s'";
DECLARE CONTINUE HANDLER FOR 1144 SET code='1144', msg="Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used";
DECLARE CONTINUE HANDLER FOR 1145 SET code='1145', msg="The host or user argument to GRANT is too long";
DECLARE CONTINUE HANDLER FOR 1146 SET code='1146', msg="Table '%s.%s' doesn't exist";
DECLARE CONTINUE HANDLER FOR 1147 SET code='1147', msg="There is no such grant defined for user '%s' on host '%s' on table '%s'";
DECLARE CONTINUE HANDLER FOR 1148 SET code='1148', msg="The used command is not allowed with this MySQL version";
DECLARE CONTINUE HANDLER FOR 1149 SET code='1149', msg="You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use";
DECLARE CONTINUE HANDLER FOR 1150 SET code='1150', msg="Delayed insert thread couldn't get requested lock for table %s";
DECLARE CONTINUE HANDLER FOR 1151 SET code='1151', msg="Too many delayed threads in use";
DECLARE CONTINUE HANDLER FOR 1152 SET code='1152', msg="Aborted connection %ld to db: '%s' user: '%s' (%s)";
DECLARE CONTINUE HANDLER FOR 1153 SET code='1153', msg="Got a packet bigger than 'max_allowed_packet' bytes";
DECLARE CONTINUE HANDLER FOR 1154 SET code='1154', msg="Got a read error from the connection pipe";
DECLARE CONTINUE HANDLER FOR 1155 SET code='1155', msg="Got an error from fcntl()";
DECLARE CONTINUE HANDLER FOR 1156 SET code='1156', msg="Got packets out of order";
DECLARE CONTINUE HANDLER FOR 1157 SET code='1157', msg="Couldn't uncompress communication packet";
DECLARE CONTINUE HANDLER FOR 1158 SET code='1158', msg="Got an error reading communication packets";
DECLARE CONTINUE HANDLER FOR 1159 SET code='1159', msg="Got timeout reading communication packets";
DECLARE CONTINUE HANDLER FOR 1160 SET code='1160', msg="Got an error writing communication packets";
DECLARE CONTINUE HANDLER FOR 1161 SET code='1161', msg="Got timeout writing communication packets";
DECLARE CONTINUE HANDLER FOR 1162 SET code='1162', msg="Result string is longer than 'max_allowed_packet' bytes";
DECLARE CONTINUE HANDLER FOR 1163 SET code='1163', msg="The used table type doesn't support BLOB/TEXT columns";
DECLARE CONTINUE HANDLER FOR 1164 SET code='1164', msg="The used table type doesn't support AUTO_INCREMENT columns";
DECLARE CONTINUE HANDLER FOR 1165 SET code='1165', msg="INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES";
DECLARE CONTINUE HANDLER FOR 1166 SET code='1166', msg="Incorrect column name '%s'";
DECLARE CONTINUE HANDLER FOR 1167 SET code='1167', msg="The used storage engine can't index column '%s'";
DECLARE CONTINUE HANDLER FOR 1168 SET code='1168', msg="Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist";
DECLARE CONTINUE HANDLER FOR 1169 SET code='1169', msg="Can't write, because of unique constraint, to table '%s'";
DECLARE CONTINUE HANDLER FOR 1170 SET code='1170', msg="BLOB/TEXT column '%s' used in key specification without a key length";
DECLARE CONTINUE HANDLER FOR 1171 SET code='1171', msg="All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead";
DECLARE CONTINUE HANDLER FOR 1172 SET code='1172', msg="Result consisted of more than one row";
DECLARE CONTINUE HANDLER FOR 1173 SET code='1173', msg="This table type requires a primary key";
DECLARE CONTINUE HANDLER FOR 1174 SET code='1174', msg="This version of MySQL is not compiled with RAID support";
DECLARE CONTINUE HANDLER FOR 1175 SET code='1175', msg="You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column";
DECLARE CONTINUE HANDLER FOR 1176 SET code='1176', msg="Key '%s' doesn't exist in table '%s'";
DECLARE CONTINUE HANDLER FOR 1177 SET code='1177', msg="Can't open table";
DECLARE CONTINUE HANDLER FOR 1178 SET code='1178', msg="The storage engine for the table doesn't support %s";
DECLARE CONTINUE HANDLER FOR 1179 SET code='1179', msg="You are not allowed to execute this command in a transaction";
DECLARE CONTINUE HANDLER FOR 1180 SET code='1180', msg="Got error %d during COMMIT";
DECLARE CONTINUE HANDLER FOR 1181 SET code='1181', msg="Got error %d during ROLLBACK";
DECLARE CONTINUE HANDLER FOR 1182 SET code='1182', msg="Got error %d during FLUSH_LOGS";
DECLARE CONTINUE HANDLER FOR 1183 SET code='1183', msg="Got error %d during CHECKPOINT";
DECLARE CONTINUE HANDLER FOR 1184 SET code='1184', msg="Aborted connection %ld to db: '%s' user: '%s' host: '%s' (%s)";
DECLARE CONTINUE HANDLER FOR 1185 SET code='1185', msg="The storage engine for the table does not support binary table dump";
DECLARE CONTINUE HANDLER FOR 1186 SET code='1186', msg="Binlog closed, cannot RESET MASTER";
DECLARE CONTINUE HANDLER FOR 1187 SET code='1187', msg="Failed rebuilding the index of dumped table '%s'";
DECLARE CONTINUE HANDLER FOR 1188 SET code='1188', msg="Error from master: '%s'";
DECLARE CONTINUE HANDLER FOR 1189 SET code='1189', msg="Net error reading from master";
DECLARE CONTINUE HANDLER FOR 1190 SET code='1190', msg="Net error writing to master";
DECLARE CONTINUE HANDLER FOR 1191 SET code='1191', msg="Can't find FULLTEXT index matching the column list";
DECLARE CONTINUE HANDLER FOR 1192 SET code='1192', msg="Can't execute the given command because you have active locked tables or an active transaction";
DECLARE CONTINUE HANDLER FOR 1193 SET code='1193', msg="Unknown system variable '%s'";
DECLARE CONTINUE HANDLER FOR 1194 SET code='1194', msg="Table '%s' is marked as crashed and should be repaired";
DECLARE CONTINUE HANDLER FOR 1195 SET code='1195', msg="Table '%s' is marked as crashed and last (automatic?) repair failed";
DECLARE CONTINUE HANDLER FOR 1196 SET code='1196', msg="Some non-transactional changed tables couldn't be rolled back";
DECLARE CONTINUE HANDLER FOR 1197 SET code='1197', msg="Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again";
DECLARE CONTINUE HANDLER FOR 1198 SET code='1198', msg="This operation cannot be performed with a running slave; run STOP SLAVE first";
DECLARE CONTINUE HANDLER FOR 1199 SET code='1199', msg="This operation requires a running slave; configure slave and do START SLAVE";
DECLARE CONTINUE HANDLER FOR 1200 SET code='1200', msg="The server is not configured as slave; fix in config file or with CHANGE MASTER TO";
DECLARE CONTINUE HANDLER FOR 1201 SET code='1201', msg="Could not initialize master info structure; more error messages can be found in the MySQL error log";
DECLARE CONTINUE HANDLER FOR 1202 SET code='1202', msg="Could not create slave thread; check system resources";
DECLARE CONTINUE HANDLER FOR 1203 SET code='1203', msg="User %s already has more than 'max_user_connections' active connections";
DECLARE CONTINUE HANDLER FOR 1204 SET code='1204', msg="You may only use constant expressions with SET";
DECLARE CONTINUE HANDLER FOR 1205 SET code='1205', msg="Lock wait timeout exceeded; try restarting transaction";
DECLARE CONTINUE HANDLER FOR 1206 SET code='1206', msg="The total number of locks exceeds the lock table size";
DECLARE CONTINUE HANDLER FOR 1207 SET code='1207', msg="Update locks cannot be acquired during a READ UNCOMMITTED transaction";
DECLARE CONTINUE HANDLER FOR 1208 SET code='1208', msg="DROP DATABASE not allowed while thread is holding global read lock";
DECLARE CONTINUE HANDLER FOR 1209 SET code='1209', msg="CREATE DATABASE not allowed while thread is holding global read lock";
DECLARE CONTINUE HANDLER FOR 1210 SET code='1210', msg="Incorrect arguments to %s";
DECLARE CONTINUE HANDLER FOR 1211 SET code='1211', msg="'%s'@'%s' is not allowed to create new users";
DECLARE CONTINUE HANDLER FOR 1212 SET code='1212', msg="Incorrect table definition; all MERGE tables must be in the same database";
DECLARE CONTINUE HANDLER FOR 1213 SET code='1213', msg="Deadlock found when trying to get lock; try restarting transaction";
DECLARE CONTINUE HANDLER FOR 1214 SET code='1214', msg="The used table type doesn't support FULLTEXT indexes";
DECLARE CONTINUE HANDLER FOR 1215 SET code='1215', msg="Cannot add foreign key constraint";
DECLARE CONTINUE HANDLER FOR 1216 SET code='1216', msg="Cannot add or update a child row: a foreign key constraint fails";
DECLARE CONTINUE HANDLER FOR 1217 SET code='1217', msg="Cannot delete or update a parent row: a foreign key constraint fails";
DECLARE CONTINUE HANDLER FOR 1218 SET code='1218', msg="Error connecting to master: %s";
DECLARE CONTINUE HANDLER FOR 1219 SET code='1219', msg="Error running query on master: %s";
DECLARE CONTINUE HANDLER FOR 1220 SET code='1220', msg="Error when executing command %s: %s";
DECLARE CONTINUE HANDLER FOR 1221 SET code='1221', msg="Incorrect usage of %s and %s";
DECLARE CONTINUE HANDLER FOR 1222 SET code='1222', msg="The used SELECT statements have a different number of columns";
DECLARE CONTINUE HANDLER FOR 1223 SET code='1223', msg="Can't execute the query because you have a conflicting read lock";
DECLARE CONTINUE HANDLER FOR 1224 SET code='1224', msg="Mixing of transactional and non-transactional tables is disabled";
DECLARE CONTINUE HANDLER FOR 1225 SET code='1225', msg="Option '%s' used twice in statement";
DECLARE CONTINUE HANDLER FOR 1226 SET code='1226', msg="User '%s' has exceeded the '%s' resource (current value: %ld)";
DECLARE CONTINUE HANDLER FOR 1227 SET code='1227', msg="Access denied; you need the %s privilege for this operation";
DECLARE CONTINUE HANDLER FOR 1228 SET code='1228', msg="Variable '%s' is a SESSION variable and can't be used with SET GLOBAL";
DECLARE CONTINUE HANDLER FOR 1229 SET code='1229', msg="Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL";
DECLARE CONTINUE HANDLER FOR 1230 SET code='1230', msg="Variable '%s' doesn't have a default value";
DECLARE CONTINUE HANDLER FOR 1231 SET code='1231', msg="Variable '%s' can't be set to the value of '%s'";
DECLARE CONTINUE HANDLER FOR 1232 SET code='1232', msg="Incorrect argument type to variable '%s'";
DECLARE CONTINUE HANDLER FOR 1233 SET code='1233', msg="Variable '%s' can only be set, not read";
DECLARE CONTINUE HANDLER FOR 1234 SET code='1234', msg="Incorrect usage/placement of '%s'";
DECLARE CONTINUE HANDLER FOR 1235 SET code='1235', msg="This version of MySQL doesn't yet support '%s'";
DECLARE CONTINUE HANDLER FOR 1236 SET code='1236', msg="Got fatal error %d from master when reading data from binary log: '%s'";
DECLARE CONTINUE HANDLER FOR 1237 SET code='1237', msg="Slave SQL thread ignored the query because of replicate-*-table rules";
DECLARE CONTINUE HANDLER FOR 1238 SET code='1238', msg="Variable '%s' is a %s variable";
DECLARE CONTINUE HANDLER FOR 1239 SET code='1239', msg="Incorrect foreign key definition for '%s': %s";
DECLARE CONTINUE HANDLER FOR 1240 SET code='1240', msg="Key reference and table reference don't match";
DECLARE CONTINUE HANDLER FOR 1241 SET code='1241', msg="Operand should contain %d column(s)";
DECLARE CONTINUE HANDLER FOR 1242 SET code='1242', msg="Subquery returns more than 1 row";
DECLARE CONTINUE HANDLER FOR 1243 SET code='1243', msg="Unknown prepared statement handler (%.*s) given to %s";
DECLARE CONTINUE HANDLER FOR 1244 SET code='1244', msg="Help database is corrupt or does not exist";
DECLARE CONTINUE HANDLER FOR 1245 SET code='1245', msg="Cyclic reference on subqueries";
DECLARE CONTINUE HANDLER FOR 1246 SET code='1246', msg="Converting column '%s' from %s to %s";
DECLARE CONTINUE HANDLER FOR 1247 SET code='1247', msg="Reference '%s' not supported (%s)";
DECLARE CONTINUE HANDLER FOR 1248 SET code='1248', msg="Every derived table must have its own alias";
DECLARE CONTINUE HANDLER FOR 1249 SET code='1249', msg="Select %u was reduced during optimization";
DECLARE CONTINUE HANDLER FOR 1250 SET code='1250', msg="Table '%s' from one of the SELECTs cannot be used in %s";
DECLARE CONTINUE HANDLER FOR 1251 SET code='1251', msg="Client does not support authentication protocol requested by server; consider upgrading MySQL client";
DECLARE CONTINUE HANDLER FOR 1252 SET code='1252', msg="All parts of a SPATIAL index must be NOT NULL";
DECLARE CONTINUE HANDLER FOR 1253 SET code='1253', msg="COLLATION '%s' is not valid for CHARACTER SET '%s'";
DECLARE CONTINUE HANDLER FOR 1254 SET code='1254', msg="Slave is already running";
DECLARE CONTINUE HANDLER FOR 1255 SET code='1255', msg="Slave already has been stopped";
DECLARE CONTINUE HANDLER FOR 1256 SET code='1256', msg="Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)";
DECLARE CONTINUE HANDLER FOR 1257 SET code='1257', msg="ZLIB: Not enough memory";
DECLARE CONTINUE HANDLER FOR 1258 SET code='1258', msg="ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)";
DECLARE CONTINUE HANDLER FOR 1259 SET code='1259', msg="ZLIB: Input data corrupted";
DECLARE CONTINUE HANDLER FOR 1260 SET code='1260', msg="%d line(s) were cut by GROUP_CONCAT()";
DECLARE CONTINUE HANDLER FOR 1261 SET code='1261', msg="Row %ld doesn't contain data for all columns";
DECLARE CONTINUE HANDLER FOR 1262 SET code='1262', msg="Row %ld was truncated; it contained more data than there were input columns";
DECLARE CONTINUE HANDLER FOR 1263 SET code='1263', msg="Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld";
DECLARE CONTINUE HANDLER FOR 1264 SET code='1264', msg="Out of range value for column '%s' at row %ld";
DECLARE CONTINUE HANDLER FOR 1265 SET code='1265', msg="Data truncated for column '%s' at row %ld";
DECLARE CONTINUE HANDLER FOR 1266 SET code='1266', msg="Using storage engine %s for table '%s'";
DECLARE CONTINUE HANDLER FOR 1267 SET code='1267', msg="Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'";
DECLARE CONTINUE HANDLER FOR 1268 SET code='1268', msg="Cannot drop one or more of the requested users";
DECLARE CONTINUE HANDLER FOR 1269 SET code='1269', msg="Can't revoke all privileges for one or more of the requested users";
DECLARE CONTINUE HANDLER FOR 1270 SET code='1270', msg="Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'";
DECLARE CONTINUE HANDLER FOR 1271 SET code='1271', msg="Illegal mix of collations for operation '%s'";
DECLARE CONTINUE HANDLER FOR 1272 SET code='1272', msg="Variable '%s' is not a variable component (can't be used as XXXX.variable_name)";
DECLARE CONTINUE HANDLER FOR 1273 SET code='1273', msg="Unknown collation: '%s'";
DECLARE CONTINUE HANDLER FOR 1274 SET code='1274', msg="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";
DECLARE CONTINUE HANDLER FOR 1275 SET code='1275', msg="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";
DECLARE CONTINUE HANDLER FOR 1276 SET code='1276', msg="Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d";
DECLARE CONTINUE HANDLER FOR 1277 SET code='1277', msg="Incorrect parameter or combination of parameters for START SLAVE UNTIL";
DECLARE CONTINUE HANDLER FOR 1278 SET code='1278', msg="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";
DECLARE CONTINUE HANDLER FOR 1279 SET code='1279', msg="SQL thread is not to be started so UNTIL options are ignored";
DECLARE CONTINUE HANDLER FOR 1280 SET code='1280', msg="Incorrect index name '%s'";
DECLARE CONTINUE HANDLER FOR 1281 SET code='1281', msg="Incorrect catalog name '%s'";
DECLARE CONTINUE HANDLER FOR 1282 SET code='1282', msg="Query cache failed to set size %lu; new query cache size is %lu";
DECLARE CONTINUE HANDLER FOR 1283 SET code='1283', msg="Column '%s' cannot be part of FULLTEXT index";
DECLARE CONTINUE HANDLER FOR 1284 SET code='1284', msg="Unknown key cache '%s'";
DECLARE CONTINUE HANDLER FOR 1285 SET code='1285', msg="MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work";
DECLARE CONTINUE HANDLER FOR 1286 SET code='1286', msg="Unknown table engine '%s'";
DECLARE CONTINUE HANDLER FOR 1287 SET code='1287', msg="'%s' is deprecated and will be removed in a future release. Please use %s instead";
DECLARE CONTINUE HANDLER FOR 1288 SET code='1288', msg="The target table %s of the %s is not updatable";
DECLARE CONTINUE HANDLER FOR 1289 SET code='1289', msg="The '%s' feature is disabled; you need MySQL built with '%s' to have it working";
DECLARE CONTINUE HANDLER FOR 1290 SET code='1290', msg="The MySQL server is running with the %s option so it cannot execute this statement";
DECLARE CONTINUE HANDLER FOR 1291 SET code='1291', msg="Column '%s' has duplicated value '%s' in %s";
DECLARE CONTINUE HANDLER FOR 1292 SET code='1292', msg="Truncated incorrect %s value: '%s'";
DECLARE CONTINUE HANDLER FOR 1293 SET code='1293', msg="Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause";
DECLARE CONTINUE HANDLER FOR 1294 SET code='1294', msg="Invalid ON UPDATE clause for '%s' column";
DECLARE CONTINUE HANDLER FOR 1295 SET code='1295', msg="This command is not supported in the prepared statement protocol yet";
DECLARE CONTINUE HANDLER FOR 1296 SET code='1296', msg="Got error %d '%s' from %s";
DECLARE CONTINUE HANDLER FOR 1297 SET code='1297', msg="Got temporary error %d '%s' from %s";
DECLARE CONTINUE HANDLER FOR 1298 SET code='1298', msg="Unknown or incorrect time zone: '%s'";
DECLARE CONTINUE HANDLER FOR 1299 SET code='1299', msg="Invalid TIMESTAMP value in column '%s' at row %ld";
DECLARE CONTINUE HANDLER FOR 1300 SET code='1300', msg="Invalid %s character string: '%s'";
DECLARE CONTINUE HANDLER FOR 1301 SET code='1301', msg="Result of %s() was larger than max_allowed_packet (%ld) - truncated";
DECLARE CONTINUE HANDLER FOR 1302 SET code='1302', msg="Conflicting declarations: '%s%s' and '%s%s'";
DECLARE CONTINUE HANDLER FOR 1303 SET code='1303', msg="Can't create a %s from within another stored routine";
DECLARE CONTINUE HANDLER FOR 1304 SET code='1304', msg="%s %s already exists";
DECLARE CONTINUE HANDLER FOR 1305 SET code='1305', msg="%s %s does not exist";
DECLARE CONTINUE HANDLER FOR 1306 SET code='1306', msg="Failed to DROP %s %s";
DECLARE CONTINUE HANDLER FOR 1307 SET code='1307', msg="Failed to CREATE %s %s";
DECLARE CONTINUE HANDLER FOR 1308 SET code='1308', msg="%s with no matching label: %s";
DECLARE CONTINUE HANDLER FOR 1309 SET code='1309', msg="Redefining label %s";
DECLARE CONTINUE HANDLER FOR 1310 SET code='1310', msg="End-label %s without match";
DECLARE CONTINUE HANDLER FOR 1311 SET code='1311', msg="Referring to uninitialized variable %s";
DECLARE CONTINUE HANDLER FOR 1312 SET code='1312', msg="PROCEDURE %s can't return a result set in the given context";
DECLARE CONTINUE HANDLER FOR 1313 SET code='1313', msg="RETURN is only allowed in a FUNCTION";
DECLARE CONTINUE HANDLER FOR 1314 SET code='1314', msg="%s is not allowed in stored procedures";
DECLARE CONTINUE HANDLER FOR 1315 SET code='1315', msg="The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.";
DECLARE CONTINUE HANDLER FOR 1316 SET code='1316', msg="The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN. This option will be removed in MySQL 5.6.";
DECLARE CONTINUE HANDLER FOR 1317 SET code='1317', msg="Query execution was interrupted";
DECLARE CONTINUE HANDLER FOR 1318 SET code='1318', msg="Incorrect number of arguments for %s %s; expected %u, got %u";
DECLARE CONTINUE HANDLER FOR 1319 SET code='1319', msg="Undefined CONDITION: %s";
DECLARE CONTINUE HANDLER FOR 1320 SET code='1320', msg="No RETURN found in FUNCTION %s";
DECLARE CONTINUE HANDLER FOR 1321 SET code='1321', msg="FUNCTION %s ended without RETURN";
DECLARE CONTINUE HANDLER FOR 1322 SET code='1322', msg="Cursor statement must be a SELECT";
DECLARE CONTINUE HANDLER FOR 1323 SET code='1323', msg="Cursor SELECT must not have INTO";
DECLARE CONTINUE HANDLER FOR 1324 SET code='1324', msg="Undefined CURSOR: %s";
DECLARE CONTINUE HANDLER FOR 1325 SET code='1325', msg="Cursor is already open";
DECLARE CONTINUE HANDLER FOR 1326 SET code='1326', msg="Cursor is not open";
DECLARE CONTINUE HANDLER FOR 1327 SET code='1327', msg="Undeclared variable: %s";
DECLARE CONTINUE HANDLER FOR 1328 SET code='1328', msg="Incorrect number of FETCH variables";
DECLARE CONTINUE HANDLER FOR 1329 SET code='1329', msg="No data - zero rows fetched, selected, or processed";
DECLARE CONTINUE HANDLER FOR 1330 SET code='1330', msg="Duplicate parameter: %s";
DECLARE CONTINUE HANDLER FOR 1331 SET code='1331', msg="Duplicate variable: %s";
DECLARE CONTINUE HANDLER FOR 1332 SET code='1332', msg="Duplicate condition: %s";
DECLARE CONTINUE HANDLER FOR 1333 SET code='1333', msg="Duplicate cursor: %s";
DECLARE CONTINUE HANDLER FOR 1334 SET code='1334', msg="Failed to ALTER %s %s";
DECLARE CONTINUE HANDLER FOR 1335 SET code='1335', msg="Subquery value not supported";
DECLARE CONTINUE HANDLER FOR 1336 SET code='1336', msg="%s is not allowed in stored function or trigger";
DECLARE CONTINUE HANDLER FOR 1337 SET code='1337', msg="Variable or condition declaration after cursor or handler declaration";
DECLARE CONTINUE HANDLER FOR 1338 SET code='1338', msg="Cursor declaration after handler declaration";
DECLARE CONTINUE HANDLER FOR 1339 SET code='1339', msg="Case not found for CASE statement";
DECLARE CONTINUE HANDLER FOR 1340 SET code='1340', msg="Configuration file '%s' is too big";
DECLARE CONTINUE HANDLER FOR 1341 SET code='1341', msg="Malformed file type header in file '%s'";
DECLARE CONTINUE HANDLER FOR 1342 SET code='1342', msg="Unexpected end of file while parsing comment '%s'";
DECLARE CONTINUE HANDLER FOR 1343 SET code='1343', msg="Error while parsing parameter '%s' (line: '%s')";
DECLARE CONTINUE HANDLER FOR 1344 SET code='1344', msg="Unexpected end of file while skipping unknown parameter '%s'";
DECLARE CONTINUE HANDLER FOR 1345 SET code='1345', msg="EXPLAIN/SHOW can not be issued; lacking privileges for underlying table";
DECLARE CONTINUE HANDLER FOR 1346 SET code='1346', msg="File '%s' has unknown type '%s' in its header";
DECLARE CONTINUE HANDLER FOR 1347 SET code='1347', msg="'%s.%s' is not %s";
DECLARE CONTINUE HANDLER FOR 1348 SET code='1348', msg="Column '%s' is not updatable";
DECLARE CONTINUE HANDLER FOR 1349 SET code='1349', msg="View's SELECT contains a subquery in the FROM clause";
DECLARE CONTINUE HANDLER FOR 1350 SET code='1350', msg="View's SELECT contains a '%s' clause";
DECLARE CONTINUE HANDLER FOR 1351 SET code='1351', msg="View's SELECT contains a variable or parameter";
DECLARE CONTINUE HANDLER FOR 1352 SET code='1352', msg="View's SELECT refers to a temporary table '%s'";
DECLARE CONTINUE HANDLER FOR 1353 SET code='1353', msg="View's SELECT and view's field list have different column counts";
DECLARE CONTINUE HANDLER FOR 1354 SET code='1354', msg="View merge algorithm can't be used here for now (assumed undefined algorithm)";
DECLARE CONTINUE HANDLER FOR 1355 SET code='1355', msg="View being updated does not have complete key of underlying table in it";
DECLARE CONTINUE HANDLER FOR 1356 SET code='1356', msg="View '%s.%s' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them";
DECLARE CONTINUE HANDLER FOR 1357 SET code='1357', msg="Can't drop or alter a %s from within another stored routine";
DECLARE CONTINUE HANDLER FOR 1358 SET code='1358', msg="GOTO is not allowed in a stored procedure handler";
DECLARE CONTINUE HANDLER FOR 1359 SET code='1359', msg="Trigger already exists";
DECLARE CONTINUE HANDLER FOR 1360 SET code='1360', msg="Trigger does not exist";
DECLARE CONTINUE HANDLER FOR 1361 SET code='1361', msg="Trigger's '%s' is view or temporary table";
DECLARE CONTINUE HANDLER FOR 1362 SET code='1362', msg="Updating of %s row is not allowed in %strigger";
DECLARE CONTINUE HANDLER FOR 1363 SET code='1363', msg="There is no %s row in %s trigger";
DECLARE CONTINUE HANDLER FOR 1364 SET code='1364', msg="Field '%s' doesn't have a default value";
DECLARE CONTINUE HANDLER FOR 1365 SET code='1365', msg="Division by 0";
DECLARE CONTINUE HANDLER FOR 1366 SET code='1366', msg="Incorrect %s value: '%s' for column '%s' at row %ld";
DECLARE CONTINUE HANDLER FOR 1367 SET code='1367', msg="Illegal %s '%s' value found during parsing";
DECLARE CONTINUE HANDLER FOR 1368 SET code='1368', msg="CHECK OPTION on non-updatable view '%s.%s'";
DECLARE CONTINUE HANDLER FOR 1369 SET code='1369', msg="CHECK OPTION failed '%s.%s'";
DECLARE CONTINUE HANDLER FOR 1370 SET code='1370', msg="%s command denied to user '%s'@'%s' for routine '%s'";
DECLARE CONTINUE HANDLER FOR 1371 SET code='1371', msg="Failed purging old relay logs: %s";
DECLARE CONTINUE HANDLER FOR 1372 SET code='1372', msg="Password hash should be a %d-digit hexadecimal number";
DECLARE CONTINUE HANDLER FOR 1373 SET code='1373', msg="Target log not found in binlog index";
DECLARE CONTINUE HANDLER FOR 1374 SET code='1374', msg="I/O error reading log index file";
DECLARE CONTINUE HANDLER FOR 1375 SET code='1375', msg="Server configuration does not permit binlog purge";
DECLARE CONTINUE HANDLER FOR 1376 SET code='1376', msg="Failed on fseek()";
DECLARE CONTINUE HANDLER FOR 1377 SET code='1377', msg="Fatal error during log purge";
DECLARE CONTINUE HANDLER FOR 1378 SET code='1378', msg="A purgeable log is in use, will not purge";
DECLARE CONTINUE HANDLER FOR 1379 SET code='1379', msg="Unknown error during log purge";
DECLARE CONTINUE HANDLER FOR 1380 SET code='1380', msg="Failed initializing relay log position: %s";
DECLARE CONTINUE HANDLER FOR 1381 SET code='1381', msg="You are not using binary logging";
DECLARE CONTINUE HANDLER FOR 1382 SET code='1382', msg="The '%s' syntax is reserved for purposes internal to the MySQL server";
DECLARE CONTINUE HANDLER FOR 1383 SET code='1383', msg="WSAStartup Failed";
DECLARE CONTINUE HANDLER FOR 1384 SET code='1384', msg="Can't handle procedures with different groups yet";
DECLARE CONTINUE HANDLER FOR 1385 SET code='1385', msg="Select must have a group with this procedure";
DECLARE CONTINUE HANDLER FOR 1386 SET code='1386', msg="Can't use ORDER clause with this procedure";
DECLARE CONTINUE HANDLER FOR 1387 SET code='1387', msg="Binary logging and replication forbid changing the global server %s";
DECLARE CONTINUE HANDLER FOR 1388 SET code='1388', msg="Can't map file: %s, errno: %d";
DECLARE CONTINUE HANDLER FOR 1389 SET code='1389', msg="Wrong magic in %s";
DECLARE CONTINUE HANDLER FOR 1390 SET code='1390', msg="Prepared statement contains too many placeholders";
DECLARE CONTINUE HANDLER FOR 1391 SET code='1391', msg="Key part '%s' length cannot be 0";
DECLARE CONTINUE HANDLER FOR 1392 SET code='1392', msg="View text checksum failed";
DECLARE CONTINUE HANDLER FOR 1393 SET code='1393', msg="Can not modify more than one base table through a join view '%s.%s'";
DECLARE CONTINUE HANDLER FOR 1394 SET code='1394', msg="Can not insert into join view '%s.%s' without fields list";
DECLARE CONTINUE HANDLER FOR 1395 SET code='1395', msg="Can not delete from join view '%s.%s'";
DECLARE CONTINUE HANDLER FOR 1396 SET code='1396', msg="Operation %s failed for %s";
DECLARE CONTINUE HANDLER FOR 1397 SET code='1397', msg="XAER_NOTA: Unknown XID";
DECLARE CONTINUE HANDLER FOR 1398 SET code='1398', msg="XAER_INVAL: Invalid arguments (or unsupported command)";
DECLARE CONTINUE HANDLER FOR 1399 SET code='1399', msg="XAER_RMFAIL: The command cannot be executed when global transaction is in the %s state";
DECLARE CONTINUE HANDLER FOR 1400 SET code='1400', msg="XAER_OUTSIDE: Some work is done outside global transaction";
DECLARE CONTINUE HANDLER FOR 1401 SET code='1401', msg="XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency";
DECLARE CONTINUE HANDLER FOR 1402 SET code='1402', msg="XA_RBROLLBACK: Transaction branch was rolled back";
DECLARE CONTINUE HANDLER FOR 1403 SET code='1403', msg="There is no such grant defined for user '%s' on host '%s' on routine '%s'";
DECLARE CONTINUE HANDLER FOR 1404 SET code='1404', msg="Failed to grant EXECUTE and ALTER ROUTINE privileges";
DECLARE CONTINUE HANDLER FOR 1405 SET code='1405', msg="Failed to revoke all privileges to dropped routine";
DECLARE CONTINUE HANDLER FOR 1406 SET code='1406', msg="Data too long for column '%s' at row %ld";
DECLARE CONTINUE HANDLER FOR 1407 SET code='1407', msg="Bad SQLSTATE: '%s'";
DECLARE CONTINUE HANDLER FOR 1408 SET code='1408', msg="%s: ready for connections. Version: '%s' socket: '%s' port: %d %s";
DECLARE CONTINUE HANDLER FOR 1409 SET code='1409', msg="Can't load value from file with fixed size rows to variable";
DECLARE CONTINUE HANDLER FOR 1410 SET code='1410', msg="You are not allowed to create a user with GRANT";
DECLARE CONTINUE HANDLER FOR 1411 SET code='1411', msg="Incorrect %s value: '%s' for function %s";
DECLARE CONTINUE HANDLER FOR 1412 SET code='1412', msg="Table definition has changed, please retry transaction";
DECLARE CONTINUE HANDLER FOR 1413 SET code='1413', msg="Duplicate handler declared in the same block";
DECLARE CONTINUE HANDLER FOR 1414 SET code='1414', msg="OUT or INOUT argument %d for routine %s is not a variable or NEW pseudo-variable in BEFORE trigger";
DECLARE CONTINUE HANDLER FOR 1415 SET code='1415', msg="Not allowed to return a result set from a %s";
DECLARE CONTINUE HANDLER FOR 1416 SET code='1416', msg="Cannot get geometry object from data you send to the GEOMETRY field";
DECLARE CONTINUE HANDLER FOR 1417 SET code='1417', msg="A routine failed and has neither NO SQL nor READS SQL DATA in its declaration and binary logging is enabled; if non-transactional tables were updated, the binary log will miss their changes";
DECLARE CONTINUE HANDLER FOR 1418 SET code='1418', msg="This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)";
DECLARE CONTINUE HANDLER FOR 1419 SET code='1419', msg="You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)";
DECLARE CONTINUE HANDLER FOR 1420 SET code='1420', msg="You can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it.";
DECLARE CONTINUE HANDLER FOR 1421 SET code='1421', msg="The statement (%lu) has no open cursor.";
DECLARE CONTINUE HANDLER FOR 1422 SET code='1422', msg="Explicit or implicit commit is not allowed in stored function or trigger.";
DECLARE CONTINUE HANDLER FOR 1423 SET code='1423', msg="Field of view '%s.%s' underlying table doesn't have a default value";
DECLARE CONTINUE HANDLER FOR 1424 SET code='1424', msg="Recursive stored functions and triggers are not allowed.";
DECLARE CONTINUE HANDLER FOR 1425 SET code='1425', msg="Too big scale %d specified for column '%s'. Maximum is %lu.";
DECLARE CONTINUE HANDLER FOR 1426 SET code='1426', msg="Too big precision %d specified for column '%s'. Maximum is %lu.";
DECLARE CONTINUE HANDLER FOR 1427 SET code='1427', msg="For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s').";
DECLARE CONTINUE HANDLER FOR 1428 SET code='1428', msg="You can't combine write-locking of system tables with other tables or lock types";
DECLARE CONTINUE HANDLER FOR 1429 SET code='1429', msg="Unable to connect to foreign data source: %s";
DECLARE CONTINUE HANDLER FOR 1430 SET code='1430', msg="There was a problem processing the query on the foreign data source. Data source error: %s";
DECLARE CONTINUE HANDLER FOR 1431 SET code='1431', msg="The foreign data source you are trying to reference does not exist. Data source error: %s";
DECLARE CONTINUE HANDLER FOR 1432 SET code='1432', msg="Can't create federated table. The data source connection string '%s' is not in the correct format";
DECLARE CONTINUE HANDLER FOR 1433 SET code='1433', msg="The data source connection string '%s' is not in the correct format";
DECLARE CONTINUE HANDLER FOR 1434 SET code='1434', msg="Can't create federated table. Foreign data src error: %s";
DECLARE CONTINUE HANDLER FOR 1435 SET code='1435', msg="Trigger in wrong schema";
DECLARE CONTINUE HANDLER FOR 1436 SET code='1436', msg="Thread stack overrun: %ld bytes used of a %ld byte stack, and %ld bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.";
DECLARE CONTINUE HANDLER FOR 1437 SET code='1437', msg="Routine body for '%s' is too long";
DECLARE CONTINUE HANDLER FOR 1438 SET code='1438', msg="Cannot drop default keycache";
DECLARE CONTINUE HANDLER FOR 1439 SET code='1439', msg="Display width out of range for column '%s' (max = %lu)";
DECLARE CONTINUE HANDLER FOR 1440 SET code='1440', msg="XAER_DUPID: The XID already exists";
DECLARE CONTINUE HANDLER FOR 1441 SET code='1441', msg="Datetime function: %s field overflow";
DECLARE CONTINUE HANDLER FOR 1442 SET code='1442', msg="Can't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.";
DECLARE CONTINUE HANDLER FOR 1443 SET code='1443', msg="The definition of table '%s' prevents operation %s on table '%s'.";
DECLARE CONTINUE HANDLER FOR 1444 SET code='1444', msg="The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner";
DECLARE CONTINUE HANDLER FOR 1445 SET code='1445', msg="Not allowed to set autocommit from a stored function or trigger";
DECLARE CONTINUE HANDLER FOR 1446 SET code='1446', msg="Definer is not fully qualified";
DECLARE CONTINUE HANDLER FOR 1447 SET code='1447', msg="View '%s'.'%s' has no definer information (old table format). Current user is used as definer. Please recreate the view!";
DECLARE CONTINUE HANDLER FOR 1448 SET code='1448', msg="You need the SUPER privilege for creation view with '%s'@'%s' definer";
DECLARE CONTINUE HANDLER FOR 1449 SET code='1449', msg="The user specified as a definer ('%s'@'%s') does not exist";
DECLARE CONTINUE HANDLER FOR 1450 SET code='1450', msg="Changing schema from '%s' to '%s' is not allowed.";
DECLARE CONTINUE HANDLER FOR 1451 SET code='1451', msg="Cannot delete or update a parent row: a foreign key constraint fails (%s)";
DECLARE CONTINUE HANDLER FOR 1452 SET code='1452', msg="Cannot add or update a child row: a foreign key constraint fails (%s)";
DECLARE CONTINUE HANDLER FOR 1453 SET code='1453', msg="Variable '%s' must be quoted with `...`, or renamed";
DECLARE CONTINUE HANDLER FOR 1454 SET code='1454', msg="No definer attribute for trigger '%s'.'%s'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger.";
DECLARE CONTINUE HANDLER FOR 1455 SET code='1455', msg="'%s' has an old format, you should re-create the '%s' object(s)";
DECLARE CONTINUE HANDLER FOR 1456 SET code='1456', msg="Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s";
DECLARE CONTINUE HANDLER FOR 1457 SET code='1457', msg="Failed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d)";
DECLARE CONTINUE HANDLER FOR 1458 SET code='1458', msg="Incorrect routine name '%s'";
DECLARE CONTINUE HANDLER FOR 1459 SET code='1459', msg="Table upgrade required. Please do 'REPAIR TABLE `%s`' or dump/reload to fix it!";
DECLARE CONTINUE HANDLER FOR 1460 SET code='1460', msg="AGGREGATE is not supported for stored functions";
DECLARE CONTINUE HANDLER FOR 1461 SET code='1461', msg="Can't create more than max_prepared_stmt_count statements (current value: %lu)";
DECLARE CONTINUE HANDLER FOR 1462 SET code='1462', msg="`%s`.`%s` contains view recursion";
DECLARE CONTINUE HANDLER FOR 1463 SET code='1463', msg="non-grouping field '%s' is used in %s clause";
DECLARE CONTINUE HANDLER FOR 1464 SET code='1464', msg="The used table type doesn't support SPATIAL indexes";
DECLARE CONTINUE HANDLER FOR 1465 SET code='1465', msg="Triggers can not be created on system tables";
DECLARE CONTINUE HANDLER FOR 1466 SET code='1466', msg="Leading spaces are removed from name '%s'";
DECLARE CONTINUE HANDLER FOR 1467 SET code='1467', msg="Failed to read auto-increment value from storage engine";
DECLARE CONTINUE HANDLER FOR 1468 SET code='1468', msg="user name";
DECLARE CONTINUE HANDLER FOR 1469 SET code='1469', msg="host name";
DECLARE CONTINUE HANDLER FOR 1470 SET code='1470', msg="String '%s' is too long for %s (should be no longer than %d)";
DECLARE CONTINUE HANDLER FOR 1471 SET code='1471', msg="The target table %s of the %s is not insertable-into";
DECLARE CONTINUE HANDLER FOR 1472 SET code='1472', msg="Table '%s' is differently defined or of non-MyISAM type or doesn't exist";
DECLARE CONTINUE HANDLER FOR 1473 SET code='1473', msg="Too high level of nesting for select";
DECLARE CONTINUE HANDLER FOR 1474 SET code='1474', msg="Name '%s' has become ''";
DECLARE CONTINUE HANDLER FOR 1475 SET code='1475', msg="First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY";
DECLARE CONTINUE HANDLER FOR 1476 SET code='1476', msg="The foreign server, %s, you are trying to create already exists.";
DECLARE CONTINUE HANDLER FOR 1477 SET code='1477', msg="The foreign server name you are trying to reference does not exist. Data source error: %s";
DECLARE CONTINUE HANDLER FOR 1478 SET code='1478', msg="Table storage engine '%s' does not support the create option '%s'";
DECLARE CONTINUE HANDLER FOR 1479 SET code='1479', msg="Syntax error: %s PARTITIONING requires definition of VALUES %s for each partition";
DECLARE CONTINUE HANDLER FOR 1480 SET code='1480', msg="Only %s PARTITIONING can use VALUES %s in partition definition";
DECLARE CONTINUE HANDLER FOR 1481 SET code='1481', msg="MAXVALUE can only be used in last partition definition";
DECLARE CONTINUE HANDLER FOR 1482 SET code='1482', msg="Subpartitions can only be hash partitions and by key";
DECLARE CONTINUE HANDLER FOR 1483 SET code='1483', msg="Must define subpartitions on all partitions if on one partition";
DECLARE CONTINUE HANDLER FOR 1484 SET code='1484', msg="Wrong number of partitions defined, mismatch with previous setting";
DECLARE CONTINUE HANDLER FOR 1485 SET code='1485', msg="Wrong number of subpartitions defined, mismatch with previous setting";
DECLARE CONTINUE HANDLER FOR 1486 SET code='1486', msg="Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed";
DECLARE CONTINUE HANDLER FOR 1487 SET code='1487', msg="Expression in RANGE/LIST VALUES must be constant";
DECLARE CONTINUE HANDLER FOR 1488 SET code='1488', msg="Field in list of fields for partition function not found in table";
DECLARE CONTINUE HANDLER FOR 1489 SET code='1489', msg="List of fields is only allowed in KEY partitions";
DECLARE CONTINUE HANDLER FOR 1490 SET code='1490', msg="The partition info in the frm file is not consistent with what can be written into the frm file";
DECLARE CONTINUE HANDLER FOR 1491 SET code='1491', msg="The %s function returns the wrong type";
DECLARE CONTINUE HANDLER FOR 1492 SET code='1492', msg="For %s partitions each partition must be defined";
DECLARE CONTINUE HANDLER FOR 1493 SET code='1493', msg="VALUES LESS THAN value must be strictly increasing for each partition";
DECLARE CONTINUE HANDLER FOR 1494 SET code='1494', msg="VALUES value must be of same type as partition function";
DECLARE CONTINUE HANDLER FOR 1495 SET code='1495', msg="Multiple definition of same constant in list partitioning";
DECLARE CONTINUE HANDLER FOR 1496 SET code='1496', msg="Partitioning can not be used stand-alone in query";
DECLARE CONTINUE HANDLER FOR 1497 SET code='1497', msg="The mix of handlers in the partitions is not allowed in this version of MySQL";
DECLARE CONTINUE HANDLER FOR 1498 SET code='1498', msg="For the partitioned engine it is necessary to define all %s";
DECLARE CONTINUE HANDLER FOR 1499 SET code='1499', msg="Too many partitions (including subpartitions) were defined";
DECLARE CONTINUE HANDLER FOR 1500 SET code='1500', msg="It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning";
DECLARE CONTINUE HANDLER FOR 1501 SET code='1501', msg="Failed to create specific handler file";
DECLARE CONTINUE HANDLER FOR 1502 SET code='1502', msg="A BLOB field is not allowed in partition function";
DECLARE CONTINUE HANDLER FOR 1503 SET code='1503', msg="A %s must include all columns in the table's partitioning function";
DECLARE CONTINUE HANDLER FOR 1504 SET code='1504', msg="Number of %s = 0 is not an allowed value";
DECLARE CONTINUE HANDLER FOR 1505 SET code='1505', msg="Partition management on a not partitioned table is not possible";
DECLARE CONTINUE HANDLER FOR 1506 SET code='1506', msg="Foreign key clause is not yet supported in conjunction with partitioning";
DECLARE CONTINUE HANDLER FOR 1507 SET code='1507', msg="Error in list of partitions to %s";
DECLARE CONTINUE HANDLER FOR 1508 SET code='1508', msg="Cannot remove all partitions, use DROP TABLE instead";
DECLARE CONTINUE HANDLER FOR 1509 SET code='1509', msg="COALESCE PARTITION can only be used on HASH/KEY partitions";
DECLARE CONTINUE HANDLER FOR 1510 SET code='1510', msg="REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers";
DECLARE CONTINUE HANDLER FOR 1511 SET code='1511', msg="REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs";
DECLARE CONTINUE HANDLER FOR 1512 SET code='1512', msg="%s PARTITION can only be used on RANGE/LIST partitions";
DECLARE CONTINUE HANDLER FOR 1513 SET code='1513', msg="Trying to Add partition(s) with wrong number of subpartitions";
DECLARE CONTINUE HANDLER FOR 1514 SET code='1514', msg="At least one partition must be added";
DECLARE CONTINUE HANDLER FOR 1515 SET code='1515', msg="At least one partition must be coalesced";
DECLARE CONTINUE HANDLER FOR 1516 SET code='1516', msg="More partitions to reorganize than there are partitions";
DECLARE CONTINUE HANDLER FOR 1517 SET code='1517', msg="Duplicate partition name %s";
DECLARE CONTINUE HANDLER FOR 1518 SET code='1518', msg="It is not allowed to shut off binlog on this command";
DECLARE CONTINUE HANDLER FOR 1519 SET code='1519', msg="When reorganizing a set of partitions they must be in consecutive order";
DECLARE CONTINUE HANDLER FOR 1520 SET code='1520', msg="Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range";
DECLARE CONTINUE HANDLER FOR 1521 SET code='1521', msg="Partition function not supported in this version for this handler";
DECLARE CONTINUE HANDLER FOR 1522 SET code='1522', msg="Partition state cannot be defined from CREATE/ALTER TABLE";
DECLARE CONTINUE HANDLER FOR 1523 SET code='1523', msg="The %s handler only supports 32 bit integers in VALUES";
DECLARE CONTINUE HANDLER FOR 1524 SET code='1524', msg="Plugin '%s' is not loaded";
DECLARE CONTINUE HANDLER FOR 1525 SET code='1525', msg="Incorrect %s value: '%s'";
DECLARE CONTINUE HANDLER FOR 1526 SET code='1526', msg="Table has no partition for value %s";
DECLARE CONTINUE HANDLER FOR 1527 SET code='1527', msg="It is not allowed to specify %s more than once";
DECLARE CONTINUE HANDLER FOR 1528 SET code='1528', msg="Failed to create %s";
DECLARE CONTINUE HANDLER FOR 1529 SET code='1529', msg="Failed to drop %s";
DECLARE CONTINUE HANDLER FOR 1530 SET code='1530', msg="The handler doesn't support autoextend of tablespaces";
DECLARE CONTINUE HANDLER FOR 1531 SET code='1531', msg="A size parameter was incorrectly specified, either number or on the form 10M";
DECLARE CONTINUE HANDLER FOR 1532 SET code='1532', msg="The size number was correct but we don't allow the digit part to be more than 2 billion";
DECLARE CONTINUE HANDLER FOR 1533 SET code='1533', msg="Failed to alter: %s";
DECLARE CONTINUE HANDLER FOR 1534 SET code='1534', msg="Writing one row to the row-based binary log failed";
DECLARE CONTINUE HANDLER FOR 1535 SET code='1535', msg="Table definition on master and slave does not match: %s";
DECLARE CONTINUE HANDLER FOR 1536 SET code='1536', msg="Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events";
DECLARE CONTINUE HANDLER FOR 1537 SET code='1537', msg="Event '%s' already exists";
DECLARE CONTINUE HANDLER FOR 1538 SET code='1538', msg="Failed to store event %s. Error code %d from storage engine.";
DECLARE CONTINUE HANDLER FOR 1539 SET code='1539', msg="Unknown event '%s'";
DECLARE CONTINUE HANDLER FOR 1540 SET code='1540', msg="Failed to alter event '%s'";
DECLARE CONTINUE HANDLER FOR 1541 SET code='1541', msg="Failed to drop %s";
DECLARE CONTINUE HANDLER FOR 1542 SET code='1542', msg="INTERVAL is either not positive or too big";
DECLARE CONTINUE HANDLER FOR 1543 SET code='1543', msg="ENDS is either invalid or before STARTS";
DECLARE CONTINUE HANDLER FOR 1544 SET code='1544', msg="Event execution time is in the past. Event has been disabled";
DECLARE CONTINUE HANDLER FOR 1545 SET code='1545', msg="Failed to open mysql.event";
DECLARE CONTINUE HANDLER FOR 1546 SET code='1546', msg="No datetime expression provided";
DECLARE CONTINUE HANDLER FOR 1547 SET code='1547', msg="Column count of mysql.%s is wrong. Expected %d, found %d. The table is probably corrupted";
DECLARE CONTINUE HANDLER FOR 1548 SET code='1548', msg="Cannot load from mysql.%s. The table is probably corrupted";
DECLARE CONTINUE HANDLER FOR 1549 SET code='1549', msg="Failed to delete the event from mysql.event";
DECLARE CONTINUE HANDLER FOR 1550 SET code='1550', msg="Error during compilation of event's body";
DECLARE CONTINUE HANDLER FOR 1551 SET code='1551', msg="Same old and new event name";
DECLARE CONTINUE HANDLER FOR 1552 SET code='1552', msg="Data for column '%s' too long";
DECLARE CONTINUE HANDLER FOR 1553 SET code='1553', msg="Cannot drop index '%s': needed in a foreign key constraint";
DECLARE CONTINUE HANDLER FOR 1554 SET code='1554', msg="The syntax '%s' is deprecated and will be removed in MySQL %s. Please use %s instead";
DECLARE CONTINUE HANDLER FOR 1555 SET code='1555', msg="You can't write-lock a log table. Only read access is possible";
DECLARE CONTINUE HANDLER FOR 1556 SET code='1556', msg="You can't use locks with log tables.";
DECLARE CONTINUE HANDLER FOR 1557 SET code='1557', msg="Upholding foreign key constraints for table '%s', entry '%s', key %d would lead to a duplicate entry";
DECLARE CONTINUE HANDLER FOR 1558 SET code='1558', msg="Column count of mysql.%s is wrong. Expected %d, found %d. Created with MySQL %d, now running %d. Please use mysql_upgrade to fix this error.";
DECLARE CONTINUE HANDLER FOR 1559 SET code='1559', msg="Cannot switch out of the row-based binary log format when the session has open temporary tables";
DECLARE CONTINUE HANDLER FOR 1560 SET code='1560', msg="Cannot change the binary logging format inside a stored function or trigger";
DECLARE CONTINUE HANDLER FOR 1561 SET code='1561', msg="The NDB cluster engine does not support changing the binlog format on the fly yet";
DECLARE CONTINUE HANDLER FOR 1562 SET code='1562', msg="Cannot create temporary table with partitions";
DECLARE CONTINUE HANDLER FOR 1563 SET code='1563', msg="Partition constant is out of partition function domain";
DECLARE CONTINUE HANDLER FOR 1564 SET code='1564', msg="This partition function is not allowed";
DECLARE CONTINUE HANDLER FOR 1565 SET code='1565', msg="Error in DDL log";
DECLARE CONTINUE HANDLER FOR 1566 SET code='1566', msg="Not allowed to use NULL value in VALUES LESS THAN";
DECLARE CONTINUE HANDLER FOR 1567 SET code='1567', msg="Incorrect partition name";
DECLARE CONTINUE HANDLER FOR 1568 SET code='1568', msg="Transaction isolation level can't be changed while a transaction is in progress";
DECLARE CONTINUE HANDLER FOR 1569 SET code='1569', msg="ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '%s' for key '%s'";
DECLARE CONTINUE HANDLER FOR 1570 SET code='1570', msg="Internal scheduler error %d";
DECLARE CONTINUE HANDLER FOR 1571 SET code='1571', msg="Error during starting/stopping of the scheduler. Error code %u";
DECLARE CONTINUE HANDLER FOR 1572 SET code='1572', msg="Engine cannot be used in partitioned tables";
DECLARE CONTINUE HANDLER FOR 1573 SET code='1573', msg="Cannot activate '%s' log";
DECLARE CONTINUE HANDLER FOR 1574 SET code='1574', msg="The server was not built with row-based replication";
DECLARE CONTINUE HANDLER FOR 1575 SET code='1575', msg="Decoding of base64 string failed";
DECLARE CONTINUE HANDLER FOR 1576 SET code='1576', msg="Recursion of EVENT DDL statements is forbidden when body is present";
DECLARE CONTINUE HANDLER FOR 1577 SET code='1577', msg="Cannot proceed because system tables used by Event Scheduler were found damaged at server start";
DECLARE CONTINUE HANDLER FOR 1578 SET code='1578', msg="Only integers allowed as number here";
DECLARE CONTINUE HANDLER FOR 1579 SET code='1579', msg="This storage engine cannot be used for log tables";
DECLARE CONTINUE HANDLER FOR 1580 SET code='1580', msg="You cannot '%s' a log table if logging is enabled";
DECLARE CONTINUE HANDLER FOR 1581 SET code='1581', msg="Cannot rename '%s'. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to '%s'";
DECLARE CONTINUE HANDLER FOR 1582 SET code='1582', msg="Incorrect parameter count in the call to native function '%s'";
DECLARE CONTINUE HANDLER FOR 1583 SET code='1583', msg="Incorrect parameters in the call to native function '%s'";
DECLARE CONTINUE HANDLER FOR 1584 SET code='1584', msg="Incorrect parameters in the call to stored function '%s'";
DECLARE CONTINUE HANDLER FOR 1585 SET code='1585', msg="This function '%s' has the same name as a native function";
DECLARE CONTINUE HANDLER FOR 1586 SET code='1586', msg="Duplicate entry '%s' for key '%s'";
DECLARE CONTINUE HANDLER FOR 1587 SET code='1587', msg="Too many files opened, please execute the command again";
DECLARE CONTINUE HANDLER FOR 1588 SET code='1588', msg="Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.";
DECLARE CONTINUE HANDLER FOR 1589 SET code='1589', msg="Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.";
DECLARE CONTINUE HANDLER FOR 1590 SET code='1590', msg="The incident %s occured on the master. Message: %s";
DECLARE CONTINUE HANDLER FOR 1591 SET code='1591', msg="Table has no partition for some existing values";
DECLARE CONTINUE HANDLER FOR 1592 SET code='1592', msg="Statement may not be safe to log in statement format.";
DECLARE CONTINUE HANDLER FOR 1593 SET code='1593', msg="Fatal error: %s";
DECLARE CONTINUE HANDLER FOR 1594 SET code='1594', msg="Relay log read failure: %s";
DECLARE CONTINUE HANDLER FOR 1595 SET code='1595', msg="Relay log write failure: %s";
DECLARE CONTINUE HANDLER FOR 1596 SET code='1596', msg="Failed to create %s";
DECLARE CONTINUE HANDLER FOR 1597 SET code='1597', msg="Master command %s failed: %s";
DECLARE CONTINUE HANDLER FOR 1598 SET code='1598', msg="Binary logging not possible. Message: %s";
DECLARE CONTINUE HANDLER FOR 1599 SET code='1599', msg="View `%s`.`%s` has no creation context";
DECLARE CONTINUE HANDLER FOR 1600 SET code='1600', msg="Creation context of view `%s`.`%s' is invalid";
DECLARE CONTINUE HANDLER FOR 1601 SET code='1601', msg="Creation context of stored routine `%s`.`%s` is invalid";
DECLARE CONTINUE HANDLER FOR 1602 SET code='1602', msg="Corrupted TRG file for table `%s`.`%s`";
DECLARE CONTINUE HANDLER FOR 1603 SET code='1603', msg="Triggers for table `%s`.`%s` have no creation context";
DECLARE CONTINUE HANDLER FOR 1604 SET code='1604', msg="Trigger creation context of table `%s`.`%s` is invalid";
DECLARE CONTINUE HANDLER FOR 1605 SET code='1605', msg="Creation context of event `%s`.`%s` is invalid";
DECLARE CONTINUE HANDLER FOR 1606 SET code='1606', msg="Cannot open table for trigger `%s`.`%s`";
DECLARE CONTINUE HANDLER FOR 1607 SET code='1607', msg="Cannot create stored routine `%s`. Check warnings";
DECLARE CONTINUE HANDLER FOR 1608 SET code='1608', msg="Ambiguous slave modes combination. %s";
DECLARE CONTINUE HANDLER FOR 1609 SET code='1609', msg="The BINLOG statement of type `%s` was not preceded by a format description BINLOG statement.";
DECLARE CONTINUE HANDLER FOR 1610 SET code='1610', msg="Corrupted replication event was detected";
DECLARE CONTINUE HANDLER FOR 1611 SET code='1611', msg="Invalid column reference (%s) in LOAD DATA";
DECLARE CONTINUE HANDLER FOR 1612 SET code='1612', msg="Being purged log %s was not found";
DECLARE CONTINUE HANDLER FOR 1613 SET code='1613', msg="XA_RBTIMEOUT: Transaction branch was rolled back: took too long";
DECLARE CONTINUE HANDLER FOR 1614 SET code='1614', msg="XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected";
DECLARE CONTINUE HANDLER FOR 1615 SET code='1615', msg="Prepared statement needs to be re-prepared";
DECLARE CONTINUE HANDLER FOR 1616 SET code='1616', msg="DELAYED option not supported for table '%s'";
DECLARE CONTINUE HANDLER FOR 1617 SET code='1617', msg="The master info structure does not exist";
DECLARE CONTINUE HANDLER FOR 1618 SET code='1618', msg="<%s> option ignored";
DECLARE CONTINUE HANDLER FOR 1619 SET code='1619', msg="Built-in plugins cannot be deleted";
DECLARE CONTINUE HANDLER FOR 1620 SET code='1620', msg="Plugin is busy and will be uninstalled on shutdown";
DECLARE CONTINUE HANDLER FOR 1621 SET code='1621', msg="%s variable '%s' is read-only. Use SET %s to assign the value";
DECLARE CONTINUE HANDLER FOR 1622 SET code='1622', msg="Storage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted";
DECLARE CONTINUE HANDLER FOR 1623 SET code='1623', msg="Unexpected master's heartbeat data: %s";
DECLARE CONTINUE HANDLER FOR 1624 SET code='1624', msg="The requested value for the heartbeat period %s %s";
DECLARE CONTINUE HANDLER FOR 1625 SET code='1625', msg="Bad schema for mysql.ndb_replication table. Message: %s";
DECLARE CONTINUE HANDLER FOR 1626 SET code='1626', msg="Error in parsing conflict function. Message: %s";
DECLARE CONTINUE HANDLER FOR 1627 SET code='1627', msg="Write to exceptions table failed. Message: %s";
DECLARE CONTINUE HANDLER FOR 1628 SET code='1628', msg="Comment for table '%s' is too long (max = %lu)";
DECLARE CONTINUE HANDLER FOR 1629 SET code='1629', msg="Comment for field '%s' is too long (max = %lu)";
DECLARE CONTINUE HANDLER FOR 1630 SET code='1630', msg="FUNCTION %s does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual";
DECLARE CONTINUE HANDLER FOR 1631 SET code='1631', msg="Database";
DECLARE CONTINUE HANDLER FOR 1632 SET code='1632', msg="Table";
DECLARE CONTINUE HANDLER FOR 1633 SET code='1633', msg="Partition";
DECLARE CONTINUE HANDLER FOR 1634 SET code='1634', msg="Subpartition";
DECLARE CONTINUE HANDLER FOR 1635 SET code='1635', msg="Temporary";
DECLARE CONTINUE HANDLER FOR 1636 SET code='1636', msg="Renamed";
DECLARE CONTINUE HANDLER FOR 1637 SET code='1637', msg="Too many active concurrent transactions";
DECLARE CONTINUE HANDLER FOR 1638 SET code='1638', msg="Non-ASCII separator arguments are not fully supported";
DECLARE CONTINUE HANDLER FOR 1639 SET code='1639', msg="debug sync point wait timed out";
DECLARE CONTINUE HANDLER FOR 1640 SET code='1640', msg="debug sync point hit limit reached";
DECLARE CONTINUE HANDLER FOR 2000 SET code='2000', msg="Unknown MySQL error";
DECLARE CONTINUE HANDLER FOR 2001 SET code='2001', msg="Can't create UNIX socket (%d)";
DECLARE CONTINUE HANDLER FOR 2002 SET code='2002', msg="Can't connect to local MySQL server through socket '%s' (%d)";
DECLARE CONTINUE HANDLER FOR 2003 SET code='2003', msg="Can't connect to MySQL server on '%s' (%d)";
DECLARE CONTINUE HANDLER FOR 2004 SET code='2004', msg="Can't create TCP/IP socket (%d)";
DECLARE CONTINUE HANDLER FOR 2005 SET code='2005', msg="Unknown MySQL server host '%s' (%d)";
DECLARE CONTINUE HANDLER FOR 2006 SET code='2006', msg="MySQL server has gone away";
DECLARE CONTINUE HANDLER FOR 2007 SET code='2007', msg="Protocol mismatch; server version = %d, client version = %d";
DECLARE CONTINUE HANDLER FOR 2008 SET code='2008', msg="MySQL client ran out of memory";
DECLARE CONTINUE HANDLER FOR 2009 SET code='2009', msg="Wrong host info";
DECLARE CONTINUE HANDLER FOR 2010 SET code='2010', msg="Localhost via UNIX socket";
DECLARE CONTINUE HANDLER FOR 2011 SET code='2011', msg="%s via TCP/IP";
DECLARE CONTINUE HANDLER FOR 2012 SET code='2012', msg="Error in server handshake";
DECLARE CONTINUE HANDLER FOR 2013 SET code='2013', msg="Lost connection to MySQL server during query";
DECLARE CONTINUE HANDLER FOR 2014 SET code='2014', msg="Commands out of sync; you can't run this command now";
DECLARE CONTINUE HANDLER FOR 2015 SET code='2015', msg="Named pipe: %s";
DECLARE CONTINUE HANDLER FOR 2016 SET code='2016', msg="Can't wait for named pipe to host: %s pipe: %s (%lu)";
DECLARE CONTINUE HANDLER FOR 2017 SET code='2017', msg="Can't open named pipe to host: %s pipe: %s (%lu)";
DECLARE CONTINUE HANDLER FOR 2018 SET code='2018', msg="Can't set state of named pipe to host: %s pipe: %s (%lu)";
DECLARE CONTINUE HANDLER FOR 2019 SET code='2019', msg="Can't initialize character set %s (path: %s)";
DECLARE CONTINUE HANDLER FOR 2020 SET code='2020', msg="Got packet bigger than 'max_allowed_packet' bytes";
DECLARE CONTINUE HANDLER FOR 2021 SET code='2021', msg="Embedded server";
DECLARE CONTINUE HANDLER FOR 2022 SET code='2022', msg="Error on SHOW SLAVE STATUS:";
DECLARE CONTINUE HANDLER FOR 2023 SET code='2023', msg="Error on SHOW SLAVE HOSTS:";
DECLARE CONTINUE HANDLER FOR 2024 SET code='2024', msg="Error connecting to slave:";
DECLARE CONTINUE HANDLER FOR 2025 SET code='2025', msg="Error connecting to master:";
DECLARE CONTINUE HANDLER FOR 2026 SET code='2026', msg="SSL connection error";
DECLARE CONTINUE HANDLER FOR 2027 SET code='2027', msg="Malformed packet";
DECLARE CONTINUE HANDLER FOR 2028 SET code='2028', msg="This client library is licensed only for use with MySQL servers having '%s' license";
DECLARE CONTINUE HANDLER FOR 2029 SET code='2029', msg="Invalid use of null pointer";
DECLARE CONTINUE HANDLER FOR 2030 SET code='2030', msg="Statement not prepared";
DECLARE CONTINUE HANDLER FOR 2031 SET code='2031', msg="No data supplied for parameters in prepared statement";
DECLARE CONTINUE HANDLER FOR 2032 SET code='2032', msg="Data truncated";
DECLARE CONTINUE HANDLER FOR 2033 SET code='2033', msg="No parameters exist in the statement";
DECLARE CONTINUE HANDLER FOR 2034 SET code='2034', msg="Invalid parameter number";
DECLARE CONTINUE HANDLER FOR 2035 SET code='2035', msg="Can't send long data for non-string/non-binary data types (parameter: %d)";
DECLARE CONTINUE HANDLER FOR 2036 SET code='2036', msg="Using unsupported buffer type: %d (parameter: %d)";
DECLARE CONTINUE HANDLER FOR 2037 SET code='2037', msg="Shared memory: %s";
DECLARE CONTINUE HANDLER FOR 2038 SET code='2038', msg="Can't open shared memory; client could not create request event (%lu)";
DECLARE CONTINUE HANDLER FOR 2039 SET code='2039', msg="Can't open shared memory; no answer event received from server (%lu)";
DECLARE CONTINUE HANDLER FOR 2040 SET code='2040', msg="Can't open shared memory; server could not allocate file mapping (%lu)";
DECLARE CONTINUE HANDLER FOR 2041 SET code='2041', msg="Can't open shared memory; server could not get pointer to file mapping (%lu)";
DECLARE CONTINUE HANDLER FOR 2042 SET code='2042', msg="Can't open shared memory; client could not allocate file mapping (%lu)";
DECLARE CONTINUE HANDLER FOR 2043 SET code='2043', msg="Can't open shared memory; client could not get pointer to file mapping (%lu)";
DECLARE CONTINUE HANDLER FOR 2044 SET code='2044', msg="Can't open shared memory; client could not create %s event (%lu)";
DECLARE CONTINUE HANDLER FOR 2045 SET code='2045', msg="Can't open shared memory; no answer from server (%lu)";
DECLARE CONTINUE HANDLER FOR 2046 SET code='2046', msg="Can't open shared memory; cannot send request event to server (%lu)";
DECLARE CONTINUE HANDLER FOR 2047 SET code='2047', msg="Wrong or unknown protocol";
DECLARE CONTINUE HANDLER FOR 2048 SET code='2048', msg="Invalid connection handle";
DECLARE CONTINUE HANDLER FOR 2049 SET code='2049', msg="Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)";
DECLARE CONTINUE HANDLER FOR 2050 SET code='2050', msg="Row retrieval was canceled by mysql_stmt_close() call";
DECLARE CONTINUE HANDLER FOR 2051 SET code='2051', msg="Attempt to read column without prior row fetch";
DECLARE CONTINUE HANDLER FOR 2052 SET code='2052', msg="Prepared statement contains no metadata";
DECLARE CONTINUE HANDLER FOR 2053 SET code='2053', msg="Attempt to read a row while there is no result set associated with the statement";
DECLARE CONTINUE HANDLER FOR 2054 SET code='2054', msg="This feature is not implemented yet";
DECLARE CONTINUE HANDLER FOR 2055 SET code='2055', msg="Lost connection to MySQL server at '%s', system error: %d";
DECLARE CONTINUE HANDLER FOR 2056 SET code='2056', msg="Statement closed indirectly because of a preceeding %s() call";
DECLARE CONTINUE HANDLER FOR 2057 SET code='2057', msg="The number of columns in the result set differs from the number of bound buffers. You must reset the statement, rebind the result set columns, and execute the statement again";
 
Trackback 0 : Comment 0

MySQL enum에 없는 값을 입력시 에러 처리 방법

분류없음 2015.05.15 15:43


SET GLOBAL sql_mode="STRICT_TRANS_TABLES";
SET SESSION sql_mode="STRICT_TRANS_TABLES";

enum에 Y와 N이 아닌 값이 입력된 경우 에러 처리.


Trackback 0 : Comment 0