Question

MySql中能给一个属性设置多个外键引用吗

Answer 1

create table users(
id int auto_increment primary key,
name varchar(50)
);

create table product1(
p_id int auto_increment primary key,
p_name varchar(50),
f_id int references users(id)
);

create table product2(
p_id int auto_increment primary key,
p_name varchar(50),
f_id int,
foreign key (f_id) references users(id)
);