跨表查询
create database one default charset utf8;
use one ;
create table student (
sid int ,
sname
varchar(10),
saadress varchar(100)
);
create table course (
cid int ,
sid int ,
cname varchar(100)
);
insert into student values(1,‘关羽’,“许昌”),(2,‘诸葛亮’,“南阳”),(3,‘张飞’,“河北”),(4,‘刘备’,“四川”);
insert into course values (101,1,“三百回合不累法”),(102,2,“劝人投降话术”),(101,3,“三百回合不累法”),(102,4,“劝人投降话术”),(103,6,“如何俘获大桥和小乔”);
selectfrom student;
selectfrom course;
– 交叉查询
selectfrom student,course ;
selectfrom student,course where student.sid=course.sid;
– 内连接
select * from student inner join course on student.sid=course.sid;
– 左外连接
select * from student left outer join course on student.sid =course.sid;
– 右外连接
select * from student right outer join course on student.sid =course.sid;
– 全外连接
select * from student full outer join course on student.sid =course.sid;
tudent.sid =course.sid;