该用户从未签到
|
20#
发表于 2015-12-15 22:14:30
|只看该作者
你好,我导入数据库出现如下错误,如何解决* [- j% n5 `/ @" [: N5 g
[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),2 S- R+ d9 Q' F/ A9 P" Y
STNAME VARCHAR2(10),
+ @$ ^ `( g6 [/ | STSEX VARCHAR2(10),
1 c) U' B- g. h; n# g f STAGE ' at line 3! Y, I! ?6 U S7 S p
[Err] create table STUDENT2# f0 p% j" M4 t4 n" d5 F
(
0 C) Y/ r2 o. w" b( l STID VARCHAR2(25),
0 P, a( }$ o/ L+ e9 t3 u STNAME VARCHAR2(10),; z& L; Z4 T( w) {* H1 q. t
STSEX VARCHAR2(10),: W: I6 b5 U; m" A9 H) a" \6 y' f: I
STAGE VARCHAR2(10),5 j2 z' [$ g3 R4 q, y: F/ r# ^ x- p
STTEL VARCHAR2(20),
& k! }3 B/ D9 h: s+ K& T2 Y) y# S STDEPT VARCHAR2(20)," f9 a! W+ ]. l) z. W" C2 @
STADDRESS VARCHAR2(50)* e, {4 j1 e% {% t! A
)
% P: f* h/ b9 Y* k, X( a: ytablespace USERS3 ]% \( T i% T3 ~2 I9 U7 P g6 F
pctfree 10
: c* @: N# b4 W$ i C' J6 O' U initrans 1! X* c p5 u1 r% o/ U; F
maxtrans 255/ ^4 u, v1 l7 @8 P
storage
4 @" i( s1 |/ s2 Q: P% [3 d (4 T6 r2 J# r$ Z+ {
initial 64K
/ r' Q% ^3 K+ r3 z& D+ _' F! J minextents 1
0 J5 A3 z. s0 k7 J* s maxextents unlimited
. u# D! ^; i. ?: F9 C; q) R- U );
' i1 n' R* I: g% d& N Y; H- a/ o[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/ |2 Y) ^+ a* i j2 n" o) g5 X
minvalue 1! L* U) s8 M6 V9 n
maxvalue 999999999999999999999999999. @ Q. p9 Y6 ]. b
start with ' at line 2
N" R# ?+ t2 V' V[Err] -- Create sequence ! B( {1 ]& x/ T/ Z/ z9 z+ u) E9 w' G
create sequence STU2_SEQ& g, c% g; b9 [
minvalue 1' Q5 G: j: I: B, s9 x5 S
maxvalue 999999999999999999999999999
) m+ @! `$ k- R% Gstart with 25
3 W+ [ L/ b G6 I% y* F- Rincrement by 1
- M5 q! G) o- f8 ^+ _7 X' Anocache;( u* x+ R( @! }4 A4 s8 ?3 ]8 |
[Err] 1146 - Table 'student.student2' doesn't exist3 h$ W4 z* I' }4 ]6 q
[Err]
9 @" R; d5 s j1 T; |[Msg] Finished - Unsuccessfully" f8 J M6 I5 `
--------------------------------------------------& Z% Z% i* m# `+ w' r, Y3 z1 Z
|
|