|
该用户从未签到
|
20#
发表于 2015-12-15 22:14:30
|只看该作者
你好，我导入数据库出现如下错误，如何解决
5 ?; r4 b7 C$ E* P$ q9 [) v[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),
9 ^, [3 Y. @# g8 E2 t3 r STNAME VARCHAR2(10),8 v7 @& o' v4 d0 q- s' S) V7 q: t
STSEX VARCHAR2(10),! |9 ~+ X6 M$ H/ M$ `* m
STAGE ' at line 31 O$ D/ N+ D& \( q+ E
[Err] create table STUDENT2
9 N/ x$ `) ~( K; t) `* w" P(& _% Q+ o1 `' u1 h! s% `3 W9 o
STID VARCHAR2(25),# J5 x8 N# ] h. H& N) S( ]
STNAME VARCHAR2(10),
+ R+ v( s- I2 f: V- S/ V: w; i STSEX VARCHAR2(10),$ d8 j0 \6 b- g, k [
STAGE VARCHAR2(10),( h5 d8 M( ~0 ]. h: v+ P
STTEL VARCHAR2(20),, @ q- l9 p" q
STDEPT VARCHAR2(20),
' S* L4 x7 z) ~- z+ x; ]( B STADDRESS VARCHAR2(50); V1 R! m2 n5 M3 i |, n" k: ~: P
)
: _3 |7 @: M/ y! z) V: jtablespace USERS
# X3 B5 ?. ]) V3 l pctfree 10
: q4 |2 l& q" d1 T& Q" f& Q2 @ initrans 1
6 C: p* @, n/ |# u+ F/ Y% e maxtrans 255% I) [; q6 I4 p' R! q( \
storage: X4 z# z; c. _0 k! c% m
(
0 h1 \) h( Y% E2 p4 r2 {" L. G initial 64K, I/ B# k2 `! _
minextents 1
5 l( I( r" a1 u maxextents unlimited* m) v2 J* i( \- W# g
);+ E) u7 J; s7 Y
[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
P' f$ E+ t5 X9 ~( ]minvalue 1( {2 [- a" e/ M4 O
maxvalue 999999999999999999999999999
) G4 f+ h9 E5 ~: t( Kstart with ' at line 2& z! W/ i' Y* d) {
[Err] -- Create sequence 2 e1 i* J! r7 k( }7 ?
create sequence STU2_SEQ2 f- d- r, t- d# C! z. b
minvalue 1
. ~2 V0 D {6 P$ F4 v* B' omaxvalue 999999999999999999999999999$ I2 n" u1 _3 c! k
start with 25
: l2 K1 j1 t* b; U% H' c; V7 Tincrement by 1$ s e8 h0 v4 G
nocache;0 ^7 q- h8 {' M8 ~7 y' I! p
[Err] 1146 - Table 'student.student2' doesn't exist
$ V/ _/ u* k7 D+ ]$ E( t[Err] ' {( S* s, h. d
[Msg] Finished - Unsuccessfully
3 Y" `% _ i; t) `--------------------------------------------------
% A" _' q1 o* ?9 b- `: ^ |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡