(数据库)SQL---未能创建约束.高手帮看下.?

来源:百度知道 编辑:UC知道 时间:2024/06/13 18:31:10
create database vote

use vote

create table voteMaster
(
voteID int primary key,
voteTitle varchar(100) not null,
voteSum int default 0
)
insert into voteMaster values(1,'选举工会主席!',0)
insert into voteMaster values(2,'对网站建设的意见',0)
select * from voteMaster

create table voteDetails

(
voteID int foreign key references voteMaster(voteID),
voteDetailsID int not null,
voteItem varchar(20) not null,
voteNum int default 0,
primary key(voteID,voteDtailsID)
)
insert into voteDetails values(1,1,'小明',0)
insert into voteDetails values(1,2,'小刚',0)
insert into voteDetails values(1,3,'无名',0)

insert into voteDetails values(2,1,'非常好',0)
insert into voteDetails values(2,2,'好',0)
insert into voteDetails values(2,3,'一般',0)
insert into voteDetails values(2,4,'需要改进',0)<

create table voteDetails
(
voteID int foreign key references voteMaster(voteID),
voteDetailsID int not null,
voteItem varchar(20) not null,
voteNum int default 0,
primary key(voteID,voteDtailsID)
)
你马虎了,最后一行primary key(voteID,voteDtailsID)应该为primary key(voteID,voteDetailsID)