学习笔记（2):MySQL数据库从入门到实战课-表连接（内连接、外连接、自连接）...

立即学习:https://edu.csdn.net/course/play/27328/362530?utm_source=blogtoedu

drop table if exists score;
drop table if exists student;

create table student(
    stu_no varchar(20) not null primary key comment '学号',
    name varchar(30) comment '姓名',
    address varchar(150) comment '地址'
);

insert into student(stu_no,name,address) values('2016001', '张三','贵州贵阳');
insert into student(stu_no,name,address) values('2016002', '李芳','陕西兴平');
insert into student(stu_no,name,address) values('2016003', '张晓燕','江西南昌');

create table score(
    id int not null auto_increment primary key,
    course varchar(50) comment '科目',
    stu_no varchar(20) comment '学号',
    score int comment '分数',
    foreign key (stu_no) references student(stu_no)
);

insert into score(course,stu_no,score) values('计算机', '2016001','99');
insert into score(course,stu_no,score) values('离散数学', '2016001','85');
insert into score(course,stu_no,score) values('计算机', '2016002','78');