Question

constraint PK_G_OIL_WELL_UNP_ZONE_CLASS_S primary key clustered (ID) );老提示我缺少左括号

create table G_OIL_WELL_UNP_ZONE_CLASS_STAT
(
ID number(10) not null,
YEAR number(4) null,
PROJECT_ID VARCHAR2(10) null,
WELL_ID number(10) null,
PROJECT_NAME VARCHAR2(40) null,
WELL VARCHAR2(80) null,
NO_SHOT_ZONE VARCHAR2(80) null,
NO_SHOT_ZONE_NUM number(2) null,
NO_SHOT_EFF_THICK number(4,1) null,
ONE_YEAR_FILL_LAYER_ZONE VARCHAR2(80) null,
ONE_YEAR_FILL_LAYER_ZONE_NUM number(2) null,
ONE_YEAR_FILL_LAYER_EFF_THICK number(4,1) null,
WATERFLOODED_ZONE VARCHAR2(80) null,
WATERFLOODED_ZONE_NUM number(2) null,
WATERFLOODED_EFF_THICK number(4,1) null,
"HIGH_ WATERCUT_ZONE" VARCHAR2(80) null,
"HIGH_ WATERCUT_ZONE_NUM" number(2) null,
"HIGH_ WATERCUT_EFF_THICK" number(4,1) null,
OIL_WATER_LAYERS_ZONE VARCHAR2(80) null,
OIL_WATER_LAYERS_ZONE_NUM number(2) null,
OIL_WATER_LAYERS_EFF_THICK number(4,1) null,
BAD_DOWN_SIT_ZONE VARCHAR2(80) null,
BAD_DOWN_SIT_ZONE_NUM number(2) null,
BAD_DOWN_SIT_EFF_THICK number(4,1) null,
POTATO_LAYERS_ZONE VARCHAR2(80) null,
POTATO_LAYERS_ZONE_NUM number(2) null,
POTATO_LAYERS_EFF_THICK number(4,1) null,
LAYERGROUP_WELL_ZONE VARCHAR2(80) null,
LAYERGROUP_WELL_ZONE_NUM number(2) null,
LAYERGROUP_WELL_EFF_THICK number(4,1) null,
CREATE_DATE date null,
CREATE_USER_ID VARCHAR2(30) null,
COMMENTS VARCHAR2(300) null,
constraint PK_G_OIL_WELL_UNP_ZONE_CLASS_S primary key clustered (ID)
);
这是完整的建表语句，为什么老提示我在clustered的左边缺少左括号？加上以后又提示我不是有效的字符。郁闷！！在线等高手解答！

Answer 1

你这是什麽数据库，sql server/mysql/oracle

追问

字段类型number必须是oracle嘛- -。。
mysql哪里有number的类型- -。。

追答

你把建表时的 clustered 去掉，单独用语句检这个索引把
create clustered index 索引名 on 表名(列名)