|
该用户从未签到
|
20#
发表于 2015-12-15 22:14:30
|只看该作者
你好，我导入数据库出现如下错误，如何解决
" {6 M/ T& e! K5 O! w[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR2(25),
' i* y9 P3 d \& J STNAME VARCHAR2(10),, I) Z. x0 u6 R( ?' {
STSEX VARCHAR2(10),
) a& `% u; H% z1 H$ r, I9 J STAGE ' at line 3
' x( [% ` m4 N3 v: l4 `- V( q, f[Err] create table STUDENT2
0 N1 r1 y6 R' r(
: m) W# J, R9 Q8 }" l2 |% h STID VARCHAR2(25),
2 d/ B8 B% z i5 `# e$ N8 k STNAME VARCHAR2(10),
" _) I% X" G8 z8 d9 T, j2 c STSEX VARCHAR2(10),
9 ? ]! {0 O4 `4 R; C STAGE VARCHAR2(10),( ^- a' t" y9 n- I9 i( h7 X: `
STTEL VARCHAR2(20), Q) u$ {9 {( q% b
STDEPT VARCHAR2(20),
0 t" z0 V+ p" I' p STADDRESS VARCHAR2(50); b) V* h$ c L s2 o! S
)
' Y8 w: H5 ~' D9 B, o( ]tablespace USERS
$ O. w/ f/ {2 _ n& c pctfree 107 d: x$ e( i3 H) `9 O9 Z, k1 y
initrans 1
" C) |, ?' V, n( ` maxtrans 2554 |6 {& V- W( l1 Y* O: Y
storage
4 H+ b H+ u( d+ @ (: Z% h% S3 |6 j5 t3 l% D
initial 64K
_ `7 J& j- V; [( p minextents 1
& {; |# ?! R; A# q7 L+ q( ? maxextents unlimited8 o# N9 n3 _0 t/ X- U! H( t3 C
);% [. I0 h0 V9 J: d- m6 S( v3 s
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sequence STU2_SEQ+ a8 ^# x1 r+ F4 G8 X. a
minvalue 1" y% O) o3 M& v
maxvalue 999999999999999999999999999
4 A, B. N0 q4 E% Fstart with ' at line 2: _: h( o" B& S( ^4 V9 E$ l
[Err] -- Create sequence
7 T( K5 X% E% g: r: fcreate sequence STU2_SEQ1 p# v0 W! e1 g9 a3 y5 M
minvalue 1
) `. w1 H K1 dmaxvalue 999999999999999999999999999
& s; g0 }. O* _: ^7 zstart with 25+ |' E8 N, W" J5 }) l( u! Y
increment by 1
! e# a4 |* N+ a" ]/ ^) @1 ^nocache;- M5 h/ N: e; o
[Err] 1146 - Table 'student.student2' doesn't exist* v3 q$ ]# z* ~- c" E4 o: s
[Err] , i0 w2 \6 N, ?! A& m1 P
[Msg] Finished - Unsuccessfully
* G$ } E* t/ s6 \" F--------------------------------------------------
8 n) [0 u; g9 n# Y, W# l& S |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡