|
该用户从未签到
|
20#
发表于 2015-12-15 22:14:30
|只看该作者
你好，我导入数据库出现如下错误，如何解决6 h: c N7 L# X: c
[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),. Y* }1 A2 o% l; ]4 t# B0 X
STNAME VARCHAR2(10),; Y7 r5 l3 a( ^3 V+ K
STSEX VARCHAR2(10),
* T# ~' _- a, K7 R: N4 C STAGE ' at line 3
7 k: u3 l% w, l7 P/ B# G[Err] create table STUDENT2& G8 [* |: C+ I2 s; l! m
() L1 S% B- R& x6 M! ]! ~
STID VARCHAR2(25),! |2 _' M- U3 a4 {; {
STNAME VARCHAR2(10),$ A( J4 o6 l+ U# ]
STSEX VARCHAR2(10),# @" l0 l1 @& ?
STAGE VARCHAR2(10),
' ~: Z( `% g) O) D- B M; ~ STTEL VARCHAR2(20),
6 U" j5 P" @' ~$ s: h STDEPT VARCHAR2(20),
: t# {: b* e" E- R# g STADDRESS VARCHAR2(50)
3 i$ N' T( x$ S1 U* s" R)) Y0 {/ X4 I, z. V0 ?* }+ D
tablespace USERS# h$ F8 J2 l; b% h; x3 W* T' I
pctfree 10
U$ M0 b: o% H( A' k* [& D- _ initrans 1; E- a4 e$ A' K
maxtrans 255
8 G; v7 R h- \! Y5 u6 d8 e+ P storage
- P6 a* q, X/ n8 l5 M. I6 q (
2 k1 Y& C5 K& \& a6 R$ ^* K) x! { initial 64K
# r d2 l: ^5 |# s minextents 1
2 V& P9 k! C0 d9 b: j6 a maxextents unlimited
! Y7 l5 P+ w$ P2 A/ x );) E6 X9 s8 u' S/ K5 K
[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
3 \: m! F( t" I) u$ L" `: ` v. jminvalue 1
4 h7 T- e- M% M& Rmaxvalue 999999999999999999999999999
' G4 r$ _% {6 Qstart with ' at line 29 P; z- B7 c6 x9 F9 W
[Err] -- Create sequence & i9 E3 }7 L& a7 R9 ]1 ?0 G
create sequence STU2_SEQ+ o2 j+ ?% I* u5 ~) n# D/ |5 F0 x
minvalue 1
; f0 d4 W( h6 M* _" qmaxvalue 9999999999999999999999999999 Q- C" p3 j- i8 o( q1 |! Q" N
start with 25 L. I/ v0 [. J- ?# Z; X. }$ D; t3 c: h
increment by 1 A5 W$ e U2 x, j6 N# y
nocache;( X0 h6 G* H: Z9 g3 a1 M; J
[Err] 1146 - Table 'student.student2' doesn't exist8 ]2 T% X- o, S- p* G
[Err]
0 P& m/ [/ B1 F- [& M[Msg] Finished - Unsuccessfully
$ `$ M" ~% f8 Q/ D4 l+ a5 i) @: d--------------------------------------------------% h; P: [) E7 Z, `! j: D- P
|
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡