create table product (
productid varchar(30) not null,
category varchar(30) not null,
name varchar(80) null,
descn varchar(255) null,
isPromot bit default 0,
registerTime datetime default getdate(),
constraint pk_product primary key (productid),
constraint fk_product_1 foreign key (category)
references category (catid)
);
加黑的语句是什么意思(isPromot bit default 0),要是用oracle数据库,怎么写?谢谢!
productid varchar(30) not null,
category varchar(30) not null,
name varchar(80) null,
descn varchar(255) null,
isPromot bit default 0,
registerTime datetime default getdate(),
constraint pk_product primary key (productid),
constraint fk_product_1 foreign key (category)
references category (catid)
);
加黑的语句是什么意思(isPromot bit default 0),要是用oracle数据库,怎么写?谢谢!
楼主【zhizhuo89】截止到2008-07-09 15:29:00的历史汇总数据(不包括此帖):
发帖的总数量:10 发帖的总分数:140 每贴平均分数:14
回帖的总数量:11 得分贴总数量:1 回帖的得分率:9%
结贴的总数量:6 结贴的总分数:60
无满意结贴数:3 无满意结贴分:60
未结的帖子数:4 未结的总分数:80
结贴的百分比:60.00 % 结分的百分比:42.86 %
无满意结贴率:50.00 % 无满意结分率:100.00%
楼主加油
类型bit
后面default 0 是指默认值为0 (也就是不插入记录时,不写的话就为0而不是null)在Oracle里也这么写
create table product (
productid varchar(30) not null,
category varchar(30) not null,
name varchar(80) null,
descn varchar(255) null,
isPromot number(1) default 0,
registerTime timestamp ,
constraint pk_product primary key (productid),
constraint fk_product_1 foreign key (category)
references category (catid)
);
productid varchar(30) not null,
category varchar(30) not null,
name varchar(80) null,
descn varchar(255) null,
isPromot number(1) default 0,
registerTime timestamp default sysdate,
constraint pk_product primary key (productid),
constraint fk_product_1 foreign key (category)
references category (catid)
);
productid varchar(30) not null,
category varchar(30) not null,
name varchar(80) null,
descn varchar(255) null,
isPromot number(1) default 0,
registerTime timestamp default systimestamp,
constraint pk_product primary key (productid),
constraint fk_product_1 foreign key (category)
references category (catid)
);