实习8

msl数据库
1.数据库概述

2.mysql概述

3.sql分类

4.实践
/查询性别为女，并且年龄50的记录/
SELECT * FROM stu1 WHERE gender=‘男’ AND age=16;
/查询学号为S_1001，或者姓名为liSi的记录/
SELECT * FROM xxb WHERE sid= “1” OR sname=“王富贵”;
/查询学号为S_1001，S_1002，S_1003的记录/
SELECT * FROM xxb WHERE sid IN (1,2,3);
/查询学号不是S_1001，S_1002，S_1003的记录/
SELECT * FROM xxb WHERE sid NOT IN (1,2,3);
/查询年龄为null的记录/
SELECT * FROM xxb WHERE age IS NULL;
/查询年龄在20到40之间的学生记录/
SELECT * FROM xxb WHERE age>=15 AND age<=40;
/查询性别非男的学生记录/
SELECT * FROM xxb WHERE gender!=“男”;
/查询姓名不为null的学生记录/
SELECT * FROM xxb WHERE sname IS NOT NULL;

1，内连接
SELECT c.score, s.name
FROM student s ,score c WHERE
s.id=c.sid AND sid=1

SELECT * FROM student INNER JOIN score
ON student.id=score.sid;

#2.外连接 左连接 右连接
SELECT *
FROM student LEFT JOIN score
ON student.id=score.sid;

SELECT *
FROM score RIGHT JOIN student
ON student.id=score.sid;

SELECT *
FROM student RIGHT JOIN score
ON student.id=score.sid;