UC知道怎么与联合主键建立外键关系
来源：百度知道 编辑：UC知道 时间：2024/06/05 17:58:00
create table voteDetails
(
voteId int foreign key refereneces voteMaster(voteId),
voteDetails int not null,
voteItem varchar(50) not null,
voteSum int not null,
primary key(voteId,voteDetails) --联合主键
)
create table voteLog
(
如何建立与voteDetails表的外键关系？
)
问题已解决，分会给第一个回答的朋友
(
voteId int foreign key refereneces voteMaster(voteId),
voteDetails int not null,
voteItem varchar(50) not null,
voteSum int not null,
primary key(voteId,voteDetails) --联合主键
)
create table voteLog
(
如何建立与voteDetails表的外键关系？
)
问题已解决，分会给第一个回答的朋友
联合主键建立外键跟简单主键一样的，示例：
mysql> create table tb_key1(id int, itemid int, memo
-> \c
mysql> create table tb_key1(id int, itemid int, memo varchar(20),
-> primary key(id,itemid)
-> );
Query OK, 0 rows affected (0.09 sec)
mysql> create table tb_key2(newid int, itemid int, name varchar(50),
-> foreign key (newid,itemid) references tb_key1(id,itemid)
-> );
Query OK, 0 rows affected (0.08 sec)
mysql> create table tb_key3(myid int,remark varchar(100),
-> foreign key(myid) references tb_key1(id)
-> );
Query OK, 0 rows affected (0.13 sec)
mysql>
create table parent(c1 number,c2 number,
primary key(c1,c2));
create table child (c1 number primary key,
c2 number,c3 number,
foreign key(c2,c3) references parent(c1,c2));