[转帖]mysql数据库操作常见错误代码、mysql常见错误_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛_联动北方技术论坛  
网站首页 | 关于我们 | 服务中心 | 经验交流 | 公司荣誉 | 成功案例 | 合作伙伴 | 联系我们 |
联动北方-国内领先的云技术服务提供商
»  游客             当前位置:  论坛首页 »  自由讨论区 »  MySQL, Oracle及数据库讨论区 »
总帖数
1
每页帖数
101/1页1
返回列表
0
发起投票  发起投票 发新帖子
查看: 2645 | 回复: 0   主题: [转帖]mysql数据库操作常见错误代码、mysql常见错误        下一篇 
tk
注册用户
等级:中士
经验:207
发帖:80
精华:0
注册:2011-10-19
状态:离线
发送短消息息给tk 加好友    发送短消息息给tk 发消息
发表于: IP:您无权察看 2014-11-5 10:27:18 | [全部帖] [楼主帖] 楼主

1016错误:文件无法打开,使用后台修复或者使用phpmyadmin进行修复。3 c  K, n, C  S, Y: y
1044错误:数据库用户权限不足,请联系空间商解决8 y0 l9 @1 z! |: i6 K  {9 n6 F
1045错误:数据库服务器/数据库用户名/数据库名/数据库密码错误,请联系空间商检查帐户。
/ ~4 X8 X7 I( u9 U. ^1054错误:程序文件跟数据库有冲突,请使用正确的程序文件上传上去覆盖。
9 z  v  t% V9 J+ Z1146错误:数据表缺失,请恢复备份数据.) x* w* p( u: P' }1 N' R3 l
2002错误:服务器端口不对,请咨询空间商正确的端口。4 E6 F0 p. \, O& O8 r& m% ?
2003错误:mysql服务没有启动,请启动该服务' a3 V1 Y* g2 D
1005:创建表失败
+ N( v9 J3 s9 @) S+ e; J4 z1006:创建数据库失败
3 E- m, Y0 x6 L- Y  L# i/ L/ t" b1007:数据库已存在,创建数据库失败
* I7 f3 e) Z* B" V1008:数据库不存在,删除数据库失败8 E9 g1 z/ ]% f3 r& o3 E$ H
1009:不能删除数据库文件导致删除数据库失败  {) E1 L4 j0 s" n2 t1 w0 i) E/ m
1010:不能删除数据目录导致删除数据库失败; x/ j# B& i  H# Y+ d
1011:删除数据库文件失败. k. u3 o" D' u1 b5 N5 y; U0 M( e
1012:不能读取系统表中的记录$ L9 C+ Q2 S) M4 Y' c
1020:记录已被其他用户修改, Q/ ?& ]* j; @" u" U
1021:硬盘剩余空间不足,请加大硬盘可用空间  ]+ f! f2 L& I# ^" ~
1022:关键字重复,更改记录失败" @% x" B' M, h# m2 ^
1023:关闭时发生错误

 / ]# _4 f0 {% ?& Q7 L, |% ]1024:读文件错误


: d2 n0 h, _! Y* `" M1 O1 L8 i! `1025:更改名字时发生错误
9 J4 }3 G7 k( S: a. e' H1026:写文件错误; z" R! ~5 F, Q  @% S& Y+ d4 k
1032:记录不存在; V$ z' j/ u6 }8 V6 ]4 j: h, r; U- |
1036:数据表是只读的,不能对它进行修改
- W; A9 w7 {* E0 V! ^0 r8 ^% x: o1037:系统内存不足,请重启数据库或重启服务器
' O) u* Q5 t" E- _" g- l, x1038:用于排序的内存不足,请增大排序缓冲区
$ V0 o) J: s/ h& ^2 W1040:已到达数据库的最大连接数,请加大数据库可用连接数

 0 _( v. U" C, {  ?* p' @' f1041:系统内存不足
( _( G* i; i3 S# X! U6 b1042:无效的主机名" x7 l9 r9 l  T8 U: v3 u; @1 F/ x
1043:无效连接) U) ]- y0 H- i4 s& V


1044:当前用户没有访问数据库的权限

 & l( w4 c6 M% }1045:不能连接数据库,用户名或密码错误; z! B, m( d- _9 G( ~- Z
1048:字段不能为空$ s/ T8 e! U! k0 ]( {. G
1049:数据库不存在$ J( T8 T/ B; S# n
1050:数据表已存在
9 i% P  o* J, q' l2 v$ ^: m1051:数据表不存在  T; v3 g" V7 I! q
1054:字段不存在8 D) V/ `4 x5 y  |4 z6 }


1065:无效的SQL语句,SQL语句为空! N1 K" D- `/ L$ b- c
1081:不能建立Socket连接

 / s. l: r8 ~$ @4 t/ Z- ^) j1114:数据表已满,不能容纳任何记录


% m! v0 \  y$ {* p1116:打开的数据表太多

 / A, @/ w1 R4 C; C1 J/ @1129:数据库出现异常,请重启数据库


3 ~7 h. W1 h: B4 G1130:连接数据库失败,没有连接数据库的权限/ v  O8 _+ g; \2 G* c
1133:数据库用户不存在3 w/ P# b( T$ B3 H( N
1141:当前用户无权访问数据库
+ K" K- z0 i3 K6 M4 q7 ^9 X# t( c2 h1142:当前用户无权访问数据表; L" n* q/ r$ }0 ~0 l
1143:当前用户无权访问数据表中的字段* b1 T! r9 |6 u' _
1146:数据表不存在
: Q7 B/ K$ K' \- _1147:未定义用户对数据表的访问权限
* j+ P3 o, v5 y% M% ?1149:SQL语句语法错误% `4 H' {- l) Y1 \2 s
1158:网络错误,出现读错误,请检查网络连接状况
6 b7 T0 [2 C8 K$ m5 h( z' K1159:网络错误,读超时,请检查网络连接状况
+ ]* I5 D* g) D) o1160:网络错误,出现写错误,请检查网络连接状况

 3 b4 q/ k# |; s3 O/ f- u$ n) _1 E1161:网络错误,写超时,请检查网络连接状况


. e: L& \$ z0 a7 i. J1062:字段值重复,入库失败
3 G7 ^% N9 D7 c1169:字段值重复,更新记录失败

 " s4 b  N1 u- h! M  U( d" t5 r4 d1177:打开数据表失败; j' n- S9 ^  j& a' N) R


1180:提交事务失败
* K9 {2 x6 ^& V2 p3 G7 x% H6 l; l1181:回滚事务失败
% L& v  `1 r1 ]6 F' I" V; U1203:当前用户和数据库建立的连接已到达数据库的最大连接数,请增大可用的数据库连接数或重启数据库1 h  S( a8 I$ K- x" d  E# ~* P- B, a
1205:加锁超时
& T# }# E0 E$ h  ^1211:当前用户没有创建用户的权限9 }3 i' R' N- t& U! R+ d" B. n* t
1216:外键约束检查失败,更新子表记录失败
# g! ~, Z4 y5 k  W+ @1217:外键约束检查失败,删除或修改主表记录失败
7 _! E+ \6 V. u1226:当前用户使用的资源已超过所允许的资源,请重启数据库或重启服务器
3 E& u% n- v( x" X/ P9 I2 ?+ ~1227:权限不足,您无权进行此*作
" t: t% Y  v, Z1235:MySQL版本过低,不具有本功能
' ]& q8 \, @) l( H

 ; ]7 z! {" o) a9 e, m


: Q, v3 ~0 ^0 t5 k7 o4 Z0 o3 y7 O  W说明:以上只是常见错误号,并且解决办法也不一定肯定管用!具体请参考MYSQL手册(各大下载站均有下载)

 $ i/ D9 E6 w4 k5 V P* h) {* e( I- \3 |

0 m/ Z+ r0 p$ T: t% X- e4 ?更多详细错误代码 1 u# k, z2 i4 B( D7 x7 a. h$ B
错误名称 /             错误代码     SQL状态& a0 M, _9 {+ E: b( L
ER_HASHCHK           1000           HY000
, N3 {+ Z' m9 w; B7 \7 h+ gER_NISAMCHK           1001           HY000
+ Q7 ]1 F. ^( ^ER_NO             1002           HY000
5 _; a4 A1 |+ _! b  \/ j' KER_YES             1003           HY000: E5 `4 V% S) Y: T
      ER_CANT_CREATE_FILE 1004 HY000
      " n% n4 K, G* v P* [/ V8 PER_CANT_CREATE_TABLE 1005 HY0003 J' ]; E1 I0 D6 f! H$ O
      ER_CANT_CREATE_DB 1006 HY0005 e# K* l/ ^. P: r3 a; H1 J0 o
      ER_DB_CREATE_EXISTS 1007 HY000
      7 e$ U" T7 n% `$ I; TER_DB_DROP_EXISTS 1008 HY000) q# ]$ K8 ?6 i5 Q6 q- @9 d; B3 T
      ER_DB_DROP_DELETE 1009 HY000
      . _$ O& e/ F1 L/ b& L( ZER_DB_DROP_RMDIR 1010 HY0000 n' P' U7 A( L( B
      ER_CANT_DELETE_FILE 1011 HY000% d1 y+ z: Y$ Z3 c8 D
      ER_CANT_FIND_SYSTEM_REC 1012 HY000
      2 x* A) Y; J' hER_CANT_GET_STAT 1013 HY000 Z3 o0 B. I: ]: W2 P l- H3 _0 W
      ER_CANT_GET_WD 1014 HY0004 z" J8 ^' b3 T* [" U. n; y C
      ER_CANT_LOCK 1015 HY0003 [) K/ M6 ~' ^$ G- d
      ER_CANT_OPEN_FILE 1016 HY0007 k E. [' m+ w
      ER_FILE_NOT_FOUND 1017 HY000; c! T( _& X* z, ~- F! C, h) N
      ER_CANT_READ_DIR 1018 HY000
      - c \: l! B$ q, a8 a7 E h; v1 lER_CANT_SET_WD 1019 HY000
      ) k, p! B& C' pER_CHECKREAD 1020 HY000% n# I& V2 O( u0 {
            ER_DISK_FULL 1021 HY000
            2 s/ n! E0 r( FER_DUP_KEY 1022 23000
            ; D6 v9 l5 J; FER_ERROR_ON_CLOSE 1023 HY000
            : X% R/ Z1 _& d. m" k! TER_ERROR_ON_READ 1024 HY000
            5 U0 T4 N: o8 b! jER_ERROR_ON_RENAME 1025 HY0000 L" p; o3 F. g
            ER_ERROR_ON_WRITE 1026 HY000
            " n7 [. {3 f; z- \/ D( z% X% YER_FILE_USED 1027 HY000
                  3 ]; ~ T& c1 Z* sER_FILSORT_ABORT 1028 HY000/ ^: A- M/ \6 _# m; Q+ Y7 D! E- G
                  ER_FORM_NOT_FOUND 1029 HY000
                  8 f* A. y6 U4 p& d7 ^: cER_GET_ERRNO 1030 HY000
                  * h. M. L, ?6 f. N! ]' e$ J, c8 [& jER_ILLEGAL_HA 1031 HY000
                  & {3 Q3 T b# rER_KEY_NOT_FOUND 1032 HY000
                        , Q5 v' k. R( e% H& ?6 AER_NOT_FORM_FILE 1033 HY000# H; u( Z: ^+ a9 G/ Y4 F7 \- w
                  ER_NOT_KEYFILE 1034 HY000' m6 _2 E( }/ P9 y3 ~
                  ER_OLD_KEYFILE 1035 HY000- N! E: o) a2 R S+ l/ {- V3 ^
                        ER_OPEN_AS_READONLY 1036 HY000) c+ n; ]! e* C3 S, u" B
                        ER_OUTOFMEMORY 1037 HY001
                        & w0 `( j3 `/ S8 y SER_OUT_OF_SORTMEMORY 1038 HY001
                        - t4 t J* v. ]6 XER_UNEXPECTED_EOF 1039 HY000+ G: B& e6 I- _, d& I3 y* v
                        ER_CON_COUNT_ERROR 1040 08004
                        + V9 {* X& K: n# V5 r' U2 `ER_OUT_OF_RESOURCES 1041 08004/ u5 A7 Z0 V9 K1 ?: {
                                    ER_BAD_HOST_ERROR 1042 08S01
                              5 f% Q6 }( i e5 m% TER_HANDSHAKE_ERROR 1043 08S017 \+ C8 E+ K( n9 d) M
                              ER_DBACCESS_DENIED_ERROR 1044 42000% X, m$ ~1 |7 F+ X6 _4 o1 M( c
                              ER_ACCESS_DENIED_ERROR 1045 42000
                              ' ]; k5 B/ X) m/ EER_NO_DB_ERROR 1046 42000
                              & Q8 O/ [8 e O" [% ~/ z3 m, NER_UNKNOWN_COM_ERROR 1047 08S01
                              3 ]& l# F- t5 x! qER_BAD_NULL_ERROR 1048 23000$ S9 p6 _. J5 o0 L% A) X- M5 c
                              ER_BAD_DB_ERROR 1049 42000
                        ) a5 C* r* |, J4 w3 I& j2 rER_TABLE_EXISTS_ERROR 1050 42S015 _$ p; K+ }) X8 Q( S# \# f+ T
                        ER_BAD_TABLE_ERROR 1051 42S02( B- q, {9 F6 |% h0 J7 Y* P
                              ER_NON_UNIQ_ERROR 1052 23000; p5 m) h. V3 l6 S' `
                              ER_SERVER_SHUTDOWN 1053 08S01# T- Z1 z6 R5 r0 ^' Z' ~
                              ER_BAD_FIELD_ERROR 1054 42S228 p* _. v1 {( N$ q; ~; x! R' @
                                    ER_WRONG_FIELD_WITH_GROUP 1055 42000
                                    8 p/ i6 p+ S# {0 ]0 t) R Q8 X( @ER_WRONG_GROUP_FIELD 1056 42000
                                          , V, n1 @/ D* W! f9 ~/ [& `- SER_WRONG_SUM_SELECT 1057 42000) T2 ^; J ?* G2 a$ ]. ]7 m
                                          ER_WRONG_VALUE_COUNT 1058 21S017 e, F: l4 \& V4 @" W
                                          ER_TOO_LONG_IDENT 1059 420003 E/ f. {: v1 s
                                                ER_DUP_FIELDNAME 1060 42S21
                                                . B: V5 X* t/ s- [1 IER_DUP_KEYNAME 1061 42000! K3 D v+ W9 x/ G. ~- ]7 h
                                                ER_DUP_ENTRY 1062 23000: g, \% m+ Z6 P" _0 i1 Q z+ B
                                                ER_WRONG_FIELD_SPEC 1063 42000
                                                : `! T& i; W9 T, iER_PARSE_ERROR 1064 42000& U9 D& p+ g' r( f. N' X& C
                                                ER_EMPTY_QUERY 1065 420009 p8 A8 ~' F# d8 p7 a3 x
                                                ER_NONUNIQ_TABLE 1066 420005 P3 u8 J) _7 M) a" L4 a( C9 z
                                          ER_INVALID_DEFAULT 1067 42000( }$ m o% o9 b6 E/ p# W6 g
                                          ER_MULTIPLE_PRI_KEY 1068 420006 S3 W- l- h9 j- Y
                                          ER_TOO_MANY_KEYS 1069 42000
                                          5 y6 ]7 ~6 R8 M# i3 D9 qER_TOO_MANY_KEY_PARTS 1070 42000
                                    1 S! X: ~. K3 }' i0 u/ ]5 eER_TOO_LONG_KEY 1071 42000
                                    8 a: x3 U: b. b) u& a4 ~& D0 u, QER_KEY_COLUMN_DOES_NOT_EXITS 1072 42000
                                    / j5 Y' j) j) w6 N- k5 C! a) D! MER_BLOB_USED_AS_KEY 1073 42000
                              2 y5 E$ v! C$ V# F% e0 ^: UER_TOO_BIG_FIELDLENGTH 1074 42000, }" a) S2 N. X; f1 @
                        ER_WRONG_AUTO_KEY 1075 42000& P4 n2 ]: b0 }3 F8 s0 h# ~
                        ER_READY 1076 000005 b' F7 D0 A/ w) t) |
                        ER_NORMAL_SHUTDOWN 1077 00000
                        4 |9 c5 k: w2 l; OER_GOT_SIGNAL 1078 00000
                        4 M S8 O! C" TER_SHUTDOWN_COMPLETE 1079 00000
                        1 u1 _0 N0 k! N; l5 c' r) s3 @% cER_FORCING_CLOSE 1080 08S01
                        ; U$ J) ?9 i( yER_IPSOCK_ERROR 1081 08S01
                        : S0 `. O9 |% cER_NO_SUCH_INDEX 1082 42S125 f& ~2 I- g3 M& Z$ g$ L
                        ER_WRONG_FIELD_TERMINATORS 1083 420009 T; r% I4 |+ y4 t# k; X2 ?
                        ER_BLOBS_AND_NO_TERMINATED 1084 42000! G q: P& D z+ N: M
                        ER_TEXTFILE_NOT_READABLE 1085 HY000- q6 X* I1 O; b/ ^0 f
                        ER_FILE_EXISTS_ERROR 1086 HY000
                        0 B6 d8 o. ?! l. L1 x+ I: N* e$ NER_LOAD_INFO 1087 HY000
                        + L5 w H# m T8 Q( LER_ALTER_INFO 1088 HY000
                        / W! a# f* h! T4 e1 F, m% E) A' ZER_WRONG_SUB_KEY 1089 HY000
                        - H/ y( R& i/ T* B- i* RER_CANT_REMOVE_ALL_FIELDS 1090 42000" q8 ~; @ O4 E8 D% R6 J
                        ER_CANT_DROP_FIELD_OR_KEY 1091 42000& y$ z' { @4 i% I4 p+ z
                              ER_INSERT_INFO 1092 HY000
                              o0 V( T$ U3 j; ]. b; nER_UPDATE_TABLE_USED 1093 HY000* M! L6 q& |. U% P9 I3 G
                              ER_NO_SUCH_THREAD 1094 HY0009 U- Q8 z* w; ]; L
                              ER_KILL_DENIED_ERROR 1095 HY000
                              3 f( {2 w) o9 R% c' mER_NO_TABLES_USED 1096 HY000
                                    4 R' ?" {! b, G# f+ yER_TOO_BIG_SET 1097 HY000& p2 R( g" X/ C1 q% \! M
                                          ER_NO_UNIQUE_LOGFILE 1098 HY0005 G" j# ?" o2 N' I( ^$ m& L! ^
                                          ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 HY000
                                          0 M/ F+ e' V6 o/ j! O* O( zER_TABLE_NOT_LOCKED 1100 HY0003 v( G- x( X% N4 |% L# R
                                          ER_BLOB_CANT_HAVE_DEFAULT 1101 42000) f! X7 @6 s& b9 f/ i" A( Q0 Y
                                          ER_WRONG_DB_NAME 1102 42000, u# x; \7 d3 o8 h
                                          ER_WRONG_TABLE_NAME 1103 42000( j$ Y7 e! g7 I h R
                                          ER_TOO_BIG_SELECT 1104 42000/ K4 i3 u2 b( K- M9 I5 i E
                                          ER_UNKNOWN_ERROR 1105 HY0005 ?) Y* d7 N( O) S. O
                                          ER_UNKNOWN_PROCEDURE 1106 42000. L9 {) Q& m, [. F
                                                ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107 42000
                                                * x+ ~) G+ O) QER_WRONG_PARAMETERS_TO_PROCEDURE 1108 HY000
                                                * W% O' j! r% W0 e# {% DER_UNKNOWN_TABLE 1109 42S022 O% E+ m+ G# e+ n& U' |! n% G
                                                      ER_FIELD_SPECIFIED_TWICE 1110 420007 u$ W: b( |6 Z/ h
                                                      ER_INVALID_GROUP_FUNC_USE 1111 42000
                                                      ; C' f5 J/ O- aER_UNSUPPORTED_EXTENSION 1112 42000' |4 C( T! V$ c2 v8 x6 ^
                                                      ER_TABLE_MUST_HAVE_COLUMNS 1113 42000
                                                      ( o# q& P, \4 Q' @" \1 `! {ER_RECORD_FILE_FULL 1114 HY000
                                                            ) h1 X6 H3 E+ _6 Z! IER_UNKNOWN_CHARACTER_SET 1115 42000
                                                            . v, V5 j& d7 B! w. p6 r2 {! xER_TOO_MANY_TABLES 1116 HY000
                                                                  2 M* w/ s- J4 B' N3 V" k7 E' OER_TOO_MANY_FIELDS 1117 HY0000 J+ l: `. P/ | X; d+ a0 @
                                                                  ER_TOO_BIG_ROWSIZE 1118 42000, f, p/ O* i) J' [3 C8 ~8 r, t
                                                            ER_STACK_OVERRUN 1119 HY000* u& `: }6 t; B o% P" D
                                                      ER_WRONG_OUTER_JOIN 1120 420009 J+ E8 z1 }# S" \) \
                                                ER_NULL_COLUMN_IN_INDEX 1121 42000% z5 a6 }4 U! [, C& H( T
                                                ER_CANT_FIND_UDF 1122 HY000
                                          . t- d* U; H+ ~" W4 m# C& X# ZER_CANT_INITIALIZE_UDF 1123 HY000" }' b) V9 N2 [5 ^% o6 w
                                          ER_UDF_NO_PATHS 1124 HY000
                                          ! L& e2 N, E+ N) GER_UDF_EXISTS 1125 HY000; l3 l' o, `/ k6 w$ C3 R
                                          ER_CANT_OPEN_LIBRARY 1126 HY000
                                    }7 ~- u! n' z7 |ER_CANT_FIND_DL_ENTRY 1127 HY000$ X/ k7 r5 d& _6 O
                                    ER_FUNCTION_NOT_DEFINED 1128 HY000
                                    / M7 E( I) s1 q3 n. ^1 ZER_HOST_IS_BLOCKED 1129 HY000
                                    ; g. j( m/ M1 `: @' ?" gER_HOST_NOT_PRIVILEGED 1130 HY000; N! t" Y4 R- Y& J7 |6 @
                                    ER_PASSWORD_ANONYMOUS_USER 1131 42000
                                    % M: V& W. ~4 h: p$ G6 Y6 PER_PASSWORD_NOT_ALLOWED 1132 42000
                                    ! N. l7 B- l& m7 b2 `- zER_PASSWORD_NO_MATCH 1133 42000+ F/ ^) f/ G( _% l0 e
                                    ER_UPDATE_INFO 1134 HY000
                                    ; x |3 f9 R9 |& |* HER_CANT_CREATE_THREAD 1135 HY000
                                    8 Q- [, ^# X1 C2 {" PER_WRONG_VALUE_COUNT_ON_ROW 1136 21S01- J$ F0 c* ?) S! ^
                                          ER_CANT_REOPEN_TABLE 1137 HY000& t- j" v% I0 q! `; Y' @: h% x1 n$ w
                                          ER_INVALID_USE_OF_NULL 1138 42000
                                          + e6 V" p! f$ _6 l0 ]7 b8 P% y* XER_REGEXP_ERROR 1139 42000
                                          % s3 X& t' A2 V# Z! K" h b) B jER_MIX_OF_GROUP_FUNC_AND_FIELDS 1140 42000
                                          / n) L* L! |, h OER_NONEXISTING_GRANT 1141 42000
                                          9 K) `- E$ B! ^( u9 a. F/ cER_TABLEACCESS_DENIED_ERROR 1142 420009 X: F3 X* K* ]
                                          ER_COLUMNACCESS_DENIED_ERROR 1143 42000# X0 G/ K$ n/ J8 E& E! g' T/ J0 \! f
                                          ER_ILLEGAL_GRANT_FOR_TABLE 1144 42000
                                          ) N# L. @2 I1 gER_GRANT_WRONG_HOST_OR_USER 1145 42000
                                          * n3 D' l. s$ T1 Z" ?' rER_NO_SUCH_TABLE 1146 42S02
                                          6 \* u! ^% A3 t$ V. x/ b XER_NONEXISTING_TABLE_GRANT 1147 42000
                                          # j' B9 U b, G2 GER_NOT_ALLOWED_COMMAND 1148 42000
                                          ! b$ ~" r1 E# M6 B, q. u; ~# q5 oER_SYNTAX_ERROR 1149 42000
                                    ) A) }& C0 D t" C6 q( [ER_DELAYED_CANT_CHANGE_LOCK 1150 HY000
                                    w% Y1 T- o+ z' A! k9 c- i cER_TOO_MANY_DELAYED_THREADS 1151 HY000; l9 p& Y$ ^; o
                                    ER_ABORTING_CONNECTION 1152 08S01- i" c9 V1 Q( c3 g; E/ h
                                    ER_NET_PACKET_TOO_LARGE 1153 08S01
                                    , G/ W0 f" i9 A# qER_NET_READ_ERROR_FROM_PIPE 1154 08S01
                                    3 @* S2 _' m4 K# k, o$ qER_NET_FCNTL_ERROR 1155 08S01
                                    : N" U- D8 Q: dER_NET_PACKETS_OUT_OF_ORDER 1156 08S01
                                    3 B: e3 N- k3 k* n) lER_NET_UNCOMPRESS_ERROR 1157 08S01, D1 W; @5 B4 k3 n0 ~
                                    ER_NET_READ_ERROR 1158 08S01 p6 w( I# ~$ o% U+ ]
                                    ER_NET_READ_INTERRUPTED 1159 08S018 i# G9 v& U: E( `' j' ?
                                    ER_NET_ERROR_ON_WRITE 1160 08S01
                                    $ f% G3 S a* w5 bER_NET_WRITE_INTERRUPTED 1161 08S01
                                    4 E, |- Z, ^3 i6 T4 V4 YER_TOO_LONG_STRING 1162 42000- y" H6 ~4 g) j# O. @: F
                                    ER_TABLE_CANT_HANDLE_BLOB 1163 42000
                                    % c" v% a$ E1 j1 \$ \0 W2 _ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164 42000
                                    9 \, w. j% f) p: W$ t- j) OER_DELAYED_INSERT_TABLE_LOCKED 1165 HY0009 N* P" @6 J* R v8 Z" c0 v! t; L
                                    ER_WRONG_COLUMN_NAME 1166 42000
                                    ; `) S3 i, e2 n5 D0 ?ER_WRONG_KEY_COLUMN 1167 42000# _& z/ I3 y6 J0 x5 v' w" `
                                    ER_WRONG_MRG_TABLE 1168 HY000/ b* o" H$ R3 N" B
                                    ER_DUP_UNIQUE 1169 23000
                                    2 Z' J- T) O0 z% f# {ER_BLOB_KEY_WITHOUT_LENGTH 1170 42000% t* d& i: `0 B W, Z
                                          ER_PRIMARY_CANT_HAVE_NULL 1171 42000$ \2 u/ E v( D
                                          ER_TOO_MANY_ROWS 1172 42000 b, ?! {: @7 n f9 m/ s
                                                ER_REQUIRES_PRIMARY_KEY 1173 42000
                                                3 W6 x/ y4 W/ QER_NO_RAID_COMPILED 1174 HY000
                                          2 C2 j9 |/ b7 [3 } w/ \. C( cER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE 1175 HY0007 V$ y/ ?+ l) y, b5 p6 G
                                          ER_KEY_DOES_NOT_EXITS 1176 HY000! |! k- c( X4 m9 F+ n/ h- i2 p8 S a
                                          ER_CHECK_NO_SUCH_TABLE 1177 42000
                                    / o6 @) }2 J& U' g, @% BER_CHECK_NOT_IMPLEMENTED 1178 42000
                                    ) A/ d* w' I8 t, x/ O. h) bER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179 250005 K( D9 T" ]: T0 |
                                    ER_ERROR_DURING_COMMIT 1180 HY000
                                    ) T9 r5 b9 Y1 Q9 c7 o' L nER_ERROR_DURING_ROLLBACK 1181 HY000# ~0 M% w' j* D# V% S. y/ O
                                    ER_ERROR_DURING_FLUSH_LOGS 1182 HY0006 _; r7 q0 x# ~( T3 x
                                    ER_ERROR_DURING_CHECKPOINT 1183 HY0001 G5 t$ c' z' x' r) N
                                    ER_NEW_ABORTING_CONNECTION 1184 08S01
                                    7 G: q: D& F( l9 a, r5 j0 lER_DUMP_NOT_IMPLEMENTED 1185 HY000$ ?# o. w6 x2 L2 t5 U' u: _
                                    ER_FLUSH_MASTER_BINLOG_CLOSED 1186 HY000
                                    + ^" t1 ?8 x: a/ i; M8 p+ FER_INDEX_REBUILD 1187 HY0001 h8 r9 m, E0 y; O0 w$ q6 A6 L
                                    ER_MASTER 1188 HY000
                                    # x# h- r, [! M z" D- xER_MASTER_NET_READ 1189 08S019 s: T3 C; Q! j* w4 M
                                    ER_MASTER_NET_WRITE 1190 08S01$ Y9 n$ G2 c; X; s' ^2 m$ h9 g
                                    ER_FT_MATCHING_KEY_NOT_FOUND 1191 HY000
                                    2 \: X1 d A$ V* a+ p A: U0 DER_LOCK_OR_ACTIVE_TRANSACTION 1192 HY0007 m @# q3 z, p* U& N
                                    ER_UNKNOWN_SYSTEM_VARIABLE 1193 HY000
                              * {+ ~& j: k, N; ]6 `2 I8 BER_CRASHED_ON_USAGE 1194 HY0001 K9 [9 w, H0 }
                                    ER_CRASHED_ON_REPAIR 1195 HY0009 W( t7 K- X- @ S# x% ^: i R; S. i
                                    ER_WARNING_NOT_COMPLETE_ROLLBACK 1196 HY000( |! _6 ], D4 d' ]% J1 t0 d* j
                                    ER_TRANS_CACHE_FULL 1197 HY0004 K( x" \! y e! n: @4 Q% \7 w) g
                                    ER_SLAVE_MUST_STOP 1198 HY000! a/ W6 o1 x0 P) m+ ?8 M/ M
                              ER_SLAVE_NOT_RUNNING 1199 HY000! f. ]& a1 x4 |7 }
                              ER_BAD_SLAVE 1200 HY0009 W$ T& D2 T3 t" A& ]1 A( i$ ?3 N$ n
                              ER_MASTER_INFO 1201 HY000+ V3 U3 `) R) d! e
                              ER_SLAVE_THREAD 1202 HY000# W" `0 C( u; Z) Z7 a
                              ER_TOO_MANY_USER_CONNECTIONS 1203 42000: T* E6 v1 V. b! Q# \
                              ER_SET_CONSTANTS_ONLY 1204 HY0002 p X0 H [; i# w. R7 [
                              ER_LOCK_WAIT_TIMEOUT 1205 HY000, s! l5 n5 d5 B! \- S
                              ER_LOCK_TABLE_FULL 1206 HY000
                              + ~4 E5 _! X( c) e/ rER_READ_ONLY_TRANSACTION 1207 25000
                              & P, s: t/ c3 H% n D; p. QER_DROP_DB_WITH_READ_LOCK 1208 HY000* I Q" ^; c; ~4 f( ^1 e
                        ER_CREATE_DB_WITH_READ_LOCK 1209 HY000- o! M2 @: ]5 D4 `; }- V, V
                        ER_WRONG_ARGUMENTS 1210 HY000
                        * Y+ ^0 g, \/ n5 N) f% CER_NO_PERMISSION_TO_CREATE_USER 1211 42000) F* O! d( b9 | ?( G& G# W: n' m3 x
                        ER_UNION_TABLES_IN_DIFFERENT_DIR 1212 HY000
                        , T7 s: P, `& l$ {ER_LOCK_DEADLOCK 1213 400019 u" k7 J8 [+ `' T( H( t
                              ER_TABLE_CANT_HANDLE_FULLTEXT 1214 HY000
                              % r* y; _: E4 J+ s+ r3 d" FER_CANNOT_ADD_FOREIGN 1215 HY000# R- [' p# ?# \! \) b9 {3 a3 K
                                    ER_NO_REFERENCED_ROW 1216 23000
                                    $ b0 p d4 c1 c( jER_ROW_IS_REFERENCED 1217 23000" u2 Z( B6 ]8 z, y
                                    ER_CONNECT_TO_MASTER 1218 08S01+ U- G. h& U: c, S/ |1 c: `! K& G
                                    ER_QUERY_ON_MASTER 1219 HY000
                              7 G! K( O. m1 A3 n6 j. i# p; }ER_ERROR_WHEN_EXECUTING_COMMAND 1220 HY000
                              3 r( O9 F P) r1 L" XER_WRONG_USAGE 1221 HY000
                              6 W( i3 d1 ^! h1 Q. g/ s6 ^( TER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT 1222 210002 U K/ e) b& s3 i
                              ER_CANT_UPDATE_WITH_READLOCK 1223 HY000* C+ C- ^6 i2 h- m7 L: K
                              ER_MIXING_NOT_ALLOWED 1224 HY000! {: ^5 _; Z- [# @" E2 M
                                    ER_DUP_ARGUMENT 1225 HY0005 J! @# z& \) k
                                    ER_USER_LIMIT_REACHED 1226 42000
                                    2 u' f2 Y) B# F' ], E8 N1 A7 \, n# Y! iER_SPECIFIC_ACCESS_DENIED_ERROR 1227 HY000
                                    * `2 B; P8 W# I6 RER_LOCAL_VARIABLE 1228 HY000
                              8 m% `4 x' o, } r3 ]% p& Z: S& k; aER_GLOBAL_VARIABLE 1229 HY000' ~- V/ \9 t3 {0 z% {
                                          ER_NO_DEFAULT 1230 42000: G3 p/ u( I7 [" T/ d5 |9 s+ @
                                          ER_WRONG_VALUE_FOR_VAR 1231 42000
                                          9 r! c" v2 T+ J7 wER_WRONG_TYPE_FOR_VAR 1232 420003 L. ?, l9 R3 E! A
                                          ER_VAR_CANT_BE_READ 1233 HY000: k7 q' k* K0 Q( ]
                                          ER_CANT_USE_OPTION_HERE 1234 42000
                                          ! t9 Z/ d5 _2 \1 ]2 KER_NOT_SUPPORTED_YET 1235 42000; P4 q7 R2 b1 @3 u
                                    ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 HY0003 c: t! j2 Y' W. N- T% }0 O8 g
                                    ER_WRONG_FK_DEF 1237 420006 s( Y# W- w( b+ |
                                    ER_KEY_REF_DO_NOT_MATCH_TABLE_REF 1238 HY0005 q+ r7 | C5 G. {7 Q. K, L
                                          ER_CARDINALITY_COL 1239 21000 c1 M2 ^7 Q1 ^" R' E* w
                                          ER_SUBSELECT_NO_1_ROW 1240 21000; _. X9 o% U+ i0 d) l8 x6 Y' W, E
                                          ER_UNKNOWN_STMT_HANDLER 1241 HY000* M' h# q; L2 |/ l/ H! x+ @
                                    ER_CORRUPT_HELP_DB 1242 HY0005 Z( |6 }" X% ~4 i
                                    ER_CYCLIC_REFERENCE 1243 HY000 s! E2 x% P9 p8 s, B5 ]
                                    ER_AUTO_CONVERT 1244 HY000
                                    2 I/ K" a7 ^3 z4 Z M1 r, CER_ILLEGAL_REFERENCE 1245 42S22) ]0 c: S) E5 ~
                                    ER_DERIVED_MUST_HAVE_ALIAS 1246 42000
                                    & |" N1 c" T' T& f, E/ V/ QER_SELECT_REDUCED 1247 01000
                                    0 r5 L- y. C( U( Z7 zER_TABLENAME_NOT_ALLOWED_HERE 1248 42000% J7 c# j& V1 W6 n4 D! V
                                    ER_NOT_SUPPORTED_AUTH_MODE 1249 08004
                                    $ Q9 K) \2 u! k ~$ i1 b4 Z1 \ER_SPATIAL_CANT_HAVE_NULL 1250 42000
                                    / Y1 i7 y9 ?( z; f, @. k$ wER_COLLATION_CHARSET_MISMATCH 1251 42000
                                    % Y; T, |/ j6 A0 wER_SLAVE_WAS_RUNNING 1252 HY000
                                    ' T3 V5 q& |- ^) p0 v) HER_SLAVE_WAS_NOT_RUNNING 1253 HY000
                              " k$ H' P# M+ ^! R( `7 q, hER_TOO_BIG_FOR_UNCOMPRESS 1254 HY000- X- C: }: d1 x+ ]$ |" g+ w
                              ER_ZLIB_Z_MEM_ERROR 1255 HY000
                              2 @5 e2 I$ ?. G3 B. _% N" e9 H JER_ZLIB_Z_BUF_ERROR 1256 HY000
                              ) d& k1 e' f* h- MER_ZLIB_Z_DATA_ERROR 1257 HY000
                        2 l% b1 ?$ {/ i6 e WER_CUT_VALUE_GROUP_CONCAT 1258 HY000' }9 B1 S9 Q' l7 b" \
                              ER_WARN_TOO_FEW_RECORDS 1259 01000
                              & w1 r* _8 k: m5 s, V3 ]ER_WARN_TOO_MANY_RECORDS 1260 01000
                        2 u/ ?& D% S- m+ {1 O& k( ]ER_WARN_NULL_TO_NOTNULL 1261 010007 \% Y" [" R- x# }. `
                              ER_WARN_DATA_OUT_OF_RANGE 1262 01000
                              7 ]0 V+ S0 M0 O SER_WARN_DATA_TRUNCATED 1263 01000 r5 o0 `- P* h# s! C$ i! M0 D
                              ER_WARN_USING_OTHER_HANDLER 1264 01000
                        * v- Q+ f0 d4 M6 ]! ?2 q8 }ER_CANT_AGGREGATE_COLLATIONS 1265 42000* m# q* ~9 g) E' Q2 @
                        ER_DROP_USER 1266 42000
                        2 d8 e) \: p& P/ uER_REVOKE_GRANTS 1267 42000


--转自 北京联动北方科技有限公司




赞(0)    操作        顶端 
总帖数
1
每页帖数
101/1页1
返回列表
发新帖子
请输入验证码: 点击刷新验证码
您需要登录后才可以回帖 登录 | 注册
技术讨论