非常感谢老师!
看图吧
班级表 创建及添加数据 在此省略...
创建student表
create table student(
sid int not null auto_increment primary key,
sname varchar(30),
gender enum(‘男‘,‘女‘)
)engine = innodb default charset = utf8
添加外键:
alter table student add constraint fk_c_s foreign key student(class_id) references class(cid);
student 添加数据
insert into student(sname,gender,class_id) values (‘钢蛋‘,‘女‘,1),(‘铁锤‘,‘女‘,1),(‘山炮‘,‘男‘,2);
创建teacher表
create table teacher(
tid int not null auto_increment primary key,
tname varchar(30)
)engine = innodb default charset = utf8
添加老师数据:
insert into teacher(tname) values (‘波多‘),(‘苍空‘),(‘饭岛‘);