|
该用户从未签到
|
20#
发表于 2015-12-15 22:14:30
|只看该作者
你好，我导入数据库出现如下错误，如何解决
2 f# m0 `3 |" G3 f* r[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),
4 c9 w U- c0 P, k+ z+ Z STNAME VARCHAR2(10),1 @! Q1 n+ x6 p" [* F
STSEX VARCHAR2(10)," p# |- f% ~7 A0 n5 X* i7 t5 s
STAGE ' at line 3
* Q% V7 C) P+ h8 O; u" [- r[Err] create table STUDENT2; V0 J% p2 I* t, S4 R$ `! W+ I, O
(
+ b. @2 K" J, q4 [, e STID VARCHAR2(25),( k, {% c; \6 b* r- W1 e& g
STNAME VARCHAR2(10),
9 ~5 E3 V+ M1 R8 K5 l7 l- t0 T( ? STSEX VARCHAR2(10),0 w- a* j8 Q1 {+ Q* l
STAGE VARCHAR2(10),: c X0 r3 E5 Z
STTEL VARCHAR2(20),
. K) H' o2 E- n( ]5 ^3 m$ g STDEPT VARCHAR2(20),! A* {6 ?3 i5 N7 ]3 W
STADDRESS VARCHAR2(50)% s: m) H2 b4 Z0 T
)
& }& Q* v+ w4 i* t9 Y2 w1 qtablespace USERS6 B' n: z2 p+ {3 n7 A
pctfree 107 h$ f4 W5 P7 e' x# W
initrans 1
. u3 H( Z4 l4 W: l7 d) Y. r maxtrans 255
: v' V! H. _2 p storage' n1 `* I* H/ L+ P& K' O
( r- D/ @8 M; E8 i
initial 64K
4 Y+ v* @" e) t6 \ minextents 1
5 \ g8 f$ H2 Y% r1 A! l maxextents unlimited1 N4 r& y- b% P2 r' }
);% S) L2 j7 N) \3 a$ R8 N
[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
, C( K( Z, i0 B) \) o: `6 L# [5 w$ dminvalue 1
, V( h& n( y; C: P9 [" ?maxvalue 999999999999999999999999999
% s7 l& a! ]$ \- J- {start with ' at line 2
; B0 n' R5 F/ Z' i[Err] -- Create sequence [( i' @8 l) O& o
create sequence STU2_SEQ, B( A/ O9 X3 T5 L" z( d1 H
minvalue 1" h2 P* v8 @! R; l8 A6 C1 s0 j
maxvalue 999999999999999999999999999- M" g6 c" E8 ?7 c7 }
start with 25
$ F0 m4 i# \& }; _' d! Qincrement by 1/ b8 R# @7 v/ P7 }" u
nocache;0 K; e; k5 D* ~/ i* z
[Err] 1146 - Table 'student.student2' doesn't exist& s- z7 T5 i; c9 }& s8 l: k! X
[Err]
7 y/ e! l$ H7 i9 W& ]% n' n* j: {2 w1 j[Msg] Finished - Unsuccessfully) b5 T- r$ q: `
--------------------------------------------------* j. b9 O; n. e; W' R6 I X/ s
|
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡