关于MySQL数据库10

---

前言

提示：以下是本篇文章正文内容，下面案例可供参考

一、数据的准备

1.建表

代码如下（示例）：

mysql> create table emp(
    -> empno int,
    -> ename varchar(50),
    -> job varchar(50),
    -> mgr int,
    -> hiredate date,
    -> sal decimal(7,2),
    -> comm decimal(7,2),
    -> deptno int
-> );

2.插入数据

INSERT INTO emp values(7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20);
INSERT INTO emp values(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30);
INSERT INTO emp values(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30);
INSERT INTO emp values(7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20);
INSERT INTO emp values(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30);
INSERT INTO emp values(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30);
INSERT INTO emp values(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10);
INSERT INTO emp values(7788,'SCOTT','ANALYST',7566,'1987-04-19',3000,NULL,20);
INSERT INTO emp values(7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
INSERT INTO emp values(7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30);
INSERT INTO emp values(7876,'ADAMS','CLERK',7788,'1987-05-23',1100,NULL,20);
INSERT INTO emp values(7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30);
INSERT INTO emp values(7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20);
INSERT INTO emp values(7934,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,10);

二、基础查询语句

1.在什么里面in

1.查询学号不是S_1001,S_1002,S_1003的记录

代码如下（示例）：

select * from stu where sid not in('S_1001','S_1002','S_1003');

2.是否为空is（not）null

1.查询年龄为null的记录

select * from stu where age is null;

2.查询名字不为空的学生信息

select * from stu where sname is not null;

3.区间between

查询年龄为20~40岁之间的

方式一：

select * from stu where age >= 20 and age <= 40;

方式二：

select * from stu where age between 20 and 40;

4.非not

查询性别：非男的 学生记录

select * from stu where gender !='male';
select * from stu where gender <>'male';
select * from stu where not gender ='male';

---

总结

提示：这里对文章进行总结：
例如：以上就是今天要讲的内容，本文仅仅简单介绍了pandas的使用，而pandas提供了大量能使我们快速便捷地处理数据的函数和方法。