MySql多表查询
select * from 表1,表2 where 表。字段1 = 表2。字段2;
内连接
SELECT * FROM student,result WHERE student.id = result.rid;
SELECT * FROM student s INNER JOIN result r ON s.id = r.rid;
外连接
SELECT * FROM student left JOIN result on student.id = result.rid
SELECT * FROM student right JOIN result on student.id = result.rid
自连接
联合查询
子查询
标量子查询
select * from 表 where = (select 查询内容 form 表 where 条件);
列子查询
返回结果为一列,any/some代表满足查询结果中任意一条信息,all需要满足全部信息;
行子查询
查询返回结果为一行多列
表子查询
返回结果为一张表,