|
该用户从未签到
|
21#
发表于 2015-12-15 22:14:30
|只看该作者
你好，我导入数据库出现如下错误，如何解决
m6 V3 }! j9 ~$ `$ y$ U, `* W7 v2 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),4 w: p y- P5 \9 ~, h9 C1 i
STNAME VARCHAR2(10),
3 I6 G7 s! S+ }8 V STSEX VARCHAR2(10),8 S. g3 U$ L- c0 Z$ M' E/ H
STAGE ' at line 3' c! h3 I+ w9 O) Y& W' e
[Err] create table STUDENT2) |* M- B! J/ C9 W% }5 z% e* j/ U, x
(* H) P- n6 t, x4 c/ g
STID VARCHAR2(25)," ~+ A" V# P0 r& A. |% [8 C
STNAME VARCHAR2(10),6 D& U# T6 `' A5 ?" Z2 m+ p
STSEX VARCHAR2(10),: U6 P9 D2 J% o+ e
STAGE VARCHAR2(10),
! t; S1 J V1 C+ R& Y, {9 r STTEL VARCHAR2(20), O4 A$ p% N8 K. y1 Q. v2 S9 ~$ a
STDEPT VARCHAR2(20),, M {$ ]# X: |: ?$ ? X
STADDRESS VARCHAR2(50)
! s+ ], @. r Z7 L, N5 R)$ u- Q; e8 ~2 N: s/ T
tablespace USERS) B0 n, F0 p9 g* v# u; T
pctfree 102 E0 Z- y( n1 C; R8 u
initrans 16 T& Q( H8 V, h& G& U' w
maxtrans 255
/ D( `( a5 R0 G" N# b storage
/ i7 `* ~1 ~* q& w- e4 F2 q" i* b (! K1 x6 f0 a: U$ c6 A, z u' [
initial 64K
! q' e) \# S! i$ U: f3 I- T minextents 15 P) h) x3 X ~8 o
maxextents unlimited7 w- C9 X& H& u, S$ Q1 Z
);. ]& t `! O: Y0 s/ g2 f$ u
[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
7 W$ g/ `$ l) zminvalue 1. f" g2 `8 c( \) i; C
maxvalue 999999999999999999999999999
$ M/ Y9 M0 t9 B% zstart with ' at line 2
" }. g& F4 o$ S# j' Z/ n9 V[Err] -- Create sequence / D5 o4 l; m5 S- P
create sequence STU2_SEQ. ~3 R2 A: c9 i* n9 I, ]7 v9 q3 q
minvalue 11 q/ h- d7 H. Q* V. d
maxvalue 9999999999999999999999999991 ]/ L7 R# m y: {
start with 25
( _9 h7 x5 a: V w$ Yincrement by 1
- j) z5 e3 D- \, O, e/ Z Rnocache;8 e8 X, h) I) C# W5 }; T, D5 O
[Err] 1146 - Table 'student.student2' doesn't exist
5 p |' n" j6 c! `, N[Err]
; k0 W7 m/ F3 T. o2 @7 I% l& }[Msg] Finished - Unsuccessfully
6 A6 F' U/ P. b) `) `" ?& W--------------------------------------------------
9 A0 ^4 r7 L* ~6 p7 N9 c |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡
