MySQL(二)

知识点一：mysql 查询方法

is null , is not null

演示: is null   is not null

create table t1 (id int,name varchar(10));  # 创建
insert into t1(id) values(1),(2);

insert into t1 values (3,'qiye');
select * from t1 where name is null;
select * from t1 where name is not null;

and,or,not

select number from students where 16<= age and age<=21;
    特殊:select number from students where 16<=age<=21;       #相当于or，但基本不这么用

select * from students where age<=16 or age>=22;
select * from students where not age=16;       把age=16的排除掉，然后输出

select * from students where age=16 and ...  可以依次往后写条件 
    优先级:not>and>or

排序

select * from students order by age;   # 正序
select * from students order by age desc; # 倒序

限制

#原数据表
+-----------+----------+------+------------+
| number    | name     | age  | birth      |
+-----------+----------+------+------------+
| 201804001 | Qiye     |   16 | 2002-01-01 |
| 201804002 | JackLee  |   17 | 2001-01-02 |
| 201804003 | Julia    |   18 | 2000-01-03 |
| 201804004 | Stefer   |   19 | 2001-01-04 |
| 201804005 | Steven   |   20 | 2000-01-05 |
| 201804006 | Mark     |   21 | 1999-01-06 |
| 201804007 | Stark    |   22 | 1999-01-07 |
| 201804008 | Tonny    |   23 | 1999-01-08 |
| 201804009 | Jarvis   |   24 | 1999-01-09 |
| 201804010 | ZhangSan |   25 | 1999-01-10 |
| 201804011 | lisi     |   23 | 1990-04-10 |
| 201804012 | wanger   |   20 | 1991-01-10 |
| 201804013 | mazi     |   21 | 1993-01-13 |
| 201804014 | xiaoxing |   80 | 1995-01-22 |
| 201804015 | hundan   |   36 | 1998-05-10 |
| 201804016 | xiaowang |   30 | 1999-07-10 |
| 201804017 | laowang  |   18 | 1997-08-10 |
+-----------+----------+------+------------+
select * from students limit 5;     #输出5条，按表的顺序从上到下输出5条
+-----------+---------+------+------------+
| number    | name    | age  | birth      |
+-----------+---------+------+------------+
| 201804001 | Qiye    |   16 | 2002-01-01 |
| 201804002 | JackLee |   17 | 2001-01-02 |
| 201804003 | Julia   |   18 | 2000-01-03 |
| 201804004 | Stefer  |   19 | 2001-01-04 |
| 201804005 | Steven  |   20 | 2000-01-05 |
+-----------+---------+------+------------+
select * from students limit 3,3;      #从第4条开始输出3条   计算机内部的排序是从0开始，0.1.2.3.4.5...，不是1

去重

select * from grades;

select distinct 字段 from 表名;    #不会改变原表格，会把去重完的结果输出出来

模糊查询

select * from students;
select * from students where name like 'xi%';# 任意多个    %:匹配多个，可以有任意多个，xi开头的都输出出来
select * from students where name like 'li__';# 匹配任意一个，后面几个横线就代表li什么什么，共三个字，输出li什么什么，此处为两个

范围查询

select * from students where age in (1,16,22);     #查找1,16,22的数

select * from students where age between 16 and 22;    #一个区间内的所有数据

聚合函数

函数名	作用
max	最大值
min	最小值
count	计数
sum	总和
avg	平均值

#原表数据
+-----------+----------+------+------------+
| number    | name     | age  | birth      |
+-----------+----------+------+------------+
| 201804001 | Qiye     |   16 | 2002-01-01 |
| 201804002 | JackLee  |   17 | 2001-01-02 |
| 201804003 | Julia    |   18 | 2000-01-03 |
| 201804004 | Stefer   |   19 | 2001-01-04 |
| 201804005 | Steven   |   20 | 2000-01-05 |
| 201804006 | Mark     |   21 | 1999-01-06 |
| 201804007 | Stark    |   22 | 1999-01-07 |
| 201804008 | Tonny    |   23 | 1999-01-08 |
| 201804009 | Jarvis   |   24 | 1999-01-09 |
| 201804010 | ZhangSan |   25 | 1999-01-10 |
| 201804011 | lisi     |   23 | 1990-04-10 |
| 201804012 | wanger   |   20 | 1991-01-10 |
| 201804013 | mazi     |   21 | 1993-01-13 |
| 201804014 | xiaoxing |   80 | 1995-01-22 |
| 201804015 | hundan   |   36 | 1998-05-10 |
| 201804016 | xiaowang |   30 | 1999-07-10 |
| 201804017 | laowang  |   18 | 1997-08-10 |
+-----------+----------+------+------------+
(1)select *from students;
select count(*) from students;   统计数量 #（）里可以换别的字段，它只会统计数量，不看内容是什么
(2)select avg(age) from students;  平均年龄  #括号里字段里的内容必须是数字，否则会返回零，但不报错
(3)select group_concat(name) from students; 返回连接的字符串
#输出:
+---------------------------------------------------------------------------------------------------------------------+
| group_concat(name)                                                                                                  |
+---------------------------------------------------------------------------------------------------------------------+
| Qiye,JackLee,Julia,Stefer,Steven,Mark,Stark,Tonny,Jarvis,ZhangSan,lisi,wanger,mazi,xiaoxing,hundan,xiaowang,laowang |
+---------------------------------------------------------------------------------------------------------------------+

select group_concat(age) from students;
#输出:
+----------------------------------------------------+
| group_concat(age)                                  |
+----------------------------------------------------+
| 16,17,18,19,20,21,22,23,24,25,23,20,21,80,36,30,18 |
+----------------------------------------------------+

(4)select max(age) from students; 年龄最大
(5)select min(age) from students; 年龄最小

分组

#原数据表格
+----------------+----------------+-------+
| student_number | subject_number | grade |
+----------------+----------------+-------+
| 201804001      | 0001           |    90 |
| 201804002      | 0001           |    89 |
| 201804003      | 0001           |    88 |
| 201804004      | 0001           |    87 |
| 201804005      | 0001           |    86 |
| 201804006      | 0001           |    85 |
| 201804007      | 0001           |    84 |
| 201804008      | 0001           |    83 |
| 201804009      | 0001           |    82 |
| 201804017      | 0001           |    91 |
| 201804016      | 0001           |    91 |
| 201804011      | 0001           |    91 |
| 201804010      | 0001           |    81 |
| 201804001      | 0002           |    80 |
| 201804002      | 0002           |    79 |
| 201804003      | 0002           |    78 |
| 201804004      | 0002           |    77 |
| 201804005      | 0002           |    76 |
| 201804006      | 0002           |    75 |
| 201804007      | 0002           |    74 |
| 201804008      | 0002           |    73 |
| 201804009      | 0002           |    72 |
| 201804010      | 0002           |    71 |
| 201804012      | 0001           |    91 |
| 201804013      | 0001           |    91 |
| 201804014      | 0001           |    91 |
| 201804015      | 0001           |    91 |
| 201804016      | 0001           |    91 |
+----------------+----------------+-------+
(1)select subject_number from grades group by subject_number; # 去重+排序，去重完每类都为一组，这里数据只有0001和0002，去重完是两组
+----------------+
| subject_number |
+----------------+
| 0001           |
| 0002           |
+----------------+
select subject_number,count(*) from grades group by subject_number; #展示每组有几个，展示的组必须是上一步分的组
+----------------+----------+
| subject_number | count(*) |
+----------------+----------+
| 0001           |       18 |
| 0002           |       10 |
+----------------+----------+
#必须先分组，再展示
select subject_number,count(grade) from grades group by subject_number; 
+----------------+--------------+
| subject_number | count(grade) |
+----------------+--------------+
| 0001           |           18 |
| 0002           |           10 |
+----------------+--------------+
select subject_number,count(student_number) from grades group by subject_number;
+----------------+-----------------------+
| subject_number | count(student_number) |
+----------------+-----------------------+
| 0001           |                    18 |
| 0002           |                    10 |
+----------------+-----------------------+

注:分好组后，还可以对他进行条件限制:

(2)select subject_number,count(*) from grades group by subject_number,grade having grade>=80;  #分两次组
#输出:
+----------------+----------+
| subject_number | count(*) |
+----------------+----------+
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        1 |
| 0001           |        8 |
| 0002           |        1 |
+----------------+----------+
select 
    subject_number,count(*)
from grades 
group by 
    subject_number,grade 
having grade>=80;      #先执行80的条件
(3)select subject_number,grade,count(*) from grades group by subject_number,grade having grade>=80;
+----------------+-------+----------+
| subject_number | grade | count(*) |
+----------------+-------+----------+
| 0001           |    81 |        1 |
| 0001           |    82 |        1 |
| 0001           |    83 |        1 |
| 0001           |    84 |        1 |
| 0001           |    85 |        1 |
| 0001           |    86 |        1 |
| 0001           |    87 |        1 |
| 0001           |    88 |        1 |
| 0001           |    89 |        1 |
| 0001           |    90 |        1 |
| 0001           |    91 |        8 |
| 0002           |    80 |        1 |
+----------------+-------+----------+
select subject_number,grade,count(student_number) from grades group by subject_number,grade having grade>=80;
+----------------+-------+-----------------------+
| subject_number | grade | count(student_number) |
+----------------+-------+-----------------------+
| 0001           |    81 |                     1 |
| 0001           |    82 |                     1 |
| 0001           |    83 |                     1 |
| 0001           |    84 |                     1 |
| 0001           |    85 |                     1 |
| 0001           |    86 |                     1 |
| 0001           |    87 |                     1 |
| 0001           |    88 |                     1 |
| 0001           |    89 |                     1 |
| 0001           |    90 |                     1 |
| 0001           |    91 |                     8 |
| 0002           |    80 |                     1 |
+----------------+-------+-----------------------+

可以跟where

知识点二：子查询

#原表数据
+-----------+----------+------+------------+
| number    | name     | age  | birth      |
+-----------+----------+------+------------+
| 201804001 | Qiye     |   16 | 2002-01-01 |
| 201804002 | JackLee  |   17 | 2001-01-02 |
| 201804003 | Julia    |   18 | 2000-01-03 |
| 201804004 | Stefer   |   19 | 2001-01-04 |
| 201804005 | Steven   |   20 | 2000-01-05 |
| 201804006 | Mark     |   21 | 1999-01-06 |
| 201804007 | Stark    |   22 | 1999-01-07 |
| 201804008 | Tonny    |   23 | 1999-01-08 |
| 201804009 | Jarvis   |   24 | 1999-01-09 |
| 201804010 | ZhangSan |   25 | 1999-01-10 |
| 201804011 | lisi     |   23 | 1990-04-10 |
| 201804012 | wanger   |   20 | 1991-01-10 |
| 201804013 | mazi     |   21 | 1993-01-13 |
| 201804014 | xiaoxing |   80 | 1995-01-22 |
| 201804015 | hundan   |   36 | 1998-05-10 |
| 201804016 | xiaowang |   30 | 1999-07-10 |
| 201804017 | laowang  |   18 | 1997-08-10 |
+-----------+----------+------+------------+
(1)# 子查询是 MySQL 中比较常用的查询方法，通过子查询可以实现多表查询。
select * from (select * from students order by age limit 5) as 别名;
例:mysql> select * from (select * from students order by age limit 5) as qq;
+-----------+---------+------+------------+
| number    | name    | age  | birth      |
+-----------+---------+------+------------+
| 201804001 | Qiye    |   16 | 2002-01-01 |
| 201804002 | JackLee |   17 | 2001-01-02 |
| 201804003 | Julia   |   18 | 2000-01-03 |
| 201804017 | laowang |   18 | 1997-08-10 |
| 201804004 | Stefer  |   19 | 2001-01-04 |
+-----------+---------+------+------------+
(2)#嵌套多层:
Ⅰselect * from (select * from (select * from students order by age limit 5) as 别名1) as 别名2;    
#可以套where，别名只能是英文字母，连数字也不可以

Ⅱselect * from (select * from (select * from students order by age limit 10) as ww where age>=18) as qq where age >=20;
+-----------+--------+------+------------+
| number    | name   | age  | birth      |
+-----------+--------+------+------------+
| 201804005 | Steven |   20 | 2000-01-05 |
| 201804012 | wanger |   20 | 1991-01-10 |
| 201804006 | Mark   |   21 | 1999-01-06 |
| 201804013 | mazi   |   21 | 1993-01-13 |
| 201804007 | Stark  |   22 | 1999-01-07 |
+-----------+--------+------+------------+
Ⅱ这里的select * from students order by age limit 10，就是先正排序，然后输出前十条

1、内连接，拼接

其实就是找并集
#先创建两个新表，并写入数据
create table t1 (id int,name varchar(10));
create table t2 (id int,name varchar(10)); 
insert into t1 values(4,'ja'),(6,'asd');
insert into t2 values(4,'ja'),(5,'wwa');
(1)select * from t1 join t2;    #把两个表拼在一起，没有on条件限制的话就是笛卡尔链接
+------+------+------+------+
| id   | name | id   | name |
+------+------+------+------+
|    4 | ja   |    4 | ja   |
|    6 | asd  |    4 | ja   |
|    4 | ja   |    5 | wwa  |
|    6 | asd  |    5 | wwa  |
+------+------+------+------+
(2)select * from t1 join t2 on t1.name=t2.name;
+------+------+------+------+
| id   | name | id   | name |
+------+------+------+------+
|    4 | ja   |    4 | ja   |
+------+------+------+------+
#t1的每一条数据都会和t2的每一条数据进行组合寻找，找到name一样的，并且组合在一起，然后输出

#三表拼接:
  select * from subjects join grades on subjects.number=grades.subject_number join students on students.number=grades.student_number;
  select students.number,students.name from subjects join grades on subjects.number=grades.subject_number join students on students.number=grades.student_number;
(3)select * from t1 join t2 on  name = 'ja';      # 报错
select * from t1 join t2 on  t1.name = 'ja';
表名1.id = 表名2.id

(4)#表grades
+----------------+----------------+-------+
| student_number | subject_number | grade |
+----------------+----------------+-------+
| 201804001      | 0001           |    90 |
| 201804002      | 0001           |    89 |
| 201804003      | 0001           |    88 |
| 201804004      | 0001           |    87 |
| 201804005      | 0001           |    86 |
| 201804006      | 0001           |    85 |
| 201804007      | 0001           |    84 |
| 201804008      | 0001           |    83 |
| 201804009      | 0001           |    82 |
| 201804017      | 0001           |    91 |
| 201804016      | 0001           |    91 |
| 201804011      | 0001           |    91 |
| 201804010      | 0001           |    81 |
| 201804001      | 0002           |    80 |
| 201804002      | 0002           |    79 |
| 201804003      | 0002           |    78 |
| 201804004      | 0002           |    77 |
| 201804005      | 0002           |    76 |
| 201804006      | 0002           |    75 |
| 201804007      | 0002           |    74 |
| 201804008      | 0002           |    73 |
| 201804009      | 0002           |    72 |
| 201804010      | 0002           |    71 |
| 201804012      | 0001           |    91 |
| 201804013      | 0001           |    91 |
| 201804014      | 0001           |    91 |
| 201804015      | 0001           |    91 |
| 201804016      | 0001           |    91 |
+----------------+----------------+-------+
#表subjects
+--------+--------+----------+
| number | title  | duration |
+--------+--------+----------+
| 0001   | python |       32 |
| 0002   | java   |       16 |
| 0003   | web    |       16 |
| 0004   | go     |       32 |
| 0005   | c++    |       32 |
+--------+--------+----------+
#笛卡尔链接---一个一个的映射关系
select * from grades join subjects on grades.subject_number=subjects.number;  #把相同的组合在一起
+----------------+----------------+-------+--------+--------+----------+
| student_number | subject_number | grade | number | title  | duration |
+----------------+----------------+-------+--------+--------+----------+
| 201804001      | 0001           |    90 | 0001   | python |       32 |
| 201804002      | 0001           |    89 | 0001   | python |       32 |
| 201804003      | 0001           |    88 | 0001   | python |       32 |
| 201804004      | 0001           |    87 | 0001   | python |       32 |
| 201804005      | 0001           |    86 | 0001   | python |       32 |
| 201804006      | 0001           |    85 | 0001   | python |       32 |
| 201804007      | 0001           |    84 | 0001   | python |       32 |
| 201804008      | 0001           |    83 | 0001   | python |       32 |
| 201804009      | 0001           |    82 | 0001   | python |       32 |
| 201804017      | 0001           |    91 | 0001   | python |       32 |
| 201804016      | 0001           |    91 | 0001   | python |       32 |
| 201804011      | 0001           |    91 | 0001   | python |       32 |
| 201804010      | 0001           |    81 | 0001   | python |       32 |
| 201804001      | 0002           |    80 | 0002   | java   |       16 |
| 201804002      | 0002           |    79 | 0002   | java   |       16 |
| 201804003      | 0002           |    78 | 0002   | java   |       16 |
| 201804004      | 0002           |    77 | 0002   | java   |       16 |
| 201804005      | 0002           |    76 | 0002   | java   |       16 |
| 201804006      | 0002           |    75 | 0002   | java   |       16 |
| 201804007      | 0002           |    74 | 0002   | java   |       16 |
| 201804008      | 0002           |    73 | 0002   | java   |       16 |
| 201804009      | 0002           |    72 | 0002   | java   |       16 |
| 201804010      | 0002           |    71 | 0002   | java   |       16 |
| 201804012      | 0001           |    91 | 0001   | python |       32 |
| 201804013      | 0001           |    91 | 0001   | python |       32 |
| 201804014      | 0001           |    91 | 0001   | python |       32 |
| 201804015      | 0001           |    91 | 0001   | python |       32 |
| 201804016      | 0001           |    91 | 0001   | python |       32 |
+----------------+----------------+-------+--------+--------+----------+

####重点:嵌套查询套拼接
select * from ( select * from students where age>18) as qq join (select student_number, subject_number from subjects join grades on subjects.number=grades.subject_number where number = 0001) as aa on qq.number=aa.student_number

select distinct name from (select * from ( select * from students where age>18) as qq join (select student_number, subject_number from subjects join grades on subjects.number=grades.subject_number where number = 0001) as aa on qq.number=aa.student_number) as zz    #再给他去重

2、外连接

外链接
左外链接
链接条件不匹配： select *from t1 join t2 on t1.name= 'qiye';
select * from t1 left join t2 on t1.name= 'jack';
#表长必须一样
select * from t1 left join students on t1.name= 'Qiye';
+------+------+-----------+----------+------+------------+
| id   | name | number    | name     | age  | birth      |
+------+------+-----------+----------+------+------------+
|    9 | Qiye | 201804001 | Qiye     |   16 | 2002-01-01 |
|    9 | Qiye | 201804002 | JackLee  |   17 | 2001-01-02 |
|    9 | Qiye | 201804003 | Julia    |   18 | 2000-01-03 |
|    9 | Qiye | 201804004 | Stefer   |   19 | 2001-01-04 |
|    9 | Qiye | 201804005 | Steven   |   20 | 2000-01-05 |
|    9 | Qiye | 201804006 | Mark     |   21 | 1999-01-06 |
|    9 | Qiye | 201804007 | Stark    |   22 | 1999-01-07 |
|    9 | Qiye | 201804008 | Tonny    |   23 | 1999-01-08 |
|    9 | Qiye | 201804009 | Jarvis   |   24 | 1999-01-09 |
|    9 | Qiye | 201804010 | ZhangSan |   25 | 1999-01-10 |
|    9 | Qiye | 201804011 | lisi     |   23 | 1990-04-10 |
|    9 | Qiye | 201804012 | wanger   |   20 | 1991-01-10 |
|    9 | Qiye | 201804013 | mazi     |   21 | 1993-01-13 |
|    9 | Qiye | 201804014 | xiaoxing |   80 | 1995-01-22 |
|    9 | Qiye | 201804015 | hundan   |   36 | 1998-05-10 |
|    9 | Qiye | 201804016 | xiaowang |   30 | 1999-07-10 |
|    9 | Qiye | 201804017 | laowang  |   18 | 1997-08-10 |
|    4 | ja   | NULL      | NULL     | NULL | NULL       |
|    6 | asd  | NULL      | NULL     | NULL | NULL       |
|   11 | qewq | NULL      | NULL     | NULL | NULL       |
|   33 | brny | NULL      | NULL     | NULL | NULL       |
+------+------+-----------+----------+------+------------+
select * from t1 left join t2 on t1.name= 'qiye';
左表的全部展示出来  右边只会显示符合搜索条件的  不同的用null


右外链接
select *from t1 right join t2 on t1.name= 'qiye';

select * from students;
jacklee 考了多少分

select * from students join grades on students.number=grades.student_number;
+-----------+----------+------+------------+----------------+----------------+-------+
| number    | name     | age  | birth      | student_number | subject_number | grade |
+-----------+----------+------+------------+----------------+----------------+-------+
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804001      | 0001           |    90 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804002      | 0001           |    89 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804003      | 0001           |    88 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804004      | 0001           |    87 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804005      | 0001           |    86 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804006      | 0001           |    85 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804007      | 0001           |    84 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804008      | 0001           |    83 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804009      | 0001           |    82 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804017      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804016      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804011      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804010      | 0001           |    81 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804001      | 0002           |    80 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804002      | 0002           |    79 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804003      | 0002           |    78 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804004      | 0002           |    77 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804005      | 0002           |    76 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804006      | 0002           |    75 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804007      | 0002           |    74 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804008      | 0002           |    73 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804009      | 0002           |    72 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804010      | 0002           |    71 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804012      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804013      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804014      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804015      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804016      | 0001           |    91 |
+-----------+----------+------+------------+----------------+----------------+-------+


sum 求和
select count(*) from students join grades; # 查看多少条数据，count:计数
+----------+
| count(*) |
+----------+
|      476 |
+----------+
select * from students join grades;  #每个都组合一次
+-----------+----------+------+------------+----------------+----------------+-------+
| number    | name     | age  | birth      | student_number | subject_number | grade |
+-----------+----------+------+------------+----------------+----------------+-------+
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804001      | 0001           |    90 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804001      | 0001           |    90 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804001      | 0001           |    90 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804001      | 0001           |    90 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804001      | 0001           |    90 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804001      | 0001           |    90 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804001      | 0001           |    90 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804001      | 0001           |    90 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804001      | 0001           |    90 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804001      | 0001           |    90 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804001      | 0001           |    90 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804001      | 0001           |    90 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804001      | 0001           |    90 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804001      | 0001           |    90 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804001      | 0001           |    90 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804001      | 0001           |    90 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804001      | 0001           |    90 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804002      | 0001           |    89 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804002      | 0001           |    89 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804002      | 0001           |    89 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804002      | 0001           |    89 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804002      | 0001           |    89 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804002      | 0001           |    89 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804002      | 0001           |    89 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804002      | 0001           |    89 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804002      | 0001           |    89 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804002      | 0001           |    89 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804002      | 0001           |    89 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804002      | 0001           |    89 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804002      | 0001           |    89 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804002      | 0001           |    89 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804002      | 0001           |    89 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804002      | 0001           |    89 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804002      | 0001           |    89 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804003      | 0001           |    88 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804003      | 0001           |    88 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804003      | 0001           |    88 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804003      | 0001           |    88 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804003      | 0001           |    88 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804003      | 0001           |    88 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804003      | 0001           |    88 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804003      | 0001           |    88 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804003      | 0001           |    88 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804003      | 0001           |    88 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804003      | 0001           |    88 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804003      | 0001           |    88 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804003      | 0001           |    88 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804003      | 0001           |    88 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804003      | 0001           |    88 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804003      | 0001           |    88 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804003      | 0001           |    88 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804004      | 0001           |    87 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804004      | 0001           |    87 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804004      | 0001           |    87 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804004      | 0001           |    87 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804004      | 0001           |    87 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804004      | 0001           |    87 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804004      | 0001           |    87 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804004      | 0001           |    87 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804004      | 0001           |    87 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804004      | 0001           |    87 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804004      | 0001           |    87 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804004      | 0001           |    87 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804004      | 0001           |    87 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804004      | 0001           |    87 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804004      | 0001           |    87 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804004      | 0001           |    87 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804004      | 0001           |    87 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804005      | 0001           |    86 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804005      | 0001           |    86 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804005      | 0001           |    86 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804005      | 0001           |    86 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804005      | 0001           |    86 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804005      | 0001           |    86 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804005      | 0001           |    86 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804005      | 0001           |    86 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804005      | 0001           |    86 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804005      | 0001           |    86 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804005      | 0001           |    86 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804005      | 0001           |    86 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804005      | 0001           |    86 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804005      | 0001           |    86 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804005      | 0001           |    86 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804005      | 0001           |    86 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804005      | 0001           |    86 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804006      | 0001           |    85 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804006      | 0001           |    85 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804006      | 0001           |    85 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804006      | 0001           |    85 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804006      | 0001           |    85 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804006      | 0001           |    85 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804006      | 0001           |    85 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804006      | 0001           |    85 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804006      | 0001           |    85 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804006      | 0001           |    85 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804006      | 0001           |    85 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804006      | 0001           |    85 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804006      | 0001           |    85 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804006      | 0001           |    85 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804006      | 0001           |    85 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804006      | 0001           |    85 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804006      | 0001           |    85 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804007      | 0001           |    84 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804007      | 0001           |    84 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804007      | 0001           |    84 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804007      | 0001           |    84 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804007      | 0001           |    84 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804007      | 0001           |    84 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804007      | 0001           |    84 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804007      | 0001           |    84 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804007      | 0001           |    84 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804007      | 0001           |    84 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804007      | 0001           |    84 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804007      | 0001           |    84 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804007      | 0001           |    84 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804007      | 0001           |    84 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804007      | 0001           |    84 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804007      | 0001           |    84 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804007      | 0001           |    84 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804008      | 0001           |    83 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804008      | 0001           |    83 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804008      | 0001           |    83 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804008      | 0001           |    83 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804008      | 0001           |    83 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804008      | 0001           |    83 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804008      | 0001           |    83 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804008      | 0001           |    83 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804008      | 0001           |    83 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804008      | 0001           |    83 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804008      | 0001           |    83 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804008      | 0001           |    83 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804008      | 0001           |    83 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804008      | 0001           |    83 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804008      | 0001           |    83 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804008      | 0001           |    83 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804008      | 0001           |    83 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804009      | 0001           |    82 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804009      | 0001           |    82 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804009      | 0001           |    82 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804009      | 0001           |    82 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804009      | 0001           |    82 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804009      | 0001           |    82 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804009      | 0001           |    82 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804009      | 0001           |    82 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804009      | 0001           |    82 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804009      | 0001           |    82 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804009      | 0001           |    82 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804009      | 0001           |    82 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804009      | 0001           |    82 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804009      | 0001           |    82 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804009      | 0001           |    82 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804009      | 0001           |    82 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804009      | 0001           |    82 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804017      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804017      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804017      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804017      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804017      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804017      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804017      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804017      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804017      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804017      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804017      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804017      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804017      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804017      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804017      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804017      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804017      | 0001           |    91 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804016      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804016      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804016      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804016      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804016      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804016      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804016      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804016      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804016      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804016      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804016      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804016      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804016      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804016      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804016      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804016      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804016      | 0001           |    91 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804011      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804011      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804011      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804011      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804011      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804011      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804011      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804011      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804011      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804011      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804011      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804011      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804011      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804011      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804011      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804011      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804011      | 0001           |    91 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804010      | 0001           |    81 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804010      | 0001           |    81 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804010      | 0001           |    81 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804010      | 0001           |    81 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804010      | 0001           |    81 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804010      | 0001           |    81 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804010      | 0001           |    81 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804010      | 0001           |    81 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804010      | 0001           |    81 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804010      | 0001           |    81 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804010      | 0001           |    81 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804010      | 0001           |    81 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804010      | 0001           |    81 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804010      | 0001           |    81 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804010      | 0001           |    81 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804010      | 0001           |    81 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804010      | 0001           |    81 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804001      | 0002           |    80 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804001      | 0002           |    80 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804001      | 0002           |    80 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804001      | 0002           |    80 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804001      | 0002           |    80 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804001      | 0002           |    80 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804001      | 0002           |    80 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804001      | 0002           |    80 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804001      | 0002           |    80 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804001      | 0002           |    80 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804001      | 0002           |    80 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804001      | 0002           |    80 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804001      | 0002           |    80 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804001      | 0002           |    80 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804001      | 0002           |    80 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804001      | 0002           |    80 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804001      | 0002           |    80 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804002      | 0002           |    79 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804002      | 0002           |    79 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804002      | 0002           |    79 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804002      | 0002           |    79 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804002      | 0002           |    79 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804002      | 0002           |    79 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804002      | 0002           |    79 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804002      | 0002           |    79 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804002      | 0002           |    79 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804002      | 0002           |    79 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804002      | 0002           |    79 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804002      | 0002           |    79 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804002      | 0002           |    79 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804002      | 0002           |    79 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804002      | 0002           |    79 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804002      | 0002           |    79 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804002      | 0002           |    79 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804003      | 0002           |    78 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804003      | 0002           |    78 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804003      | 0002           |    78 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804003      | 0002           |    78 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804003      | 0002           |    78 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804003      | 0002           |    78 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804003      | 0002           |    78 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804003      | 0002           |    78 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804003      | 0002           |    78 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804003      | 0002           |    78 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804003      | 0002           |    78 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804003      | 0002           |    78 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804003      | 0002           |    78 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804003      | 0002           |    78 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804003      | 0002           |    78 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804003      | 0002           |    78 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804003      | 0002           |    78 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804004      | 0002           |    77 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804004      | 0002           |    77 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804004      | 0002           |    77 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804004      | 0002           |    77 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804004      | 0002           |    77 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804004      | 0002           |    77 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804004      | 0002           |    77 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804004      | 0002           |    77 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804004      | 0002           |    77 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804004      | 0002           |    77 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804004      | 0002           |    77 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804004      | 0002           |    77 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804004      | 0002           |    77 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804004      | 0002           |    77 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804004      | 0002           |    77 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804004      | 0002           |    77 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804004      | 0002           |    77 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804005      | 0002           |    76 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804005      | 0002           |    76 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804005      | 0002           |    76 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804005      | 0002           |    76 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804005      | 0002           |    76 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804005      | 0002           |    76 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804005      | 0002           |    76 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804005      | 0002           |    76 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804005      | 0002           |    76 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804005      | 0002           |    76 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804005      | 0002           |    76 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804005      | 0002           |    76 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804005      | 0002           |    76 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804005      | 0002           |    76 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804005      | 0002           |    76 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804005      | 0002           |    76 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804005      | 0002           |    76 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804006      | 0002           |    75 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804006      | 0002           |    75 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804006      | 0002           |    75 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804006      | 0002           |    75 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804006      | 0002           |    75 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804006      | 0002           |    75 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804006      | 0002           |    75 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804006      | 0002           |    75 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804006      | 0002           |    75 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804006      | 0002           |    75 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804006      | 0002           |    75 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804006      | 0002           |    75 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804006      | 0002           |    75 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804006      | 0002           |    75 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804006      | 0002           |    75 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804006      | 0002           |    75 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804006      | 0002           |    75 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804007      | 0002           |    74 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804007      | 0002           |    74 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804007      | 0002           |    74 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804007      | 0002           |    74 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804007      | 0002           |    74 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804007      | 0002           |    74 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804007      | 0002           |    74 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804007      | 0002           |    74 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804007      | 0002           |    74 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804007      | 0002           |    74 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804007      | 0002           |    74 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804007      | 0002           |    74 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804007      | 0002           |    74 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804007      | 0002           |    74 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804007      | 0002           |    74 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804007      | 0002           |    74 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804007      | 0002           |    74 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804008      | 0002           |    73 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804008      | 0002           |    73 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804008      | 0002           |    73 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804008      | 0002           |    73 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804008      | 0002           |    73 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804008      | 0002           |    73 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804008      | 0002           |    73 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804008      | 0002           |    73 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804008      | 0002           |    73 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804008      | 0002           |    73 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804008      | 0002           |    73 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804008      | 0002           |    73 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804008      | 0002           |    73 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804008      | 0002           |    73 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804008      | 0002           |    73 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804008      | 0002           |    73 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804008      | 0002           |    73 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804009      | 0002           |    72 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804009      | 0002           |    72 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804009      | 0002           |    72 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804009      | 0002           |    72 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804009      | 0002           |    72 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804009      | 0002           |    72 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804009      | 0002           |    72 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804009      | 0002           |    72 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804009      | 0002           |    72 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804009      | 0002           |    72 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804009      | 0002           |    72 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804009      | 0002           |    72 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804009      | 0002           |    72 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804009      | 0002           |    72 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804009      | 0002           |    72 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804009      | 0002           |    72 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804009      | 0002           |    72 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804010      | 0002           |    71 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804010      | 0002           |    71 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804010      | 0002           |    71 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804010      | 0002           |    71 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804010      | 0002           |    71 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804010      | 0002           |    71 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804010      | 0002           |    71 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804010      | 0002           |    71 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804010      | 0002           |    71 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804010      | 0002           |    71 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804010      | 0002           |    71 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804010      | 0002           |    71 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804010      | 0002           |    71 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804010      | 0002           |    71 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804010      | 0002           |    71 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804010      | 0002           |    71 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804010      | 0002           |    71 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804012      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804012      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804012      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804012      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804012      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804012      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804012      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804012      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804012      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804012      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804012      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804012      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804012      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804012      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804012      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804012      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804012      | 0001           |    91 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804013      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804013      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804013      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804013      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804013      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804013      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804013      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804013      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804013      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804013      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804013      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804013      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804013      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804013      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804013      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804013      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804013      | 0001           |    91 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804014      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804014      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804014      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804014      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804014      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804014      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804014      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804014      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804014      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804014      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804014      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804014      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804014      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804014      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804014      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804014      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804014      | 0001           |    91 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804015      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804015      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804015      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804015      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804015      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804015      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804015      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804015      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804015      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804015      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804015      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804015      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804015      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804015      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804015      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804015      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804015      | 0001           |    91 |
| 201804001 | Qiye     |   16 | 2002-01-01 | 201804016      | 0001           |    91 |
| 201804002 | JackLee  |   17 | 2001-01-02 | 201804016      | 0001           |    91 |
| 201804003 | Julia    |   18 | 2000-01-03 | 201804016      | 0001           |    91 |
| 201804004 | Stefer   |   19 | 2001-01-04 | 201804016      | 0001           |    91 |
| 201804005 | Steven   |   20 | 2000-01-05 | 201804016      | 0001           |    91 |
| 201804006 | Mark     |   21 | 1999-01-06 | 201804016      | 0001           |    91 |
| 201804007 | Stark    |   22 | 1999-01-07 | 201804016      | 0001           |    91 |
| 201804008 | Tonny    |   23 | 1999-01-08 | 201804016      | 0001           |    91 |
| 201804009 | Jarvis   |   24 | 1999-01-09 | 201804016      | 0001           |    91 |
| 201804010 | ZhangSan |   25 | 1999-01-10 | 201804016      | 0001           |    91 |
| 201804011 | lisi     |   23 | 1990-04-10 | 201804016      | 0001           |    91 |
| 201804012 | wanger   |   20 | 1991-01-10 | 201804016      | 0001           |    91 |
| 201804013 | mazi     |   21 | 1993-01-13 | 201804016      | 0001           |    91 |
| 201804014 | xiaoxing |   80 | 1995-01-22 | 201804016      | 0001           |    91 |
| 201804015 | hundan   |   36 | 1998-05-10 | 201804016      | 0001           |    91 |
| 201804016 | xiaowang |   30 | 1999-07-10 | 201804016      | 0001           |    91 |
| 201804017 | laowang  |   18 | 1997-08-10 | 201804016      | 0001           |    91 |
+-----------+----------+------+------------+----------------+----------------+-------+

posted on 2022-02-28 16:07 请你一定要记得我好吗阅读(17) 评论(0) 收藏举报

MySQL(二)

知识点一：mysql 查询方法

知识点二：子查询

1、内连接 ，拼接

2、外连接

1、内连接，拼接