(数据库)SQL---未能创建约束.高手帮看下.?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 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)
)
没有问题.执行查询时.提示
服务器: 消息 1911，级别 16，状态 1，行 1
目标表中不存在列名 "voteDtailsID"。
服务器: 消息 1750，级别 16，状态 1，行 1
未能创建约束。请参阅前面的错误信息。 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)哈哈.的确.唉真是的看了好久.原来在这没想到.
多谢多谢.留个QQ号吧.
|
