第一种方式:通过创建表的过程中进行添加外键,和其他表的字段进行联系。
create table teacher(
id int unsigned auto_increment,
name varchar(20),
primary key (id)
);
create table student(
id int unsigned auto_increment,
name varchar(20),
gender enum('男','女','保密'),
tid int unsigned,
primary key (id),
constraint stfk foreign key(tid)references teacher(id)
);
第二种方式:创建表后,再添加外键。
create table student(
id int unsigned auto_increment,
name varchar(20),
gender enum('男','女','保密'),
primary key (id),
);
create table teacher(
id int unsigned auto_increment,
name varchar(20),
primary key (id)
);
alter table student add tid int;
alter table student add constraint stfk foreign key (tid) references teacher(id);