MYSQL出错音信表

更加多详细错误代码 
破绽百著名称 /                     错误代码       SQL状态
ER_HASHCHK                 1000               HY000
ER_NISAMCHK               1001               HY000
ER_NO                       1002                 HY000
ER_YES                       1003               HY000
ER_CANT_CREATE_FILE       1004             HY000
ER_CANT_CREATE_TABLE     1005             HY000
ER_CANT_CREATE_DB       1006               HY000
ER_DB_CREATE_EXISTS     1007                 HY000
ER_DB_DROP_EXISTS       1008                   HY000
ER_DB_DROP_DELETE       1009                 HY000
ER_DB_DROP_RMDIR         1010                 HY000
ER_CANT_DELETE_FILE 1011 HY000
ER_CANT_FIND_SYSTEM_REC 1012 HY000
ER_CANT_GET_STAT 1013 HY000
ER_CANT_GET_WD 1014 HY000
ER_CANT_LOCK 1015 HY000
ER_CANT_OPEN_FILE 1016 HY000
ER_FILE_NOT_FOUND 1017 HY000
ER_CANT_READ_DIR 1018 HY000
ER_CANT_SET_WD 1019 HY000
ER_CHECKREAD 1020 HY000
ER_DISK_FULL 1021 HY000
ER_DUP_KEY 1022 23000
ER_ERROR_ON_CLOSE 1023 HY000
ER_ERROR_ON_READ 1024 HY000
ER_ERROR_ON_RENAME 1025 HY000
ER_ERROR_ON_WRITE 1026 HY000
ER_FILE_USED 1027 HY000
ER_FILSORT_ABORT 1028 HY000
ER_FORM_NOT_FOUND 1029 HY000
ER_GET_ERRNO 1030 HY000
ER_ILLEGAL_HA 1031 HY000
ER_KEY_NOT_FOUND 1032 HY000
ER_NOT_FORM_FILE 1033 HY000
ER_NOT_KEYFILE 1034 HY000
ER_OLD_KEYFILE 1035 HY000
ER_OPEN_AS_READONLY 1036 HY000
ER_OUTOFMEMORY 1037 HY001
ER_OUT_OF_SORTMEMORY 1038 HY001
ER_UNEXPECTED_EOF 1039 HY000
ER_CON_COUNT_ERROR 1040 08004
ER_OUT_OF_RESOURCES 1041 08004
ER_BAD_HOST_ERROR 1042 08S01
ER_HANDSHAKE_ERROR 1043 08S01
ER_DBACCESS_DENIED_ERROR 1044 42000
ER_ACCESS_DENIED_ERROR 1045 42000
ER_NO_DB_ERROR 1046 42000
ER_UNKNOWN_COM_ERROR 1047 08S01
ER_BAD_NULL_ERROR 1048 23000
ER_BAD_DB_ERROR 1049 42000
ER_TABLE_EXISTS_ERROR 1050 42S01
ER_BAD_TABLE_ERROR 1051 42S02
ER_NON_UNIQ_ERROR 1052 23000
ER_SERVER_SHUTDOWN 1053 08S01
ER_BAD_FIELD_ERROR 1054 42S22
ER_WRONG_FIELD_WITH_GROUP 1055 42000
ER_WRONG_GROUP_FIELD 1056 42000
ER_WRONG_SUM_SELECT 1057 42000
ER_WRONG_VALUE_COUNT 1058 21S01
ER_TOO_LONG_IDENT 1059 42000
ER_DUP_FIELDNAME 1060 42S21
ER_DUP_KEYNAME 1061 42000
ER_DUP_ENTRY 1062 23000
ER_WRONG_FIELD_SPEC 1063 42000
ER_PARSE_ERROR 1064 42000
ER_EMPTY_QUERY 1065 42000
ER_NONUNIQ_TABLE 1066 42000
ER_INVALID_DEFAULT 1067 42000
ER_MULTIPLE_PRI_KEY 1068 42000
ER_TOO_MANY_KEYS 1069 42000
ER_TOO_MANY_KEY_PARTS 1070 42000
ER_TOO_LONG_KEY 1071 42000
ER_KEY_COLUMN_DOES_NOT_EXITS 1072 42000
ER_BLOB_USED_AS_KEY 1073 42000
ER_TOO_BIG_FIELDLENGTH 1074 42000
ER_WRONG_AUTO_KEY 1075 42000
ER_READY 1076 00000
ER_NORMAL_SHUTDOWN 1077 00000
ER_GOT_SIGNAL 1078 00000
ER_SHUTDOWN_COMPLETE 1079 00000
ER_FORCING_CLOSE 1080 08S01
ER_IPSOCK_ERROR 1081 08S01
ER_NO_SUCH_INDEX 1082 42S12
ER_WRONG_FIELD_TERMINATORS 1083 42000
ER_BLOBS_AND_NO_TERMINATED 1084 42000
ER_TEXTFILE_NOT_READABLE 1085 HY000
ER_FILE_EXISTS_ERROR 1086 HY000
ER_LOAD_INFO 1087 HY000
ER_ALTER_INFO 1088 HY000
ER_WRONG_SUB_KEY 1089 HY000
ER_CANT_REMOVE_ALL_FIELDS 1090 42000
ER_CANT_DROP_FIELD_OR_KEY 1091 42000
ER_INSERT_INFO 1092 HY000
ER_UPDATE_TABLE_USED 1093 HY000
ER_NO_SUCH_THREAD 1094 HY000
ER_KILL_DENIED_ERROR 1095 HY000
ER_NO_TABLES_USED 1096 HY000
ER_TOO_BIG_SET 1097 HY000
ER_NO_UNIQUE_LOGFILE 1098 HY000
ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 HY000
ER_TABLE_NOT_LOCKED 1100 HY000
ER_BLOB_CANT_HAVE_DEFAULT 1101 42000
ER_WRONG_DB_NAME 1102 42000
ER_WRONG_TABLE_NAME 1103 42000
ER_TOO_BIG_SELECT 1104 42000
ER_UNKNOWN_ERROR 1105 HY000
ER_UNKNOWN_PROCEDURE 1106 42000
ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107 42000
ER_WRONG_PARAMETERS_TO_PROCEDURE 1108 HY000
ER_UNKNOWN_TABLE 1109 42S02
ER_FIELD_SPECIFIED_TWICE 1110 42000
ER_INVALID_GROUP_FUNC_USE 1111 42000
ER_UNSUPPORTED_EXTENSION 1112 42000
ER_TABLE_MUST_HAVE_COLUMNS 1113 42000
ER_RECORD_FILE_FULL 1114 HY000
ER_UNKNOWN_CHARACTER_SET 1115 42000
ER_TOO_MANY_TABLES 1116 HY000
ER_TOO_MANY_FIELDS 1117 HY000
ER_TOO_BIG_ROWSIZE 1118 42000
ER_STACK_OVERRUN 1119 HY000
ER_WRONG_OUTER_JOIN 1120 42000
ER_NULL_COLUMN_IN_INDEX 1121 42000
ER_CANT_FIND_UDF 1122 HY000
ER_CANT_INITIALIZE_UDF 1123 HY000
ER_UDF_NO_PATHS 1124 HY000
ER_UDF_EXISTS 1125 HY000
ER_CANT_OPEN_LIBRARY 1126 HY000
ER_CANT_FIND_DL_ENTRY 1127 HY000
ER_FUNCTION_NOT_DEFINED 1128 HY000
ER_HOST_IS_BLOCKED 1129 HY000
ER_HOST_NOT_PRIVILEGED 1130 HY000
ER_PASSWORD_ANONYMOUS_USER 1131 42000
ER_PASSWORD_NOT_ALLOWED 1132 42000
ER_PASSWORD_NO_MATCH 1133 42000
ER_UPDATE_INFO 1134 HY000
ER_CANT_CREATE_THREAD 1135 HY000
ER_WRONG_VALUE_COUNT_ON_ROW 1136 21S01
ER_CANT_REOPEN_TABLE 1137 HY000
ER_INVALID_USE_OF_NULL 1138 42000
ER_REGEXP_ERROR 1139 42000
ER_MIX_OF_GROUP_FUNC_AND_FIELDS 1140 42000
ER_NONEXISTING_GRANT 1141 42000
ER_TABLEACCESS_DENIED_ERROR 1142 42000
ER_COLUMNACCESS_DENIED_ERROR 1143 42000
ER_ILLEGAL_GRANT_FOR_TABLE 1144 42000
ER_GRANT_WRONG_HOST_OR_USER 1145 42000
ER_NO_SUCH_TABLE 1146 42S02
ER_NONEXISTING_TABLE_GRANT 1147 42000
ER_NOT_ALLOWED_COMMAND 1148 42000
ER_SYNTAX_ERROR 1149 42000
ER_DELAYED_CANT_CHANGE_LOCK 1150 HY000
ER_TOO_MANY_DELAYED_THREADS 1151 HY000
ER_ABORTING_CONNECTION 1152 08S01
ER_NET_PACKET_TOO_LARGE 1153 08S01
ER_NET_READ_ERROR_FROM_PIPE 1154 08S01
ER_NET_FCNTL_ERROR 1155 08S01
ER_NET_PACKETS_OUT_OF_ORDER 1156 08S01
ER_NET_UNCOMPRESS_ERROR 1157 08S01
ER_NET_READ_ERROR 1158 08S01
ER_NET_READ_INTERRUPTED 1159 08S01
ER_NET_ERROR_ON_WRITE 1160 08S01
ER_NET_WRITE_INTERRUPTED 1161 08S01
ER_TOO_LONG_STRING 1162 42000
ER_TABLE_CANT_HANDLE_BLOB 1163 42000
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164 42000
ER_DELAYED_INSERT_TABLE_LOCKED 1165 HY000
ER_WRONG_COLUMN_NAME 1166 42000
ER_WRONG_KEY_COLUMN 1167 42000
ER_WRONG_MRG_TABLE 1168 HY000
ER_DUP_UNIQUE 1169 23000
ER_BLOB_KEY_WITHOUT_LENGTH 1170 42000
ER_PRIMARY_CANT_HAVE_NULL 1171 42000
ER_TOO_MANY_ROWS 1172 42000
ER_REQUIRES_PRIMARY_KEY 1173 42000
ER_NO_RAID_COMPILED 1174 HY000
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE 1175 HY000
ER_KEY_DOES_NOT_EXITS 1176 HY000
ER_CHECK_NO_SUCH_TABLE 1177 42000
ER_CHECK_NOT_IMPLEMENTED 1178 42000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179 25000
ER_ERROR_DURING_COMMIT 1180 HY000
ER_ERROR_DURING_ROLLBACK 1181 HY000
ER_ERROR_DURING_FLUSH_LOGS 1182 HY000
ER_ERROR_DURING_CHECKPOINT 1183 HY000
ER_NEW_ABORTING_CONNECTION 1184 08S01
ER_DUMP_NOT_IMPLEMENTED 1185 HY000
ER_FLUSH_MASTER_BINLOG_CLOSED 1186 HY000
ER_INDEX_REBUILD 1187 HY000
ER_MASTER 1188 HY000
ER_MASTER_NET_READ 1189 08S01
ER_MASTER_NET_WRITE 1190 08S01
ER_FT_MATCHING_KEY_NOT_FOUND 1191 HY000
ER_LOCK_OR_ACTIVE_TRANSACTION 1192 HY000
ER_UNKNOWN_SYSTEM_VARIABLE 1193 HY000
ER_CRASHED_ON_USAGE 1194 HY000
ER_CRASHED_ON_REPAIR 1195 HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK 1196 HY000
ER_TRANS_CACHE_FULL 1197 HY000
ER_SLAVE_MUST_STOP 1198 HY000
ER_SLAVE_NOT_RUNNING 1199 HY000
ER_BAD_SLAVE 1200 HY000
ER_MASTER_INFO 1201 HY000
ER_SLAVE_THREAD 1202 HY000
ER_TOO_MANY_USER_CONNECTIONS 1203 42000
ER_SET_CONSTANTS_ONLY 1204 HY000
ER_LOCK_WAIT_TIMEOUT 1205 HY000
ER_LOCK_TABLE_FULL 1206 HY000
ER_READ_ONLY_TRANSACTION 1207 25000
ER_DROP_DB_WITH_READ_LOCK 1208 HY000
ER_CREATE_DB_WITH_READ_LOCK 1209 HY000
ER_WRONG_ARGUMENTS 1210 HY000
ER_NO_PERMISSION_TO_CREATE_USER 1211 42000
ER_UNION_TABLES_IN_DIFFERENT_DIR 1212 HY000
ER_LOCK_DEADLOCK 1213 40001
ER_TABLE_CANT_HANDLE_FULLTEXT 1214 HY000
ER_CANNOT_ADD_FOREIGN 1215 HY000
ER_NO_REFERENCED_ROW 1216 23000
ER_ROW_IS_REFERENCED 1217 23000
ER_CONNECT_TO_MASTER 1218 08S01
ER_QUERY_ON_MASTER 1219 HY000
ER_ERROR_WHEN_EXECUTING_COMMAND 1220 HY000
ER_WRONG_USAGE 1221 HY000
ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT 1222 21000
ER_CANT_UPDATE_WITH_READLOCK 1223 HY000
ER_MIXING_NOT_ALLOWED 1224 HY000
ER_DUP_ARGUMENT 1225 HY000
ER_USER_LIMIT_REACHED 1226 42000
ER_SPECIFIC_ACCESS_DENIED_ERROR 1227 HY000
ER_LOCAL_VARIABLE 1228 HY000
ER_GLOBAL_VARIABLE 1229 HY000
ER_NO_DEFAULT 1230 42000
ER_WRONG_VALUE_FOR_VAR 1231 42000
ER_WRONG_TYPE_FOR_VAR 1232 42000
ER_VAR_CANT_BE_READ 1233 HY000
ER_CANT_USE_OPTION_HERE 1234 42000
ER_NOT_SUPPORTED_YET 1235 42000
ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 HY000
ER_WRONG_FK_DEF 1237 42000
ER_KEY_REF_DO_NOT_MATCH_TABLE_REF 1238 HY000
ER_CARDINALITY_COL 1239 21000
ER_SUBSELECT_NO_1_ROW 1240 21000
ER_UNKNOWN_STMT_HANDLER 1241 HY000
ER_CORRUPT_HELP_DB 1242 HY000
ER_CYCLIC_REFERENCE 1243 HY000
ER_AUTO_CONVERT 1244 HY000
ER_ILLEGAL_REFERENCE 1245 42S22
ER_DERIVED_MUST_HAVE_ALIAS 1246 42000
ER_SELECT_REDUCED 1247 01000
ER_TABLENAME_NOT_ALLOWED_HERE 1248 42000
ER_NOT_SUPPORTED_AUTH_MODE 1249 08004
ER_SPATIAL_CANT_HAVE_NULL 1250 42000
ER_COLLATION_CHARSET_MISMATCH 1251 42000
ER_SLAVE_WAS_RUNNING 1252 HY000
ER_SLAVE_WAS_NOT_RUNNING 1253 HY000
ER_TOO_BIG_FOR_UNCOMPRESS 1254 HY000
ER_ZLIB_Z_MEM_ERROR 1255 HY000
ER_ZLIB_Z_BUF_ERROR 1256 HY000
ER_ZLIB_Z_DATA_ERROR 1257 HY000
ER_CUT_VALUE_GROUP_CONCAT 1258 HY000
ER_WARN_TOO_FEW_RECORDS 1259 01000
ER_WARN_TOO_MANY_RECORDS 1260 01000
ER_WARN_NULL_TO_NOTNULL 1261 01000
ER_WARN_DATA_OUT_OF_RANGE 1262 01000
ER_WARN_DATA_TRUNCATED 1263 01000
ER_WARN_USING_OTHER_HANDLER 1264 01000
ER_CANT_AGGREGATE_COLLATIONS 1265 42000
ER_DROP_USER 1266 42000
ER_REVOKE_GRANTS 1267 42000

拾0五:创造表退步
十0陆:创制数据库退步
1007:数据库已存在,创制数据库战败
100八:数据库不设有,删除数据库失败
十0九:不能够去除数据库文件导致删除数据库战败
拾10:无法去除数据目录导致删除数据库战败
十1壹:删除数据库文件失利
1012:不可能读取系统表中的记录
十20:记录已被别的用户修改
十二一:硬盘剩余空间不足,请加大硬盘可用空间
十2二:关键字重复,更换记录战败
拾2三:关闭时发生错误
十贰四:读文件漏洞百出
1025:改造名字时发生错误
十二六:写文件漏洞百出
拾3二:记录不存在
十3陆:数据表是只读的,不能够对它实行更动
拾三七:系统内部存款和储蓄器不足,请重启数据库或重启服务器
十3八:用于排序的内存不足,请增大排序缓冲区
十40:已达到数据库的最阿比让接数,请加大数据库可用连接数
10四1:系统内部存款和储蓄器不足
104二:无效的主机名
拾4叁:无效连接
十4四:当前用户并未有访问数据库的权杖
拾45:不能够再三再四数据库,用户名或密码错误
拾48:字段无法为空
拾4九:数据库不设有
1050:数据表已存在
十5一:数据表不设有
十54:字段不设有
十六五:无效的SQL语句,SQL语句为空
拾捌壹:无法创设Socket连接
111肆:数据表已满,不能够兼容任何笔录
1116:张开的数据表太多
112九:数据库出现万分,请重启数据库
1130:连接数据库退步,未有连接数据库的权限
113三:数据库用户不存在
11四一:当前用户无权访问数据库
114二:当前用户无权访问数据表
11四三:当前用户无权访问数据表中的字段
11肆六:数据表不设有
1147:未定义用户对数据表的拜会权限
114玖:SQL语句语法错误
115八:网络错误,出现读错误,请检查互联网连接情状
115九:网络错误,读超时,请检查互连网连接处境
1160:网络错误,出现写错误,请检查网络连接意况
116一:互联网错误,写超时,请检查互连网连接情况
106二:字段值重复,入库退步
116九:字段值重复,更新记录战败
117七:张开数据表败北
1180:提交业务战败
11八一:回滚事务退步
120三:当前用户和数据库创建的接二连三已达到数据库的最菲尼克斯接数,请增大可用的数据库连接数或重启数据库
1205:加锁超时
121一:当前用户并未有创设用户的权位
1216:外键约束检查战败,更新子表记录失利
1二17:外键约束检查退步,删除或修改主表记录战败
12贰陆:当前用户使用的财富已抢先所允许的财富,请重启数据库或重启服务器
12二柒:权限不足,您无权实行此操作
123五:MySQL版本过低,不富有本功用
十16荒谬:文件相当的小概开发,使用后台修复可能使用phpmyadmin举办修复。
十4四荒唐:数据库用户权限不足,请联系空间商解决
拾④伍错误:数据库服务器/数据库用户名/数据库名/数据库密码错误,请联系空间商品核查查帐户。
105四荒谬:程序文件跟数据库有冲突,请使用科学的主次文件上传上去覆盖。
11四陆荒唐:数据表缺失,请过来备份数据.
二〇〇三张冠李戴:服务器端口不对,请咨询空间商准确的端口。
200三荒唐:mysql服务没有运营,请运营该服务
越来越多详细错误代码
不当名称 / 错误代码 SQL状态
ER_HASHCHK 1000 HY000
ER_NISAMCHK 1001 HY000
ER_NO 1002 HY000
ER_YES 1003 HY000
ER_CANT_CREATE_FILE 1004 HY000
ER_CANT_CREATE_TABLE 1005 HY000
ER_CANT_CREATE_DB 1006 HY000
ER_DB_CREATE_EXISTS 1007 HY000
ER_DB_DROP_EXISTS 1008 HY000
ER_DB_DROP_DELETE 1009 HY000
ER_DB_DROP_RMDIR 1010 HY000
ER_CANT_DELETE_FILE 1011 HY000
ER_CANT_FIND_SYSTEM_REC 1012 HY000
ER_CANT_GET_STAT 1013 HY000
ER_CANT_GET_WD 1014 HY000
ER_CANT_LOCK 1015 HY000
ER_CANT_OPEN_FILE 1016 HY000
ER_FILE_NOT_FOUND 1017 HY000
ER_CANT_READ_DIR 1018 HY000
ER_CANT_SET_WD 1019 HY000
ER_CHECKREAD 1020 HY000
ER_DISK_FULL 1021 HY000
ER_DUP_KEY 1022 23000
ER_ERROR_ON_CLOSE 1023 HY000
ER_ERROR_ON_READ 1024 HY000
ER_ERROR_ON_RENAME 1025 HY000
ER_ERROR_ON_WRITE 1026 HY000
ER_FILE_USED 1027 HY000
ER_FILSORT_ABORT 1028 HY000
ER_FORM_NOT_FOUND 1029 HY000
ER_GET_ERRNO 1030 HY000
ER_ILLEGAL_HA 1031 HY000
ER_KEY_NOT_FOUND 1032 HY000
ER_NOT_FORM_FILE 1033 HY000
ER_NOT_KEYFILE 1034 HY000
ER_OLD_KEYFILE 1035 HY000
ER_OPEN_AS_READONLY 1036 HY000
ER_OUTOFMEMORY 1037 HY001
ER_OUT_OF_SORTMEMORY 1038 HY001
ER_UNEXPECTED_EOF 1039 HY000
ER_CON_COUNT_ERROR 1040 08004
ER_OUT_OF_RESOURCES 1041 08004
ER_BAD_HOST_ERROR 1042 08S01
ER_HANDSHAKE_ERROR 1043 08S01
ER_DBACCESS_DENIED_ERROR 1044 42000
ER_ACCESS_DENIED_ERROR 1045 42000
ER_NO_DB_ERROR 1046 42000
ER_UNKNOWN_COM_ERROR 1047 08S01
ER_BAD_NULL_ERROR 1048 23000
ER_BAD_DB_ERROR 1049 42000
ER_TABLE_EXISTS_ERROR 1050 42S01
ER_BAD_TABLE_ERROR 1051 42S02
ER_NON_UNIQ_ERROR 1052 23000
ER_SERVER_SHUTDOWN 1053 08S01
ER_BAD_FIELD_ERROR 1054 42S22
ER_WRONG_FIELD_WITH_GROUP 1055 42000
ER_WRONG_GROUP_FIELD 1056 42000
ER_WRONG_SUM_SELECT 1057 42000
ER_WRONG_VALUE_COUNT 1058 21S01
ER_TOO_LONG_IDENT 1059 42000
ER_DUP_FIELDNAME 1060 42S21
ER_DUP_KEYNAME 1061 42000
ER_DUP_ENTRY 1062 23000
ER_WRONG_FIELD_SPEC 1063 42000
ER_PARSE_ERROR 1064 42000
ER_EMPTY_QUERY 1065 42000
ER_NONUNIQ_TABLE 1066 42000
ER_INVALID_DEFAULT 1067 42000
ER_MULTIPLE_PRI_KEY 1068 42000
ER_TOO_MANY_KEYS 1069 42000
ER_TOO_MANY_KEY_PARTS 1070 42000
ER_TOO_LONG_KEY 1071 42000
ER_KEY_COLUMN_DOES_NOT_EXITS 1072 42000
ER_BLOB_USED_AS_KEY 1073 42000
ER_TOO_BIG_FIELDLENGTH 1074 42000
ER_WRONG_AUTO_KEY 1075 42000
ER_READY 1076 00000
ER_NORMAL_SHUTDOWN 1077 00000
ER_GOT_SIGNAL 1078 00000
ER_SHUTDOWN_COMPLETE 1079 00000
ER_FORCING_CLOSE 1080 08S01
ER_IPSOCK_ERROR 1081 08S01
ER_NO_SUCH_INDEX 1082 42S12
ER_WRONG_FIELD_TERMINATORS 1083 42000
ER_BLOBS_AND_NO_TERMINATED 1084 42000
ER_TEXTFILE_NOT_READABLE 1085 HY000
ER_FILE_EXISTS_ERROR 1086 HY000
ER_LOAD_INFO 1087 HY000
ER_ALTER_INFO 1088 HY000
ER_WRONG_SUB_KEY 1089 HY000
ER_CANT_REMOVE_ALL_FIELDS 1090 42000
ER_CANT_DROP_FIELD_OR_KEY 1091 42000
ER_INSERT_INFO 1092 HY000
ER_UPDATE_TABLE_USED 1093 HY000
ER_NO_SUCH_THREAD 1094 HY000
ER_KILL_DENIED_ERROR 1095 HY000
ER_NO_TABLES_USED 1096 HY000
ER_TOO_BIG_SET 1097 HY000
ER_NO_UNIQUE_LOGFILE 1098 HY000
ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 HY000
ER_TABLE_NOT_LOCKED 1100 HY000
ER_BLOB_CANT_HAVE_DEFAULT 1101 42000
ER_WRONG_DB_NAME 1102 42000
ER_WRONG_TABLE_NAME 1103 42000
ER_TOO_BIG_SELECT 1104 42000
ER_UNKNOWN_ERROR 1105 HY000
ER_UNKNOWN_PROCEDURE 1106 42000
ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107 42000
ER_WRONG_PARAMETERS_TO_PROCEDURE 1108 HY000
ER_UNKNOWN_TABLE 1109 42S02
ER_FIELD_SPECIFIED_TWICE 1110 42000
ER_INVALID_GROUP_FUNC_USE 1111 42000
ER_UNSUPPORTED_EXTENSION 1112 42000
ER_TABLE_MUST_HAVE_COLUMNS 1113 42000
ER_RECORD_FILE_FULL 1114 HY000
ER_UNKNOWN_CHARACTER_SET 1115 42000
ER_TOO_MANY_TABLES 1116 HY000
ER_TOO_MANY_FIELDS 1117 HY000
ER_TOO_BIG_ROWSIZE 1118 42000
ER_STACK_OVERRUN 1119 HY000
ER_WRONG_OUTER_JOIN 1120 42000
ER_NULL_COLUMN_IN_INDEX 1121 42000
ER_CANT_FIND_UDF 1122 HY000
ER_CANT_INITIALIZE_UDF 1123 HY000
ER_UDF_NO_PATHS 1124 HY000
ER_UDF_EXISTS 1125 HY000
ER_CANT_OPEN_LIBRARY 1126 HY000
ER_CANT_FIND_DL_ENTRY 1127 HY000
ER_FUNCTION_NOT_DEFINED 1128 HY000
ER_HOST_IS_BLOCKED 1129 HY000
ER_HOST_NOT_PRIVILEGED 1130 HY000
ER_PASSWORD_ANONYMOUS_USER 1131 42000
ER_PASSWORD_NOT_ALLOWED 1132 42000
ER_PASSWORD_NO_MATCH 1133 42000
ER_UPDATE_INFO 1134 HY000
ER_CANT_CREATE_THREAD 1135 HY000
ER_WRONG_VALUE_COUNT_ON_ROW 1136 21S01
ER_CANT_REOPEN_TABLE 1137 HY000
ER_INVALID_USE_OF_NULL 1138 42000
ER_REGEXP_ERROR 1139 42000
ER_MIX_OF_GROUP_FUNC_AND_FIELDS 1140 42000
ER_NONEXISTING_GRANT 1141 42000
ER_TABLEACCESS_DENIED_ERROR 1142 42000
ER_COLUMNACCESS_DENIED_ERROR 1143 42000
ER_ILLEGAL_GRANT_FOR_TABLE 1144 42000
ER_GRANT_WRONG_HOST_OR_USER 1145 42000
ER_NO_SUCH_TABLE 1146 42S02
ER_NONEXISTING_TABLE_GRANT 1147 42000
ER_NOT_ALLOWED_COMMAND 1148 42000
ER_SYNTAX_ERROR 1149 42000
ER_DELAYED_CANT_CHANGE_LOCK 1150 HY000
ER_TOO_MANY_DELAYED_THREADS 1151 HY000
ER_ABORTING_CONNECTION 1152 08S01
ER_NET_PACKET_TOO_LARGE 1153 08S01
ER_NET_READ_ERROR_FROM_PIPE 1154 08S01
ER_NET_FCNTL_ERROR 1155 08S01
ER_NET_PACKETS_OUT_OF_ORDER 1156 08S01
ER_NET_UNCOMPRESS_ERROR 1157 08S01
ER_NET_READ_ERROR 1158 08S01
ER_NET_READ_INTERRUPTED 1159 08S01
ER_NET_ERROR_ON_WRITE 1160 08S01
ER_NET_WRITE_INTERRUPTED 1161 08S01
ER_TOO_LONG_STRING 1162 42000
ER_TABLE_CANT_HANDLE_BLOB 1163 42000
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164 42000
ER_DELAYED_INSERT_TABLE_LOCKED 1165 HY000
ER_WRONG_COLUMN_NAME 1166 42000
ER_WRONG_KEY_COLUMN 1167 42000
ER_WRONG_MRG_TABLE 1168 HY000
ER_DUP_UNIQUE 1169 23000
ER_BLOB_KEY_WITHOUT_LENGTH 1170 42000
ER_PRIMARY_CANT_HAVE_NULL 1171 42000
ER_TOO_MANY_ROWS 1172 42000
ER_REQUIRES_PRIMARY_KEY 1173 42000
ER_NO_RAID_COMPILED 1174 HY000
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE 1175 HY000
ER_KEY_DOES_NOT_EXITS 1176 HY000
ER_CHECK_NO_SUCH_TABLE 1177 42000
ER_CHECK_NOT_IMPLEMENTED 1178 42000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179 25000
ER_ERROR_DURING_COMMIT 1180 HY000
ER_ERROR_DURING_ROLLBACK 1181 HY000
ER_ERROR_DURING_FLUSH_LOGS 1182 HY000
ER_ERROR_DURING_CHECKPOINT 1183 HY000
ER_NEW_ABORTING_CONNECTION 1184 08S01
ER_DUMP_NOT_IMPLEMENTED 1185 HY000
ER_FLUSH_MASTER_BINLOG_CLOSED 1186 HY000
ER_INDEX_REBUILD 1187 HY000
ER_MASTER 1188 HY000
ER_MASTER_NET_READ 1189 08S01
ER_MASTER_NET_WRITE 1190 08S01
ER_FT_MATCHING_KEY_NOT_FOUND 1191 HY000
ER_LOCK_OR_ACTIVE_TRANSACTION 1192 HY000
ER_UNKNOWN_SYSTEM_VARIABLE 1193 HY000
ER_CRASHED_ON_USAGE 1194 HY000
ER_CRASHED_ON_REPAIR 1195 HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK 1196 HY000
ER_TRANS_CACHE_FULL 1197 HY000
ER_SLAVE_MUST_STOP 1198 HY000
ER_SLAVE_NOT_RUNNING 1199 HY000
ER_BAD_SLAVE 1200 HY000
ER_MASTER_INFO 1201 HY000
ER_SLAVE_THREAD 1202 HY000
ER_TOO_MANY_USER_CONNECTIONS 1203 42000
ER_SET_CONSTANTS_ONLY 1204 HY000
ER_LOCK_WAIT_TIMEOUT 1205 HY000
ER_LOCK_TABLE_FULL 1206 HY000
ER_READ_ONLY_TRANSACTION 1207 25000
ER_DROP_DB_WITH_READ_LOCK 1208 HY000
ER_CREATE_DB_WITH_READ_LOCK 1209 HY000
ER_WRONG_ARGUMENTS 1210 HY000
ER_NO_PERMISSION_TO_CREATE_USER 1211 42000
ER_UNION_TABLES_IN_DIFFERENT_DIR 1212 HY000
ER_LOCK_DEADLOCK 1213 40001
ER_TABLE_CANT_HANDLE_FULLTEXT 1214 HY000
ER_CANNOT_ADD_FOREIGN 1215 HY000
ER_NO_REFERENCED_ROW 1216 23000
ER_ROW_IS_REFERENCED 1217 23000
ER_CONNECT_TO_MASTER 1218 08S01
ER_QUERY_ON_MASTER 1219 HY000
ER_ERROR_WHEN_EXECUTING_COMMAND 1220 HY000
ER_WRONG_USAGE 1221 HY000
ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT 1222 21000
ER_CANT_UPDATE_WITH_READLOCK 1223 HY000
ER_MIXING_NOT_ALLOWED 1224 HY000
ER_DUP_ARGUMENT 1225 HY000
ER_USER_LIMIT_REACHED 1226 42000
ER_SPECIFIC_ACCESS_DENIED_ERROR 1227 HY000
ER_LOCAL_VARIABLE 1228 HY000
ER_GLOBAL_VARIABLE 1229 HY000
ER_NO_DEFAULT 1230 42000
ER_WRONG_VALUE_FOR_VAR 1231 42000
ER_WRONG_TYPE_FOR_VAR 1232 42000
ER_VAR_CANT_BE_READ 1233 HY000
ER_CANT_USE_OPTION_HERE 1234 42000
ER_NOT_SUPPORTED_YET 1235 42000
ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 HY000
ER_WRONG_FK_DEF 1237 42000
ER_KEY_REF_DO_NOT_MATCH_TABLE_REF 1238 HY000
ER_CARDINALITY_COL 1239 21000
ER_SUBSELECT_NO_1_ROW 1240 21000
ER_UNKNOWN_STMT_HANDLER 1241 HY000
ER_CORRUPT_HELP_DB 1242 HY000
ER_CYCLIC_REFERENCE 1243 HY000
ER_AUTO_CONVERT 1244 HY000
ER_ILLEGAL_REFERENCE 1245 42S22
ER_DERIVED_MUST_HAVE_ALIAS 1246 42000
ER_SELECT_REDUCED 1247 01000
ER_TABLENAME_NOT_ALLOWED_HERE 1248 42000
ER_NOT_SUPPORTED_AUTH_MODE 1249 08004
ER_SPATIAL_CANT_HAVE_NULL 1250 42000
ER_COLLATION_CHARSET_MISMATCH 1251 42000
ER_SLAVE_WAS_RUNNING 1252 HY000
ER_SLAVE_WAS_NOT_RUNNING 1253 HY000
ER_TOO_BIG_FOR_UNCOMPRESS 1254 HY000
ER_ZLIB_Z_MEM_ERROR 1255 HY000
ER_ZLIB_Z_BUF_ERROR 1256 HY000
ER_ZLIB_Z_DATA_ERROR 1257 HY000
ER_CUT_VALUE_GROUP_CONCAT 1258 HY000
ER_WARN_TOO_FEW_RECORDS 1259 01000
ER_WARN_TOO_MANY_RECORDS 1260 01000
ER_WARN_NULL_TO_NOTNULL 1261 01000
ER_WARN_DATA_OUT_OF_RANGE 1262 01000
ER_WARN_DATA_TRUNCATED 1263 01000
ER_WARN_USING_OTHER_HANDLER 1264 01000
ER_CANT_AGGREGATE_COLLATIONS 1265 42000
ER_DROP_USER 1266 42000
ER_REVOKE_GRANTS 1267 42000

define ER_NEW_ABORTING_CONNECTION 1184

“Aborted connection %ld to db: ‘%-.64s’ user: ‘%-.32s’ host: `%-.64s’
(%-.64s)”,

表达:以上只是常见错误号,并且化解办法也不必然料定有效!具体请参谋MYSQL手册(各大下载站均有下载)

define ER_NET_WRITE_INTERRUPTED 1161

“Got timeout writing communication packets”,

你大概感兴趣的篇章:

  • 化解Windows 拾家庭版安装SQL Server 201四出现.net
    三.5波折难题
  • Windows2012配置SQLServer2014AlwaysOn的图解
  • 设置mysql出错”A Windows service with the name MySQL already
    exists.“怎样消除
  • MYSQL
    创制函数出错的消除方案
  • Rails bundle命令安装mysql
    gem包出错的化解办法
  • MySQL数据库的失误代码列表
  • windows server201四 安装 Mysql Applying
    Security出错的公而忘私化解措施

define ER_TABLEACCESS_DENIED_ERROR 1142

“%-.16s command denied to user: ‘%-.32s’@’%-.64s’ for table ‘%-.64s'”,

广阔错误!

define ER_MULTIPLE_PRI_KEY 1068

“Multiple primary key defined”,

十1陆错误:文件无法开发,使用后台修复或许应用phpmyadmin实行修复。
十4④荒谬:数据库用户权限不足,请联系空间商消除
十45不当:数据库服务器/数据库用户名/数据库名/数据库密码错误,请联系空间商品核查查帐户。
十5四错误:程序文件跟数据库有争辩,请使用科学的次第文件上传上去覆盖。
11四六荒谬:数据表缺点和失误,请过来备份数据.
拾0伍:成立表退步
拾06:创造数据库失利
1007:数据库已存在,创制数据库战败
十0八:数据库不存在,删除数据库失利
100九:不可能去除数据库文件导致删除数据库失败
10拾:无法去除数据目录导致删除数据库退步
101一:删除数据库文件战败
拾12:无法读取系统表中的笔录
1020:记录已被其余用户修改
十二一:硬盘剩余空间不足,请加大硬盘可用空间
拾2二:关键字重复,更改记录失利
10贰三:关闭时发出错误
拾二四:读文件漏洞百出
永利线上娱乐网址,十二五:更动名字时发生错误
10二六:写文件漏洞百出
103贰:记录不设有
拾3陆:数据表是只读的,不能对它实行修改
1037:系统内存不足,请重启数据库或重启服务器
103八:用于排序的内部存款和储蓄器不足,请增大排序缓冲区
1040:已达到数据库的最明斯克接数,请加大数据库可用连接数
104壹:系统内部存款和储蓄器不足
104二:无效的主机名
十四三:无效连接
104④:当前用户并没有访问数据库的权位
10四五:不可能接贰连三数据库,用户名或密码错误
十48:字段不能够为空
104九:数据库不存在
1050:数据表已存在
1051:数据表不存在
十5四:字段不存在
10陆五:无效的SQL语句,SQL语句为空
拾8一:不可能成立Socket连接
111肆:数据表已满,无法兼容任何笔录
111陆:展开的数据表太多
112玖:数据库现身非凡,请重启数据库
1130:连接数据库失利,未有连接数据库的权限
113叁:数据库用户不存在
11四1:当前用户无权访问数据库
114二:当前用户无权访问数据表
11四叁:当前用户无权访问数据表中的字段
11四6:数据表不设有
11四七:未定义用户对数据表的访问权限
114玖:SQL语句语法错误
1158:互联网错误,出现读错误,请检查网络连接境况
115玖:互连网错误,读超时,请检查网络连接境况
1160:互联网错误,出现写错误,请检查互连网连接处境
116一:网络错误,写超时,请检查互连网连接情况
拾62:字段值重复,入库失利
116九:字段值重复,更新记录战败
117七:张开数据表失利
1180:提交业务失利
118壹:回滚事务退步
120三:当前用户和数据库创建的接连已达到数据库的最达累斯萨Lamb接数,请增大可用的数据库连接数或重启数据库
1205:加锁超时
121一:当前用户未有开创用户的权限
121陆:外键约束检查失利,更新子表记录失利
1217:外键约束检查失败,删除或更换主表记录失利
12二6:当前用户选拔的财富已超越所允许的财富,请重启数据库或重启服务器
1227:权限不足,您无权实行此操作
123五:MySQL版本过低,不具有本成效
2001:Can’t connect to …平时意味着未有二个MySQL服务器运维在系统上或当试图连接mysqld服务器时,你正在利用多个不当的套接字文件或TCP/IP端口。 

define ER_UDF_NO_PATHS 1124

“No paths allowed for shared瘀牡?剕\u0003????o鸞?\u0001 liary”,

define ER_UDF_EXISTS 1125

“Function ‘%-.64s’ already exist”,

define ER_WRONG_FIELD_WITH_GROUP 1055

“‘%-.64s’ isn’t in GROUP BY”,

define ER_KEY_NOT_FOUND 1032

“Can’t find record in ‘%-.64s'”,

define ER_CANT_REMOVE_ALL_FIELDS 1090

“You can’t delete all columns with ALTER TABLE. Use DROP TABLE
instead”,

define ER_SLAVE_MUST_STOP 1198

“This operation cannot be performed with a running slave, run STOP
SLAVE first”,

define ER_INDEX_REBUILD 1187

“Faile瘀牡?剕\u0003????o鸞?\u0001d rebuilding the index of dumped
table ‘%-.64s'”,

define ER_NULL_COLUMN_IN_INDEX 1121

“Column ‘%-.64s’ is used with UNIQUE or INDEX but is not defined as NOT
NULL”,

define ER_CANNOT_ADD_FOREIGN 1215

“Cannot add foreign key constraint”,

define ER_CANT_FIND_SYSTEM_REC 1012

“Can’t read record in system table”,

define ER_WRONG_GROUP_FIELD 1056

“Can’t group on ‘%-.64s'”,

define ER_NO_REFERENCED_ROW 1216

“Cannot add or update a child row: a foreign key constraint fails”,

define ER_MASTER_INFO 1201

“Could not initialize master info structure, more error messages can be
found in the MySQL error log”,

define ER_GRANT_WRONG_HOST_OR_USER 1145

“The host or user argument to GRANT is too long”,

define ER_TOO_MANY_FIELDS 1117

“Too many columns”,

define ER_TOO_LONG_IDENT 1059

“Identifier name ‘%-.100s’ is too long”,

define ER_UPDATE_INFO 1134

“Rows matched: %ld Changed: %ld Warnings: %ld”,

if the SELECT is ok”,

define ER_UNKNOWN_TABLE 1109

“Unknown table ‘%-.64s’ in %-.32s”,

define ER_INVALID_USE_OF_NULL 1138

“Invalid use of NULL value”,

define ER_NORMAL_SHUTDOWN 1077

“%s: Normal shutdown
“,

define ER_WRONG_KEY_COLUMN 1167

“The used storage engine can’t index column ‘%-.64s'”,

define ER_MIXING_NOT_ALLOWED 1224

“Mixing of transactional and non-transactional tables is disabled”,

define ER_TOO_BIG_ROWSIZE 1118

“Too big row size. The maximum row size for the used table type, not
counting BLOBs, is %ld. You have to change some fields to TEXT or
BLOBs”,

define ER_CANT_FIND_UDF 1122

“Can’t load function ‘%-.64s'”,

define ER_BLOB_USED_AS_KEY 1073

“BLOB column ‘%-.64s’ can’t be used in key specification with the used
table type”,

define ER_TABLE_CANT_HANDLE_BLOB 1163

“The used table type doesn’t support BLOB/TEXT columns”,

define ER_FORCING_CLOSE 1080

“%s: 瘀牡?剕\u0003????o鸞?\u0001Forcing close of thread %ld user:
‘%-.32s’
“,

define ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107

“Incorrect parameter count to procedure ‘%-.64s'”,

define ER_BAD_NULL_ERROR 1048

“Column ‘%-.64s’ cannot be null”,

define ER_NET_READ_ERROR_FROM_PIPE 1154

“Got a read error from the connection pipe”,

define ER_CHECK_NOT_IMPLEMENTED 1178

“The storage engine for the table doesn’t support %s”,

define ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164

“The used table type doesn’t support AUTO_INCREMENT columns”,

define ER_COLUMNACCESS_DENIED_ERROR 1143

“%-.16s command denied to user: ‘%-.32s’@’%-.64s’ for column ‘%-.64s’ in
table ‘%-.64s'”,

define ER_ILLEGAL_GRANT_FOR_TABLE 1144

“I瘀牡?剕\u0003????o鸞?\u0001llegal GRANT/REVOKE command. Please
consult the manual which privileges can be used”,

define ER_NET_READ_ERROR 1158

“Got an error reading communication packets”,

define ER_NO_SUCH_INDEX 1082

“Table ‘%-.64s’ has no index like the one used in CREATE INDEX. Recreate
the table”,

define ER_OPEN_AS_READONLY 1036

“Table ‘%-.64s’ is read only”,

define ER_NO_TABLES_USED 1096

“No tables used”,

define ER_DB_CREATE_EXISTS 1007

“Can’t create database ‘%-.64s’; database exists”,

define ER_ERROR_DURING_ROLLBACK 1181

“Got error %d during ROLLBACK”,

转载自(http://blog.csdn.net/java20131115/article/details/23111041)
mysql出错了,从前往往靠猜.有了那张表,一查就出去了.方便诸多.特共享于众~~
拾05:创建表失利
100陆:创设数据库退步
十07:数据库已存在,创制数据库战败
拾08:数据库不存在,删除数据库退步
100九:无法去除数据库文件导致删除数据库战败
10十:不可能去除数据目录导致删除数据库失利
十1一:删除数据库文件败北
1012:不能够读取系统表中的记录
1020:记录已被别的用户修改
拾贰一:硬盘剩余空间不足,请加大硬盘可用空间
102贰:关键字重复,更动记录失败
十23:关闭时发出错误
拾贰四:读文件漏洞百出
拾二伍:更换名字时发生错误
10贰陆:写文件漏洞百出
103二:记录不设有
拾3陆:数据表是只读的,不可能对它进行修改
10三7:系统内部存款和储蓄器不足,请重启数据库或重启服务器
十3八:用于排序的内部存款和储蓄器不足,请增大排序缓冲区
1040:已达到数据库的最第Billy斯接数,请加大数据库可用连接数
拾肆一:系统内部存款和储蓄器不足
1042:无效的主机名
10四三:无效连接
104四:当前用户并未有访问数据库的权能
104伍:不能一连数据库,用户名或密码错误
十4八:字段不能够为空
十49:数据库不设有
1050:数据表已存在
十5一:数据表不设有
十54:字段不设有
拾六伍:无效的SQL语句,SQL语句为空
十八一:不能够树立Socket连接
111四:数据表已满,不能够包容任何笔录
111⑥:展开的数据表太多
112玖:数据库出现十分,请重启数据库
1130:连接数据库退步,没有连接数据库的权力
113三:数据库用户不存在
11肆1:当前用户无权访问数据库
1142:当前用户无权访问数据表
1143:当前用户无权访问数据表中的字段
114六:数据表不设有
11四七:未定义用户对数据表的走访权限
114九:SQL语句语法错误
115八:网络错误,现身读错误,请检查网络连接情形
115九:网络错误,读超时,请检查互连网连接意况
1160:互连网错误,出现写错误,请检查网络连接意况
11陆壹:互连网错误,写超时,请检查互连网连接情况
十6贰:字段值重复,入库败北
116九:字段值重复,更新记录战败
117柒:张开数据表失利
1180:提交业务失利
11八1:回滚事务败北
120三:当前用户和数据库创建的连天已达到数据库的最哈拉雷接数,请增大可用的数据库连接数或重启数据库
120伍:加锁超时
1211:当前用户未有开创用户的权力
121陆:外键约束检查失利,更新子表记录败北
1217:外键约束检查战败,删除或修改主表记录战败
12贰陆:当前用户选择的财富已超过所允许的财富,请重启数据库或重启服务器
12二七:权限不足,您无权实行此操作
1235:MySQL版本过低,不负有本成效
第三有个别 新肆.1.1一,摘自DOCSmysqld_error.txt

define ER_DUP_ARGUMENT 1225

“Option ‘%s’ used twice in statement”,

define ER_CON_COUNT_ERROR 1040

“Too many connections”,

define ER_TOO_BIG_SELECT 1104

“The SELECT would examine more rows than MAX_JOIN_SIZE. Check your
WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=

define ER_DUP_KEY 1022

“Can’t write, duplicate key in table ‘%-.64s'”,

define ER_CANT_CREATE_THREAD 1135

“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”,

define ER_TABLE_MUST_HAVE_COLUMNS 1113

“A table must have at least 1 column”,

define ER_UNKNOWN_COM_ERROR 1047

“Unknown command”,

define ER_HANDSHAKE_ERROR 1043

“Bad handshake”,

define ER_DUP_UNIQUE 1169

“Can’t write, because of unique constraint, to table ‘%-.64s'”,

define ER_FLUSH_MASTER_BINLOG_CLOSED 1186

“Binlog closed, cannot RESET MASTER”,

define ER_MASTER_NET_READ 1189

“Net error reading from master”,

define ER_PASSWORD_ANONYMOUS_USER 1131

“You are using MySQL as an anonymous users and anonymous users are not
allowed to change passwords”,

define ER_NONEXISTING_TABLE_GRANT 1147

“There is no such grant defined for user ‘%-.32s’ on host ‘%-.64s’ on
table ‘%-.64s'”,

define ER_永利真人娱乐,KILL_DENIED_ERROR 1095

“You are not owner of thread %lu”,

define ER_ERROR_DURING_CHECKPOINT 1183

“Got error %d during CHECKPOINT”,

define ER_CHECK_NO_SUCH_TABLE 1177

“Can’t open table”,

define ER_NOT_KEYFILE 1034

“Incorrect key file for table: ‘%-.64s’; try to repair it”,

define ER_CREATE_DB_WITH_READ_LOCK 1209

“CREATE DATABASE not allowed while thread is holding global read lock”,

define ER_HASHCHK 1000

“hashchk”,

define ER_ACCESS_DENIED_ERROR 1045

“Access denied for user: ‘%-.32s’@’%-.64s’ (Using password: %s)”,

define ER_DELAYED_INSERT_TABLE_LOCKED 1165

“INSERT DELAYED can’t be used with table
‘%-.64s瘀牡?剕\u0003????o鸞?\u0001’ because it is locked with LOCK
TABLES”,

define ER_BLOBS_AND_NO_TERMINATED 1084

“You can’t use fixed rowlength with BLOBs. Please use ‘fields terminated
by'”,

define ER_MASTER 1188

“Error from master: ‘%-.64s'”,

define ER_NO_RAID_COMPILED 1174

“This version of MySQL is not compiled with RAID support”,

define ER_BLOB_KEY_WITHOUT_LENGTH 1170

“BLOB/TEXT column ‘%-.64s’ used in key specification without a key
length”,

define ER_WRONG_VALUE_COUNT_ON_ROW 1136

“Column count doesn’t match value count at row %ld”,

define ER_WRONG_COLUMN_NAME 1166

“Incorrect column name ‘%-.100s'”,

define ER_WRONG_FIELD_SPEC 1063

“Incorrect column specifier for column ‘%-.64s'”,

define ER_TOO_MANY_TABLES 1116

“Too many tables. MySQL can only use %d tables in a join”,

define ER_DUP_KEYNAME 1061

“Duplicate key name ‘%-.64s'”,

define ER_CANT_CREATE_TABLE 1005

“Can’t create table ‘%-.64s’ (errno: %d)”,

define ER_CANT_OPEN_FILE 1016

“Can’t open file: ‘%-.64s’ (errno: %d)”,

define ER_TRANS_CACHE_FULL 1197

“Multi-statement transaction required more than
‘max_binlog_cache_size’ bytes of storage. Increase this mysqld
variable and try again”,

相关文章