|
该用户从未签到
|
21#
发表于 2015-12-15 22:14:30
|只看该作者
你好，我导入数据库出现如下错误，如何解决5 {0 J O: M" q: `( `) B [8 f
[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),0 B& M5 a0 [1 A( j7 l0 z7 p2 ?
STNAME VARCHAR2(10),4 |$ |+ ]$ D* z
STSEX VARCHAR2(10),
* o1 C% ^' L4 T6 Q7 f' ^1 w8 F7 j STAGE ' at line 30 p4 k9 L& G8 ~. |5 d
[Err] create table STUDENT29 @! h! c" h5 l& i+ C( k
(
; B/ P( V6 l& y5 B- X STID VARCHAR2(25),
4 k, k$ {3 S" w9 a# f STNAME VARCHAR2(10),
6 X% [5 _( j# S8 g STSEX VARCHAR2(10),+ ~. P. y, e6 A3 [- e W
STAGE VARCHAR2(10),/ R* L0 \ |3 c8 ~
STTEL VARCHAR2(20),
0 |6 g, y. d: R2 g5 a+ s- s STDEPT VARCHAR2(20),7 D6 ?; x% X4 ~$ ]% P+ a% `
STADDRESS VARCHAR2(50)
$ p8 b( b' P6 h r+ J)
) d5 o/ `& u7 D& etablespace USERS
5 D* C1 T( z4 _, k. d* p3 S pctfree 102 P% c. F3 z$ C
initrans 1
: x+ F1 `! L" C& e, U: D$ N maxtrans 255- g" @( ~ w% ?# b2 @( l7 g) f
storage+ w3 U. |! r/ Y! w8 E0 L
(
/ y- k4 ]6 I! W8 T initial 64K
3 M2 ?; E: i7 Q, Z- s. A b minextents 1! J+ j: ~, T( F" V9 ^/ _6 r
maxextents unlimited) v. f; G* v* a# u- o- G4 N, I
);
- w" E" m. k. R0 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 'sequence STU2_SEQ/ u- ?" h' ^! s, M& _# [, d
minvalue 17 B2 t# i! L( v. ]
maxvalue 999999999999999999999999999
, a# ?$ }* X$ K E* {+ b2 Zstart with ' at line 27 d* j& I, p% t7 j" [0 `& J
[Err] -- Create sequence
1 f( N' A8 I/ W& Z' jcreate sequence STU2_SEQ
* s( u# I) g' @2 L0 x4 `minvalue 1/ s# H. d! _/ }/ Q
maxvalue 999999999999999999999999999& ]7 L' Q" ?* M+ ~# s- ~+ c
start with 25
\+ E8 ~. Y5 P6 k$ I; iincrement by 1
+ V7 s3 Q* ^1 H* t7 U/ L hnocache;4 u2 W& s& y) i0 l% ^, R
[Err] 1146 - Table 'student.student2' doesn't exist" m% n* W! a$ M% O$ s$ q% }: U
[Err] + \' O2 f3 W9 h/ z3 a7 P2 a
[Msg] Finished - Unsuccessfully
6 q2 y3 J4 s$ y" @4 D% J. X, N--------------------------------------------------! O# Y( v# l6 p2 V
|
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡
