mysql 查询

连接查询


select name,mark from student,mark where mark.stu_id = student.id;
也可以去一个别名（s 和m ）
select name,mark from student as s,mark as m where m.stu_id = s.id;
select s.name,m.mark from student as s,mark as m where m.stu_id = s.id;
(可以把逗号换成inner join)
select s.id, s.name,m.mark from student as s inner join mark as m where m.stu_id = s.id;------------------------统称内连接查询用的是 inner join。。。。on/where
左连接（以左边的表作为标准，用的是left join ，，，，，，on）
select s.id, s.name,m.mark from student as s inner join mark as m where m.stu_id = s.id;
右连接（以右边的表为标准,用的是right join ，，，，，，on）
select s.id, s.name,m.mark from student as s inner right mark as m where m.stu_id = s.id;


联合查询




子查询