该用户从未签到
|
21#
发表于 2015-12-15 22:14:30
|只看该作者
你好,我导入数据库出现如下错误,如何解决
. k! E! q1 _( `$ F, |9 i B5 x[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),
" B" s& U- N6 \( c" p STNAME VARCHAR2(10),; l+ R$ |& C' E' w: D) @6 S; X9 f
STSEX VARCHAR2(10),2 H$ I$ S, h+ N4 E/ `
STAGE ' at line 32 H& A& J5 J# z4 D2 N
[Err] create table STUDENT29 l, ~+ G _3 G3 M
(
2 ~5 l" Z6 C6 H. ?( X5 H5 G STID VARCHAR2(25),
, I' r' {* F# N8 D: C; z STNAME VARCHAR2(10),
5 K# d. S0 _: [7 ~ STSEX VARCHAR2(10),
9 j4 N. y2 ~0 Z% n! b* A STAGE VARCHAR2(10),4 t0 V& I# V& e p8 d) @3 @
STTEL VARCHAR2(20),6 Q O6 A/ m6 H3 V5 E7 `
STDEPT VARCHAR2(20),
1 C2 p, ] p3 n STADDRESS VARCHAR2(50)+ l4 q) }* a. V
)
. T) r# i% s9 r& Ztablespace USERS
; h/ M% l6 Z. Q# x. [; G* P6 R pctfree 10. m$ k" \9 J4 F1 G! m1 I6 o* u. q
initrans 1
9 v& Q) X5 g' F* y9 g% }5 O maxtrans 255- W5 ~% e; n* F9 v/ l
storage5 q0 [* z# ?; w. f) X" r4 r0 J% H
(
( ?$ a) E$ K& O3 T initial 64K
; [/ I4 Z# l, v' N6 t# ] minextents 1' s T' g7 |5 Z' m5 I
maxextents unlimited& V% i0 x/ t5 i0 U" q. l" p
);
/ F# ~' o" `' c0 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
( s- E0 [2 i; f: c' I+ V" kminvalue 1
! U7 E1 G. |1 j; b$ e9 m& X- Amaxvalue 999999999999999999999999999' y/ j7 ^6 `- o+ r
start with ' at line 23 a5 z! d( r! T( Y
[Err] -- Create sequence
: i* C% G% W5 A% \create sequence STU2_SEQ
; U) }+ X P2 z( ]minvalue 1
- y" x2 S# w* m# c! ?maxvalue 999999999999999999999999999
: l9 M6 N! E+ G$ c# Sstart with 25
/ ~% x' X1 M, s T# v( d5 Q5 O# Bincrement by 1
2 O2 ^) |1 e: X, ?2 ?7 knocache;$ b& N; `* T* P
[Err] 1146 - Table 'student.student2' doesn't exist
. H6 h7 D+ ]; ^( r* s% d2 o[Err]
6 ? O" F; ]$ Y( G8 c# X[Msg] Finished - Unsuccessfully" H3 K6 X( w4 E, M4 u5 a' d: c
--------------------------------------------------, ~; M. G9 \/ b+ T
|
|