create table student
(
id int auto_increment,
name char(8),
score int ,
cid int,
Primary Key(id)
)engine=innodb;
insert into student(name,score,cid)value('顺子',88,'2'),
('小张',82,3),
('小顿',49,2),
('小个',29,3),
('小啊',42,1),
('小换',89,3);
create table classes
(
cid int auto_increment,
cname char(50),
primary key(cid)
)engine=innodb;
insert into classes(cname)value('终极一班'),
('终极二班'),
('终极三班');
alter table student
add constraint stu_clas_fk foreign key(cid) references classes(cid);
select student.id,student.name,student.score,cname from
student inner join classes on student.cid=classes.cid;
-- 个人总结: 一对多就应该把多中的一列设置成外键 一中的一列设置成他的引用
(
id int auto_increment,
name char(8),
score int ,
cid int,
Primary Key(id)
)engine=innodb;
insert into student(name,score,cid)value('顺子',88,'2'),
('小张',82,3),
('小顿',49,2),
('小个',29,3),
('小啊',42,1),
('小换',89,3);
create table classes
(
cid int auto_increment,
cname char(50),
primary key(cid)
)engine=innodb;
insert into classes(cname)value('终极一班'),
('终极二班'),
('终极三班');
alter table student
add constraint stu_clas_fk foreign key(cid) references classes(cid);
select student.id,student.name,student.score,cname from
student inner join classes on student.cid=classes.cid;
-- 个人总结: 一对多就应该把多中的一列设置成外键 一中的一列设置成他的引用