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

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

DROP TABLE IF EXISTS student;
CREATE TABLE student(
xuehao INT NOT null PRIMARY KEY COMMENT '学号',
name VARCHAR(32) NOT NULL COMMENT '姓名',
addr VARCHAR(100) NOT NULL COMMENT '地址'
);
INSERT INTO student (xuehao,name,addr) VALUES (2016001,'张三','贵阳贵阳');
INSERT INTO student (xuehao,name,addr) VALUES    (2016002,'李芳','陕西兴平');
INSERT INTO student (xuehao,name,addr) VALUES    (2016003,'张晓燕','江西南昌');

DROP TABLE IF EXISTS chengji;
CREATE TABLE chengji(
kemu VARCHAR(32) NOT NULL COMMENT '科目',
xuehao INT NOT null COMMENT '学号',
fenshu INT COMMENT '分数',
FOREIGN KEY(xuehao) REFERENCES student(xuehao)
);
INSERT INTO chengji(kemu,xuehao,fenshu) VALUES ('计算机',2016001,99); 
INSERT INTO chengji(kemu,xuehao,fenshu) VALUES ('语文',2016001,85); 
INSERT INTO chengji(kemu,xuehao,fenshu) VALUES ('计算机',2016002,78);