该用户从未签到
|
21#
发表于 2015-12-15 22:14:30
|只看该作者
你好,我导入数据库出现如下错误,如何解决
% m+ {& ]9 j' I% Z3 h[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),$ T% F& y1 G5 I1 {$ N9 f
STNAME VARCHAR2(10),
2 ^& V {8 r* L2 p' M( F+ } STSEX VARCHAR2(10),
' O2 f9 Q- e6 V+ ?% ]% a) y STAGE ' at line 3$ J/ A- L% \4 \& g
[Err] create table STUDENT2* z. F9 I# J, x+ r
(
: J+ V; V0 o; U( D# b3 @/ d& t STID VARCHAR2(25),
$ k8 j6 R) C5 y! p2 t STNAME VARCHAR2(10),, Z1 r6 O2 X: Y9 L$ d. z+ h; P
STSEX VARCHAR2(10)," e2 J( H% x4 ?
STAGE VARCHAR2(10),
9 p6 E, ?6 [1 y STTEL VARCHAR2(20),
% F7 ?' d$ r5 F9 Q4 r3 Z4 N STDEPT VARCHAR2(20),
0 V; X. L* }; e" |& a" H STADDRESS VARCHAR2(50)
' o7 d* s4 ?; g)
# Q/ U# R+ f/ Y- Ltablespace USERS# @% J, n/ B- E# V0 s. [$ F
pctfree 10
+ c/ r4 V5 Y0 U& k6 ` initrans 18 e8 ^& H3 o( k/ Q
maxtrans 255
0 |) W- H7 k: Y3 I( I storage' L7 L T" v2 g- {7 y
(
! t! ^3 h5 Z" t3 H/ R9 n initial 64K5 e/ |, T$ q# F, L! D/ ~4 e) G; ~
minextents 1
+ p2 R) L5 |$ K- f6 g8 n maxextents unlimited
* I2 W8 r% N& ?; ~, Z );
7 H+ n$ d" \* K, H& k& D: 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 'sequence STU2_SEQ# F6 ^& L# u( a3 y! d& e7 B
minvalue 1
/ d$ B# d8 }$ L2 jmaxvalue 999999999999999999999999999
9 W) ? s- M5 ostart with ' at line 2
2 B7 h9 }- Z ^$ u" k. S8 s[Err] -- Create sequence
2 U) t1 S1 w5 {* I+ h% f8 N& wcreate sequence STU2_SEQ7 j8 p; K6 j6 [* O2 _ @
minvalue 1
- C" a0 ]$ P. Z: S. p9 t0 V% ]maxvalue 9999999999999999999999999990 Q6 a/ i! Q# z
start with 25
- K# k. U3 z" c0 F. N" t: Kincrement by 1
, ?. z# N1 G+ a; L7 Enocache;
8 o) }% R' }- u% u. Y[Err] 1146 - Table 'student.student2' doesn't exist
. M- W: U" W& j3 d! x9 ?3 |2 V[Err] : q2 {6 N% v7 X |( D
[Msg] Finished - Unsuccessfully6 x I2 a+ i1 ~ W, Q
--------------------------------------------------
- Z( U3 l4 ]+ H, t |
|