m0_49685374的博客

原创 新手常用SQL语句

MySQL常用SQL语句大全 **新手常用重点：多表联合查询： 一、外连接 1.左连接 left join 或 left outer join SQL语句：select * from student left join score on student.Num=score.Stu_id; 2.右连接 right join 或 right outer join SQL语句：select * from student right join score on student.Num=score.Stu_id;