m0_49685374的博客

原创 新手常用SQL语句

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