mysql的使用14
来源：互联网 发布：阿里云 centos 中文 编辑：程序博客网 时间：2024/06/01 08:07
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Nums |
| a |
| animals |
| charTest |
| customers |
| dept_manager |
| employees |
| g |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| x |
| yeartest |
| z |
+----------------+
21 rows in set (0.00 sec)
mysql> desc dept_manager;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| dept_no | varchar(10) | NO | | NULL | |
| emp_no | int(11) | NO | | NULL | |
| birth_date | date | YES | | NULL | |
| worktime | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> #cross join对两个表执行笛卡尔积，返回两个表中所有的组合，若左表有m行数据，右表有n行数据 则cross join将返回n*m行的表
mysql> select a.emp_no, b.emp_no from dept_manager as a
-> cross join
-> dept_manager as b;
+--------+--------+
| emp_no | emp_no |
+--------+--------+
| 110022 | 110022 |
| 110039 | 110022 |
| 110085 | 110022 |
| 110114 | 110022 |
| 110183 | 110022 |
| 110228 | 110022 |
| 110303 | 110022 |
| 110344 | 110022 |
| 110386 | 110022 |
| 110420 | 110022 |
| 110511 | 110022 |
| 110567 | 110022 |
| 110725 | 110022 |
| 110765 | 110022 |
| 110800 | 110022 |
| 110854 | 110022 |
| 111035 | 110022 |
| 111133 | 110022 |
| 111400 | 110022 |
| 111534 | 110022 |
| 111692 | 110022 |
| 111784 | 110022 |
| 111877 | 110022 |
| 111939 | 110022 |
| 110022 | 110039 |
| 110039 | 110039 |
| 110085 | 110039 |
| 110114 | 110039 |
| 110183 | 110039 |
| 110228 | 110039 |
| 110303 | 110039 |
| 110344 | 110039 |
| 110386 | 110039 |
| 110420 | 110039 |
| 110511 | 110039 |
| 110567 | 110039 |
| 110725 | 110039 |
| 110765 | 110039 |
| 110800 | 110039 |
| 110854 | 110039 |
| 111035 | 110039 |
| 111133 | 110039 |
| 111400 | 110039 |
| 111534 | 110039 |
| 111692 | 110039 |
| 111784 | 110039 |
| 111877 | 110039 |
| 111939 | 110039 |
| 110022 | 110085 |
| 110039 | 110085 |
| 110085 | 110085 |
| 110114 | 110085 |
| 110183 | 110085 |
| 110228 | 110085 |
| 110303 | 110085 |
| 110344 | 110085 |
| 110386 | 110085 |
| 110420 | 110085 |
| 110511 | 110085 |
| 110567 | 110085 |
| 110725 | 110085 |
| 110765 | 110085 |
| 110800 | 110085 |
| 110854 | 110085 |
| 111035 | 110085 |
| 111133 | 110085 |
| 111400 | 110085 |
| 111534 | 110085 |
| 111692 | 110085 |
| 111784 | 110085 |
| 111877 | 110085 |
| 111939 | 110085 |
| 110022 | 110114 |
| 110039 | 110114 |
| 110085 | 110114 |
| 110114 | 110114 |
| 110183 | 110114 |
| 110228 | 110114 |
| 110303 | 110114 |
| 110344 | 110114 |
| 110386 | 110114 |
| 110420 | 110114 |
| 110511 | 110114 |
| 110567 | 110114 |
| 110725 | 110114 |
| 110765 | 110114 |
| 110800 | 110114 |
| 110854 | 110114 |
| 111035 | 110114 |
| 111133 | 110114 |
| 111400 | 110114 |
| 111534 | 110114 |
| 111692 | 110114 |
| 111784 | 110114 |
| 111877 | 110114 |
| 111939 | 110114 |
| 110022 | 110183 |
| 110039 | 110183 |
| 110085 | 110183 |
| 110114 | 110183 |
| 110183 | 110183 |
| 110228 | 110183 |
| 110303 | 110183 |
| 110344 | 110183 |
| 110386 | 110183 |
| 110420 | 110183 |
| 110511 | 110183 |
| 110567 | 110183 |
| 110725 | 110183 |
| 110765 | 110183 |
| 110800 | 110183 |
| 110854 | 110183 |
| 111035 | 110183 |
| 111133 | 110183 |
| 111400 | 110183 |
| 111534 | 110183 |
| 111692 | 110183 |
| 111784 | 110183 |
| 111877 | 110183 |
| 111939 | 110183 |
| 110022 | 110228 |
| 110039 | 110228 |
| 110085 | 110228 |
| 110114 | 110228 |
| 110183 | 110228 |
| 110228 | 110228 |
| 110303 | 110228 |
| 110344 | 110228 |
| 110386 | 110228 |
| 110420 | 110228 |
| 110511 | 110228 |
| 110567 | 110228 |
| 110725 | 110228 |
| 110765 | 110228 |
| 110800 | 110228 |
| 110854 | 110228 |
| 111035 | 110228 |
| 111133 | 110228 |
| 111400 | 110228 |
| 111534 | 110228 |
| 111692 | 110228 |
| 111784 | 110228 |
| 111877 | 110228 |
| 111939 | 110228 |
| 110022 | 110303 |
| 110039 | 110303 |
| 110085 | 110303 |
| 110114 | 110303 |
| 110183 | 110303 |
| 110228 | 110303 |
| 110303 | 110303 |
| 110344 | 110303 |
| 110386 | 110303 |
| 110420 | 110303 |
| 110511 | 110303 |
| 110567 | 110303 |
| 110725 | 110303 |
| 110765 | 110303 |
| 110800 | 110303 |
| 110854 | 110303 |
| 111035 | 110303 |
| 111133 | 110303 |
| 111400 | 110303 |
| 111534 | 110303 |
| 111692 | 110303 |
| 111784 | 110303 |
| 111877 | 110303 |
| 111939 | 110303 |
| 110022 | 110344 |
| 110039 | 110344 |
| 110085 | 110344 |
| 110114 | 110344 |
| 110183 | 110344 |
| 110228 | 110344 |
| 110303 | 110344 |
| 110344 | 110344 |
| 110386 | 110344 |
| 110420 | 110344 |
| 110511 | 110344 |
| 110567 | 110344 |
| 110725 | 110344 |
| 110765 | 110344 |
| 110800 | 110344 |
| 110854 | 110344 |
| 111035 | 110344 |
| 111133 | 110344 |
| 111400 | 110344 |
| 111534 | 110344 |
| 111692 | 110344 |
| 111784 | 110344 |
| 111877 | 110344 |
| 111939 | 110344 |
| 110022 | 110386 |
| 110039 | 110386 |
| 110085 | 110386 |
| 110114 | 110386 |
| 110183 | 110386 |
| 110228 | 110386 |
| 110303 | 110386 |
| 110344 | 110386 |
| 110386 | 110386 |
| 110420 | 110386 |
| 110511 | 110386 |
| 110567 | 110386 |
| 110725 | 110386 |
| 110765 | 110386 |
| 110800 | 110386 |
| 110854 | 110386 |
| 111035 | 110386 |
| 111133 | 110386 |
| 111400 | 110386 |
| 111534 | 110386 |
| 111692 | 110386 |
| 111784 | 110386 |
| 111877 | 110386 |
| 111939 | 110386 |
| 110022 | 110420 |
| 110039 | 110420 |
| 110085 | 110420 |
| 110114 | 110420 |
| 110183 | 110420 |
| 110228 | 110420 |
| 110303 | 110420 |
| 110344 | 110420 |
| 110386 | 110420 |
| 110420 | 110420 |
| 110511 | 110420 |
| 110567 | 110420 |
| 110725 | 110420 |
| 110765 | 110420 |
| 110800 | 110420 |
| 110854 | 110420 |
| 111035 | 110420 |
| 111133 | 110420 |
| 111400 | 110420 |
| 111534 | 110420 |
| 111692 | 110420 |
| 111784 | 110420 |
| 111877 | 110420 |
| 111939 | 110420 |
| 110022 | 110511 |
| 110039 | 110511 |
| 110085 | 110511 |
| 110114 | 110511 |
| 110183 | 110511 |
| 110228 | 110511 |
| 110303 | 110511 |
| 110344 | 110511 |
| 110386 | 110511 |
| 110420 | 110511 |
| 110511 | 110511 |
| 110567 | 110511 |
| 110725 | 110511 |
| 110765 | 110511 |
| 110800 | 110511 |
| 110854 | 110511 |
| 111035 | 110511 |
| 111133 | 110511 |
| 111400 | 110511 |
| 111534 | 110511 |
| 111692 | 110511 |
| 111784 | 110511 |
| 111877 | 110511 |
| 111939 | 110511 |
| 110022 | 110567 |
| 110039 | 110567 |
| 110085 | 110567 |
| 110114 | 110567 |
| 110183 | 110567 |
| 110228 | 110567 |
| 110303 | 110567 |
| 110344 | 110567 |
| 110386 | 110567 |
| 110420 | 110567 |
| 110511 | 110567 |
| 110567 | 110567 |
| 110725 | 110567 |
| 110765 | 110567 |
| 110800 | 110567 |
| 110854 | 110567 |
| 111035 | 110567 |
| 111133 | 110567 |
| 111400 | 110567 |
| 111534 | 110567 |
| 111692 | 110567 |
| 111784 | 110567 |
| 111877 | 110567 |
| 111939 | 110567 |
| 110022 | 110725 |
| 110039 | 110725 |
| 110085 | 110725 |
| 110114 | 110725 |
| 110183 | 110725 |
| 110228 | 110725 |
| 110303 | 110725 |
| 110344 | 110725 |
| 110386 | 110725 |
| 110420 | 110725 |
| 110511 | 110725 |
| 110567 | 110725 |
| 110725 | 110725 |
| 110765 | 110725 |
| 110800 | 110725 |
| 110854 | 110725 |
| 111035 | 110725 |
| 111133 | 110725 |
| 111400 | 110725 |
| 111534 | 110725 |
| 111692 | 110725 |
| 111784 | 110725 |
| 111877 | 110725 |
| 111939 | 110725 |
| 110022 | 110765 |
| 110039 | 110765 |
| 110085 | 110765 |
| 110114 | 110765 |
| 110183 | 110765 |
| 110228 | 110765 |
| 110303 | 110765 |
| 110344 | 110765 |
| 110386 | 110765 |
| 110420 | 110765 |
| 110511 | 110765 |
| 110567 | 110765 |
| 110725 | 110765 |
| 110765 | 110765 |
| 110800 | 110765 |
| 110854 | 110765 |
| 111035 | 110765 |
| 111133 | 110765 |
| 111400 | 110765 |
| 111534 | 110765 |
| 111692 | 110765 |
| 111784 | 110765 |
| 111877 | 110765 |
| 111939 | 110765 |
| 110022 | 110800 |
| 110039 | 110800 |
| 110085 | 110800 |
| 110114 | 110800 |
| 110183 | 110800 |
| 110228 | 110800 |
| 110303 | 110800 |
| 110344 | 110800 |
| 110386 | 110800 |
| 110420 | 110800 |
| 110511 | 110800 |
| 110567 | 110800 |
| 110725 | 110800 |
| 110765 | 110800 |
| 110800 | 110800 |
| 110854 | 110800 |
| 111035 | 110800 |
| 111133 | 110800 |
| 111400 | 110800 |
| 111534 | 110800 |
| 111692 | 110800 |
| 111784 | 110800 |
| 111877 | 110800 |
| 111939 | 110800 |
| 110022 | 110854 |
| 110039 | 110854 |
| 110085 | 110854 |
| 110114 | 110854 |
| 110183 | 110854 |
| 110228 | 110854 |
| 110303 | 110854 |
| 110344 | 110854 |
| 110386 | 110854 |
| 110420 | 110854 |
| 110511 | 110854 |
| 110567 | 110854 |
| 110725 | 110854 |
| 110765 | 110854 |
| 110800 | 110854 |
| 110854 | 110854 |
| 111035 | 110854 |
| 111133 | 110854 |
| 111400 | 110854 |
| 111534 | 110854 |
| 111692 | 110854 |
| 111784 | 110854 |
| 111877 | 110854 |
| 111939 | 110854 |
| 110022 | 111035 |
| 110039 | 111035 |
| 110085 | 111035 |
| 110114 | 111035 |
| 110183 | 111035 |
| 110228 | 111035 |
| 110303 | 111035 |
| 110344 | 111035 |
| 110386 | 111035 |
| 110420 | 111035 |
| 110511 | 111035 |
| 110567 | 111035 |
| 110725 | 111035 |
| 110765 | 111035 |
| 110800 | 111035 |
| 110854 | 111035 |
| 111035 | 111035 |
| 111133 | 111035 |
| 111400 | 111035 |
| 111534 | 111035 |
| 111692 | 111035 |
| 111784 | 111035 |
| 111877 | 111035 |
| 111939 | 111035 |
| 110022 | 111133 |
| 110039 | 111133 |
| 110085 | 111133 |
| 110114 | 111133 |
| 110183 | 111133 |
| 110228 | 111133 |
| 110303 | 111133 |
| 110344 | 111133 |
| 110386 | 111133 |
| 110420 | 111133 |
| 110511 | 111133 |
| 110567 | 111133 |
| 110725 | 111133 |
| 110765 | 111133 |
| 110800 | 111133 |
| 110854 | 111133 |
| 111035 | 111133 |
| 111133 | 111133 |
| 111400 | 111133 |
| 111534 | 111133 |
| 111692 | 111133 |
| 111784 | 111133 |
| 111877 | 111133 |
| 111939 | 111133 |
| 110022 | 111400 |
| 110039 | 111400 |
| 110085 | 111400 |
| 110114 | 111400 |
| 110183 | 111400 |
| 110228 | 111400 |
| 110303 | 111400 |
| 110344 | 111400 |
| 110386 | 111400 |
| 110420 | 111400 |
| 110511 | 111400 |
| 110567 | 111400 |
| 110725 | 111400 |
| 110765 | 111400 |
| 110800 | 111400 |
| 110854 | 111400 |
| 111035 | 111400 |
| 111133 | 111400 |
| 111400 | 111400 |
| 111534 | 111400 |
| 111692 | 111400 |
| 111784 | 111400 |
| 111877 | 111400 |
| 111939 | 111400 |
| 110022 | 111534 |
| 110039 | 111534 |
| 110085 | 111534 |
| 110114 | 111534 |
| 110183 | 111534 |
| 110228 | 111534 |
| 110303 | 111534 |
| 110344 | 111534 |
| 110386 | 111534 |
| 110420 | 111534 |
| 110511 | 111534 |
| 110567 | 111534 |
| 110725 | 111534 |
| 110765 | 111534 |
| 110800 | 111534 |
| 110854 | 111534 |
| 111035 | 111534 |
| 111133 | 111534 |
| 111400 | 111534 |
| 111534 | 111534 |
| 111692 | 111534 |
| 111784 | 111534 |
| 111877 | 111534 |
| 111939 | 111534 |
| 110022 | 111692 |
| 110039 | 111692 |
| 110085 | 111692 |
| 110114 | 111692 |
| 110183 | 111692 |
| 110228 | 111692 |
| 110303 | 111692 |
| 110344 | 111692 |
| 110386 | 111692 |
| 110420 | 111692 |
| 110511 | 111692 |
| 110567 | 111692 |
| 110725 | 111692 |
| 110765 | 111692 |
| 110800 | 111692 |
| 110854 | 111692 |
| 111035 | 111692 |
| 111133 | 111692 |
| 111400 | 111692 |
| 111534 | 111692 |
| 111692 | 111692 |
| 111784 | 111692 |
| 111877 | 111692 |
| 111939 | 111692 |
| 110022 | 111784 |
| 110039 | 111784 |
| 110085 | 111784 |
| 110114 | 111784 |
| 110183 | 111784 |
| 110228 | 111784 |
| 110303 | 111784 |
| 110344 | 111784 |
| 110386 | 111784 |
| 110420 | 111784 |
| 110511 | 111784 |
| 110567 | 111784 |
| 110725 | 111784 |
| 110765 | 111784 |
| 110800 | 111784 |
| 110854 | 111784 |
| 111035 | 111784 |
| 111133 | 111784 |
| 111400 | 111784 |
| 111534 | 111784 |
| 111692 | 111784 |
| 111784 | 111784 |
| 111877 | 111784 |
| 111939 | 111784 |
| 110022 | 111877 |
| 110039 | 111877 |
| 110085 | 111877 |
| 110114 | 111877 |
| 110183 | 111877 |
| 110228 | 111877 |
| 110303 | 111877 |
| 110344 | 111877 |
| 110386 | 111877 |
| 110420 | 111877 |
| 110511 | 111877 |
| 110567 | 111877 |
| 110725 | 111877 |
| 110765 | 111877 |
| 110800 | 111877 |
| 110854 | 111877 |
| 111035 | 111877 |
| 111133 | 111877 |
| 111400 | 111877 |
| 111534 | 111877 |
| 111692 | 111877 |
| 111784 | 111877 |
| 111877 | 111877 |
| 111939 | 111877 |
| 110022 | 111939 |
| 110039 | 111939 |
| 110085 | 111939 |
| 110114 | 111939 |
| 110183 | 111939 |
| 110228 | 111939 |
| 110303 | 111939 |
| 110344 | 111939 |
| 110386 | 111939 |
| 110420 | 111939 |
| 110511 | 111939 |
| 110567 | 111939 |
| 110725 | 111939 |
| 110765 | 111939 |
| 110800 | 111939 |
| 110854 | 111939 |
| 111035 | 111939 |
| 111133 | 111939 |
| 111400 | 111939 |
| 111534 | 111939 |
| 111692 | 111939 |
| 111784 | 111939 |
| 111877 | 111939 |
| 111939 | 111939 |
+--------+--------+
576 rows in set (0.00 sec)
mysql> #由于dept_manager是自己与自己进行链接操作 所以要使用别名
mysql> select * from dept_manager as a,dept_manager as b;
+---------+--------+------------+------------+---------+--------+------------+------------+
| dept_no | emp_no | birth_date | worktime | dept_no | emp_no | birth_date | worktime |
+---------+--------+------------+------------+---------+--------+------------+------------+
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d004 | 110420 | 1996-08-30 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d005 | 110511 | 1985-01-01 | 1992-04-25 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d005 | 110567 | 1992-04-25 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d006 | 110725 | 1985-01-01 | 1989-05-06 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d006 | 110765 | 1989-05-06 | 1991-09-12 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d006 | 110800 | 1991-09-12 | 1994-06-28 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d006 | 110854 | 1994-06-28 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d007 | 111035 | 1985-01-01 | 1991-03-07 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d007 | 111133 | 1991-03-07 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d008 | 111400 | 1985-01-01 | 1991-04-08 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d008 | 111534 | 1991-04-08 | 9999-01-01 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d009 | 111692 | 1985-01-01 | 1988-10-17 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d009 | 111784 | 1988-10-17 | 1992-09-08 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d009 | 111877 | 1992-09-08 | 1996-01-03 |
| d001 | 110022 | 1985-01-01 | 1991-10-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d005 | 110511 | 1985-01-01 | 1992-04-25 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d005 | 110567 | 1992-04-25 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d006 | 110725 | 1985-01-01 | 1989-05-06 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d006 | 110765 | 1989-05-06 | 1991-09-12 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d006 | 110800 | 1991-09-12 | 1994-06-28 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d006 | 110854 | 1994-06-28 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d007 | 111035 | 1985-01-01 | 1991-03-07 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d007 | 111133 | 1991-03-07 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d008 | 111400 | 1985-01-01 | 1991-04-08 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d008 | 111534 | 1991-04-08 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d009 | 111692 | 1985-01-01 | 1988-10-17 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d009 | 111784 | 1988-10-17 | 1992-09-08 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d009 | 111877 | 1992-09-08 | 1996-01-03 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
| d009 | 111939 | 1996-01-03 | 9999-01-01 | d009 | 111939 | 1996-01-03 | 9999-01-01 |
+---------+--------+------------+------------+---------+--------+------------+------------+
576 rows in set (0.01 sec)
mysql> #给部门表得到行号
mysql> select emp_no, dept_no , (select count(*) from dept_manager t2
-> where t1.emp_no <= t2.emp_no) as row_num
-> from dept_manager as t1;
+--------+---------+---------+
| emp_no | dept_no | row_num |
+--------+---------+---------+
| 110022 | d001 | 24 |
| 110039 | d001 | 23 |
| 110085 | d002 | 22 |
| 110114 | d002 | 21 |
| 110183 | d003 | 20 |
| 110228 | d003 | 19 |
| 110303 | d004 | 18 |
| 110344 | d004 | 17 |
| 110386 | d004 | 16 |
| 110420 | d004 | 15 |
| 110511 | d005 | 14 |
| 110567 | d005 | 13 |
| 110725 | d006 | 12 |
| 110765 | d006 | 11 |
| 110800 | d006 | 10 |
| 110854 | d006 | 9 |
| 111035 | d007 | 8 |
| 111133 | d007 | 7 |
| 111400 | d008 | 6 |
| 111534 | d008 | 5 |
| 111692 | d009 | 4 |
| 111784 | d009 | 3 |
| 111877 | d009 | 2 |
| 111939 | d009 | 1 |
+--------+---------+---------+
24 rows in set (0.00 sec)
mysql> select emp_no, dept_no , (select count(*) from dept_manager t2 where t2.emp_no <= t1.emp_no) as row_num from dept_manager as t1;
+--------+---------+---------+
| emp_no | dept_no | row_num |
+--------+---------+---------+
| 110022 | d001 | 1 |
| 110039 | d001 | 2 |
| 110085 | d002 | 3 |
| 110114 | d002 | 4 |
| 110183 | d003 | 5 |
| 110228 | d003 | 6 |
| 110303 | d004 | 7 |
| 110344 | d004 | 8 |
| 110386 | d004 | 9 |
| 110420 | d004 | 10 |
| 110511 | d005 | 11 |
| 110567 | d005 | 12 |
| 110725 | d006 | 13 |
| 110765 | d006 | 14 |
| 110800 | d006 | 15 |
| 110854 | d006 | 16 |
| 111035 | d007 | 17 |
| 111133 | d007 | 18 |
| 111400 | d008 | 19 |
| 111534 | d008 | 20 |
| 111692 | d009 | 21 |
| 111784 | d009 | 22 |
| 111877 | d009 | 23 |
| 111939 | d009 | 24 |
+--------+---------+---------+
24 rows in set (0.00 sec)
mysql> select emp_no, dept_no, @a:=@a+1 as row_num
-> from dept_manager, (select @a:=0) t;
+--------+---------+---------+
| emp_no | dept_no | row_num |
+--------+---------+---------+
| 110022 | d001 | 1 |
| 110039 | d001 | 2 |
| 110085 | d002 | 3 |
| 110114 | d002 | 4 |
| 110183 | d003 | 5 |
| 110228 | d003 | 6 |
| 110303 | d004 | 7 |
| 110344 | d004 | 8 |
| 110386 | d004 | 9 |
| 110420 | d004 | 10 |
| 110511 | d005 | 11 |
| 110567 | d005 | 12 |
| 110725 | d006 | 13 |
| 110765 | d006 | 14 |
| 110800 | d006 | 15 |
| 110854 | d006 | 16 |
| 111035 | d007 | 17 |
| 111133 | d007 | 18 |
| 111400 | d008 | 19 |
| 111534 | d008 | 20 |
| 111692 | d009 | 21 |
| 111784 | d009 | 22 |
| 111877 | d009 | 23 |
| 111939 | d009 | 24 |
+--------+---------+---------+
24 rows in set (0.00 sec)
mysql> #在海量数据的查询时 会更加快捷
mysql>
mysql> #inner join 使用on进行过滤 不添加外部行，这个和cross join有区别
mysql> desc emp_manager;
ERROR 1146 (42S02): Table 'test.emp_manager' doesn't exist
mysql> desc dept_manager;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| dept_no | varchar(10) | NO | | NULL | |
| emp_no | int(11) | NO | | NULL | |
| birth_date | date | YES | | NULL | |
| worktime | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Nums |
| a |
| animals |
| charTest |
| customers |
| dept_manager |
| employees |
| g |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| x |
| yeartest |
| z |
+----------------+
21 rows in set (0.00 sec)
mysql> desc new_emp;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | int(10) | NO | PRI | NULL | |
| birth_date | date | YES | | NULL | |
| first_name | varchar(15) | NO | | | |
| last_name | varchar(15) | NO | | | |
| sex | char(1) | YES | | NULL | |
| worktime | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> select * from new_emp limit 10;
+-------+------------+------------+-----------+------+------------+
| id | birth_date | first_name | last_name | sex | worktime |
+-------+------------+------------+-----------+------+------------+
| 10001 | 1953-09-02 | Georgi | Facello | M | 1986-06-26 |
| 10002 | 1964-06-02 | Bezalel | Simmel | F | 1985-11-21 |
| 10003 | 1959-12-03 | Parto | Bamford | M | 1986-08-28 |
| 10004 | 1954-05-01 | Chirstian | Koblick | M | 1986-12-01 |
| 10005 | 1955-01-21 | Kyoichi | Maliniak | M | 1989-09-12 |
| 10006 | 1953-04-20 | Anneke | Preusig | F | 1989-06-02 |
| 10007 | 1957-05-23 | Tzvetan | Zielinski | F | 1989-02-10 |
| 10008 | 1958-02-19 | Saniya | Kalloufi | M | 1994-09-15 |
| 10009 | 1952-04-19 | Sumant | Peac | F | 1985-02-18 |
| 10010 | 1963-06-01 | Duangkaew | Piveteau | F | 1989-08-24 |
+-------+------------+------------+-----------+------+------------+
10 rows in set (0.00 sec)
mysql> select a.id, first_name, last_name from employees a,dept_manager b
-> where a.id = b.emp_no and dept_no = 'd001';
+--------+------------+------------+
| id | first_name | last_name |
+--------+------------+------------+
| 110022 | Margareta | Markovitch |
| 110039 | Vishwani | Minakawa |
+--------+------------+------------+
2 rows in set (0.01 sec)
mysql> select a.id, first_name, last_name from employees a,dept_manager b where dept_no = 'd001';
+---------+----------------+-----------------+
| id | first_name | last_name |
+---------+----------------+-----------------+
| 10001 | Georgi | Facello |
| 10001 | Georgi | Facello |
| 10002 | Bezalel | Simmel |
| 10002 | Bezalel | Simmel |
| 35329 | Goetz | Lukaszewicz |
| 35329 | Goetz | Lukaszewicz |
| 35330 | Leni | Koyama |
| 35330 | Leni | Koyama |
| 35331 | Basim | Ghazalie |
| 35331 | Basim | Ghazalie |
| 35332 | Xiaoqiu | Assaf |
| 35332 | Xiaoqiu | Assaf |
| 35333 | Hideyuki | Veldwijk |
| 35333 | Hideyuki | Veldwijk |
| 35334 | Manton | Vidal |
| 35334 | Manton | Vidal |
| 35335 | Huiqun | Morrow |
| 41006 | Morris | Merle |
| 41006 | Morris | Merle |
| 41007 | Herb | Chartres |
| 41007 | Herb | Chartres |
| 41008 | Heather | Paciorek |
| 41008 | Heather | Paciorek |
| 41009 | Hairong | Radhakrishnan |
| 41009 | Hairong | Radhakrishnan |
| 41010 | Kristian | Sudbeck |
| 41010 | Kristian | Sudbeck |
| 41011 | Geoff | Yurov |
| 41011 | Geoff | Yurov |
| 41012 | Alejandro | Braunmuhl |
| 41012 | Alejandro | Braunmuhl |
| 41013 | Shirish | Asrin |
| 41013 | Shirish | Asrin |
| 41014 | Sachin | Atrawala |
| 41014 | Sachin | Atrawala |
| 41015 | Ronnie | Millington |
| 41015 | Ronnie | Millington |
| 41016 | Samphel | Jayawardene |
| 41016 | Samphel | Jayawardene |
| 41017 | Shigenori | Litzler |
| 41017 | Shigenori | Litzler |
| 41018 | Dzung | Kadhim |
| 41018 | Dzung | Kadhim |
| 41019 | Hugo | Birge |
| 41019 | Hugo | Birge |
| 41020 | Uma | Chimia |
| 41020 | Uma | Chimia |
| 41021 | Narain | Uhrig |
| 41021 | Narain | Uhrig |Ctrl-C -- sending "KILL QUERY 37" to server ...
Ctrl-C -- query aborted.
+---------+----------------+-----------------+
600050 rows in set (0.42 sec)
#\BF\BF\BF\BF\BF\BF\BF\BF\BF\BF
mysql> #太多了
mysql>
mysql> #如果没有on的话 解释器会将inner join 解释为 cross join
mysql> select a.id, first_name, last_name from employees a,dept_manager b on a.id = b.emp_no and dept_no = 'd001';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on a.id = b.emp_no and dept_no = 'd001'' at line 1
mysql>
mysql>
mysql> select a.id, first_name, last_name from employees a join dept_manager b on a.id = b.emp_no and dept_no = 'd001';
ERROR 1317 (70100): Query execution was interrupted
mysql>
mysql> select a.id, first_name, last_name from employees a inner join dept_manager b on a.id = b.emp_no where dept_no = 'd001';
+--------+------------+------------+
| id | first_name | last_name |
+--------+------------+------------+
| 110022 | Margareta | Markovitch |
| 110039 | Vishwani | Minakawa |
+--------+------------+------------+
2 rows in set (0.00 sec)
mysql> #以上是inner join.... on的用法
mysql>
mysql> #outer join
mysql> #查询的三个步骤
mysql> #1.产生地卡尔积 2.应用on过滤器 和 3.添加外部行
mysql> #对于保留表中的行数据 如果是未找到匹配数据而被添加的记录 其值用NULL进行填充
mysql>
mysql> 是哦尾
->
-> ；
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '是哦尾
；' at line 1
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Nums |
| a |
| animals |
| charTest |
| customers |
| dept_manager |
| employees |
| g |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| x |
| yeartest |
| z |
+----------------+
21 rows in set (0.00 sec)
mysql> desc customers;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| customer_id | varchar(10) | NO | PRI | NULL | |
| city | varchar(10) | NO | | NULL | |
+-------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc orders;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| order_id | int(11) | NO | PRI | NULL | auto_increment |
| customer_id | varchar(10) | YES | | NULL | |
+-------------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> select c.customer_id, o.order_id from customers as c
-> left join orsers as o
-> on c.customer_id = o.customer_id;
ERROR 1146 (42S02): Table 'test.orsers' doesn't exist
mysql> select c.customer_id, o.order_id from customers as c left join on orders as o on c.customer_id = o.customer_id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on orders as o on c.customer_id = o.customer_id' at line 1
mysql>
mysql>
mysql> select c.customer_id, o.order_id from customers as c left join on orders as o on c.customer_id = o.customer_id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on orders as o on c.customer_id = o.customer_id' at line 1
mysql>
mysql> select c.customer_id, o.order_id from customers as c left outer join orders as o on c.customer_id = o.customer_id;
+-------------+----------+
| customer_id | order_id |
+-------------+----------+
| 9You | 3 |
| 9You | 4 |
| 9You | 5 |
| baidu | NULL |
| Jack1 | 1 |
| Jack1 | 2 |
| TX | 6 |
+-------------+----------+
7 rows in set (0.00 sec)
mysql> #刚才join on链接在一起了
mysql> select c.customer_id, o.order_id from customers as c left outer join orders as o on c.customer_id = o.customer_id where o.order_id is NULL;
+-------------+----------+
| customer_id | order_id |
+-------------+----------+
| baidu | NULL |
+-------------+----------+
1 row in set (0.00 sec)
mysql> #outer join中on是不可省去的
mysql>
mysql> #利用outer
mysql> #join 来解决最小值缺失问题
mysql>
mysql> create table mintable (
-> a int,
-> b varchar(3),
-> primary key(a)) engine = innodb;
Query OK, 0 rows affected (0.09 sec)
mysql> insert into mintable values(1,'z'),(2,'p'),(3,'g'),(5,'e'),(6,'f'),(7,'b'),(9,'v');
Query OK, 7 rows affected (0.05 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> select * from mintables;
ERROR 1146 (42S02): Table 'test.mintables' doesn't exist
mysql> select * from mintable;
+---+------+
| a | b |
+---+------+
| 1 | z |
| 2 | p |
| 3 | g |
| 5 | e |
| 6 | f |
| 7 | b |
| 9 | v |
+---+------+
7 rows in set (0.00 sec)
mysql> select min(a.a+1) from t x left outer join t y
-> on x.a + 1 = y.a
-> where y.a is NULL;
ERROR 1054 (42S22): Unknown column 'a.a' in 'field list'
mysql> select min(x.a+1) from t x left outer join t y on x.a + 1 = y.a where y.a is NULL;
+------------+
| min(x.a+1) |
+------------+
| 1 |
+------------+
1 row in set, 3 warnings (0.00 sec)
mysql> select min(y.a+1) from t x left outer join t y on x.a + 1 = y.a where y.a is NULL;
+------------+
| min(y.a+1) |
+------------+
| NULL |
+------------+
1 row in set, 2 warnings (0.00 sec)
mysql> #有问题 应该取4啊
mysql> select min(y.a+1) from t x left outer join t y on x.a + 1 = y.a;
+------------+
| min(y.a+1) |
+------------+
| NULL |
+------------+
1 row in set, 2 warnings (0.00 sec)
mysql> select x.a+1 from t x left outer join t y on x.a + 1 = y.a;
+-------+
| x.a+1 |
+-------+
| 1 |
+-------+
1 row in set, 3 warnings (0.01 sec)
mysql> select * from t x left outer join t y on x.a + 1 = y.a;
+------+------+
| a | a |
+------+------+
| \E6 | NULL |
+------+------+
1 row in set, 2 warnings (0.00 sec)
mysql> #有点想不通 明明取出了x.a+1后面的 当遇到3时，后面的y.a=NULL 此时x.a+1用该为4啊.........
mysql>
mysql>
mysql> #nature join
mysql> select a.id, first_name, last_name from employees a
-> natural join dept_manager b;
Empty set (0.93 sec)
mysql> #知道了 由于id 和 dept_manager中的emp_no不同 无法正确识别
mysql>
mysql> #self join是统一个表的两个示例之间的join操作，前面的最小缺失问日使用的就是self join，只是没有显式的进行归类
mysql>
mysql> create table emp(
-> emp_no int primary key,
-> mgr_no int,
-> emp_name varchar(20));
Query OK, 0 rows affected (0.09 sec)
mysql> insert into emp values(1,NULL,'David');
Query OK, 1 row affected (0.02 sec)
mysql> insert into emp values(4,1,'Jim');
Query OK, 1 row affected (0.03 sec)
mysql> insert into emp values(3,1,'Tommy');
Query OK, 1 row affected (0.03 sec)
mysql> insert into emp values(2,3,'Mariah');
Query OK, 1 row affected (0.03 sec)
mysql> insert into emp values(5,3,'Selina');
Query OK, 1 row affected (0.04 sec)
mysql> insert into emp values(6,4,'John');
Query OK, 1 row affected (0.03 sec)
mysql> insert into emp values(8,3,'Monty');
Query OK, 1 row affected (0.04 sec)
mysql> #员工-经理问题 就是得到每位员工的经理信息
mysql>
mysql> select a.emp_name as employee, b.emp_name as manager
-> from emp a
-> left join emp b
-> on a.mgr_no = b.emp_no;
+----------+---------+
| employee | manager |
+----------+---------+
| David | NULL |
| Mariah | Tommy |
| Tommy | David |
| Jim | David |
| Selina | Tommy |
| John | Jim |
| Monty | Tommy |
+----------+---------+
7 rows in set (0.00 sec)
mysql> #nonequi join
mysql> #前面介绍的都是等值连接 nonequi join包含等值之外的链接
mysql> select a.emp_no, b.emp_no from dept_manager a
-> inner join dept_manager b
-> on a.emp_no < b.emp_no;
+--------+--------+
| emp_no | emp_no |
+--------+--------+
| 110022 | 110039 |
| 110022 | 110085 |
| 110039 | 110085 |
| 110022 | 110114 |
| 110039 | 110114 |
| 110085 | 110114 |
| 110022 | 110183 |
| 110039 | 110183 |
| 110085 | 110183 |
| 110114 | 110183 |
| 110022 | 110228 |
| 110039 | 110228 |
| 110085 | 110228 |
| 110114 | 110228 |
| 110183 | 110228 |
| 110022 | 110303 |
| 110039 | 110303 |
| 110085 | 110303 |
| 110114 | 110303 |
| 110183 | 110303 |
| 110228 | 110303 |
| 110022 | 110344 |
| 110039 | 110344 |
| 110085 | 110344 |
| 110114 | 110344 |
| 110183 | 110344 |
| 110228 | 110344 |
| 110303 | 110344 |
| 110022 | 110386 |
| 110039 | 110386 |
| 110085 | 110386 |
| 110114 | 110386 |
| 110183 | 110386 |
| 110228 | 110386 |
| 110303 | 110386 |
| 110344 | 110386 |
| 110022 | 110420 |
| 110039 | 110420 |
| 110085 | 110420 |
| 110114 | 110420 |
| 110183 | 110420 |
| 110228 | 110420 |
| 110303 | 110420 |
| 110344 | 110420 |
| 110386 | 110420 |
| 110022 | 110511 |
| 110039 | 110511 |
| 110085 | 110511 |
| 110114 | 110511 |
| 110183 | 110511 |
| 110228 | 110511 |
| 110303 | 110511 |
| 110344 | 110511 |
| 110386 | 110511 |
| 110420 | 110511 |
| 110022 | 110567 |
| 110039 | 110567 |
| 110085 | 110567 |
| 110114 | 110567 |
| 110183 | 110567 |
| 110228 | 110567 |
| 110303 | 110567 |
| 110344 | 110567 |
| 110386 | 110567 |
| 110420 | 110567 |
| 110511 | 110567 |
| 110022 | 110725 |
| 110039 | 110725 |
| 110085 | 110725 |
| 110114 | 110725 |
| 110183 | 110725 |
| 110228 | 110725 |
| 110303 | 110725 |
| 110344 | 110725 |
| 110386 | 110725 |
| 110420 | 110725 |
| 110511 | 110725 |
| 110567 | 110725 |
| 110022 | 110765 |
| 110039 | 110765 |
| 110085 | 110765 |
| 110114 | 110765 |
| 110183 | 110765 |
| 110228 | 110765 |
| 110303 | 110765 |
| 110344 | 110765 |
| 110386 | 110765 |
| 110420 | 110765 |
| 110511 | 110765 |
| 110567 | 110765 |
| 110725 | 110765 |
| 110022 | 110800 |
| 110039 | 110800 |
| 110085 | 110800 |
| 110114 | 110800 |
| 110183 | 110800 |
| 110228 | 110800 |
| 110303 | 110800 |
| 110344 | 110800 |
| 110386 | 110800 |
| 110420 | 110800 |
| 110511 | 110800 |
| 110567 | 110800 |
| 110725 | 110800 |
| 110765 | 110800 |
| 110022 | 110854 |
| 110039 | 110854 |
| 110085 | 110854 |
| 110114 | 110854 |
| 110183 | 110854 |
| 110228 | 110854 |
| 110303 | 110854 |
| 110344 | 110854 |
| 110386 | 110854 |
| 110420 | 110854 |
| 110511 | 110854 |
| 110567 | 110854 |
| 110725 | 110854 |
| 110765 | 110854 |
| 110800 | 110854 |
| 110022 | 111035 |
| 110039 | 111035 |
| 110085 | 111035 |
| 110114 | 111035 |
| 110183 | 111035 |
| 110228 | 111035 |
| 110303 | 111035 |
| 110344 | 111035 |
| 110386 | 111035 |
| 110420 | 111035 |
| 110511 | 111035 |
| 110567 | 111035 |
| 110725 | 111035 |
| 110765 | 111035 |
| 110800 | 111035 |
| 110854 | 111035 |
| 110022 | 111133 |
| 110039 | 111133 |
| 110085 | 111133 |
| 110114 | 111133 |
| 110183 | 111133 |
| 110228 | 111133 |
| 110303 | 111133 |
| 110344 | 111133 |
| 110386 | 111133 |
| 110420 | 111133 |
| 110511 | 111133 |
| 110567 | 111133 |
| 110725 | 111133 |
| 110765 | 111133 |
| 110800 | 111133 |
| 110854 | 111133 |
| 111035 | 111133 |
| 110022 | 111400 |
| 110039 | 111400 |
| 110085 | 111400 |
| 110114 | 111400 |
| 110183 | 111400 |
| 110228 | 111400 |
| 110303 | 111400 |
| 110344 | 111400 |
| 110386 | 111400 |
| 110420 | 111400 |
| 110511 | 111400 |
| 110567 | 111400 |
| 110725 | 111400 |
| 110765 | 111400 |
| 110800 | 111400 |
| 110854 | 111400 |
| 111035 | 111400 |
| 111133 | 111400 |
| 110022 | 111534 |
| 110039 | 111534 |
| 110085 | 111534 |
| 110114 | 111534 |
| 110183 | 111534 |
| 110228 | 111534 |
| 110303 | 111534 |
| 110344 | 111534 |
| 110386 | 111534 |
| 110420 | 111534 |
| 110511 | 111534 |
| 110567 | 111534 |
| 110725 | 111534 |
| 110765 | 111534 |
| 110800 | 111534 |
| 110854 | 111534 |
| 111035 | 111534 |
| 111133 | 111534 |
| 111400 | 111534 |
| 110022 | 111692 |
| 110039 | 111692 |
| 110085 | 111692 |
| 110114 | 111692 |
| 110183 | 111692 |
| 110228 | 111692 |
| 110303 | 111692 |
| 110344 | 111692 |
| 110386 | 111692 |
| 110420 | 111692 |
| 110511 | 111692 |
| 110567 | 111692 |
| 110725 | 111692 |
| 110765 | 111692 |
| 110800 | 111692 |
| 110854 | 111692 |
| 111035 | 111692 |
| 111133 | 111692 |
| 111400 | 111692 |
| 111534 | 111692 |
| 110022 | 111784 |
| 110039 | 111784 |
| 110085 | 111784 |
| 110114 | 111784 |
| 110183 | 111784 |
| 110228 | 111784 |
| 110303 | 111784 |
| 110344 | 111784 |
| 110386 | 111784 |
| 110420 | 111784 |
| 110511 | 111784 |
| 110567 | 111784 |
| 110725 | 111784 |
| 110765 | 111784 |
| 110800 | 111784 |
| 110854 | 111784 |
| 111035 | 111784 |
| 111133 | 111784 |
| 111400 | 111784 |
| 111534 | 111784 |
| 111692 | 111784 |
| 110022 | 111877 |
| 110039 | 111877 |
| 110085 | 111877 |
| 110114 | 111877 |
| 110183 | 111877 |
| 110228 | 111877 |
| 110303 | 111877 |
| 110344 | 111877 |
| 110386 | 111877 |
| 110420 | 111877 |
| 110511 | 111877 |
| 110567 | 111877 |
| 110725 | 111877 |
| 110765 | 111877 |
| 110800 | 111877 |
| 110854 | 111877 |
| 111035 | 111877 |
| 111133 | 111877 |
| 111400 | 111877 |
| 111534 | 111877 |
| 111692 | 111877 |
| 111784 | 111877 |
| 110022 | 111939 |
| 110039 | 111939 |
| 110085 | 111939 |
| 110114 | 111939 |
| 110183 | 111939 |
| 110228 | 111939 |
| 110303 | 111939 |
| 110344 | 111939 |
| 110386 | 111939 |
| 110420 | 111939 |
| 110511 | 111939 |
| 110567 | 111939 |
| 110725 | 111939 |
| 110765 | 111939 |
| 110800 | 111939 |
| 110854 | 111939 |
| 111035 | 111939 |
| 111133 | 111939 |
| 111400 | 111939 |
| 111534 | 111939 |
| 111692 | 111939 |
| 111784 | 111939 |
| 111877 | 111939 |
+--------+--------+
276 rows in set (0.00 sec)
mysql> #查询大于前面的
mysql>
mysql> exit
- mysql的使用14
- MYSQL的基础使用
- mysql的SQL_CALC_FOUND_ROWS 使用
- MySQL触发器的使用
- MySQL的使用
- MySQL触发器的使用
- mysql的SQL_CALC_FOUND_ROWS 使用
- MYSQL的初级使用
- mysql 游标的使用
- mysql的使用问题
- mysql 游标的使用
- 使用MySQL的LAST_INSERT_ID
- MySQL触发器的使用
- 使用MySQL的LAST_INSERT_ID
- Mysql 触发器的使用
- MySQL触发器的使用
- MYSQL索引的使用
- 使用MySQL的LAST_INSERT_ID
- Html（11）CSS的布局模型
- 74LS138真值表相关
- Tomcat7查看JVM内存使用情况
- POJ 1426 Find The Multiple（BFS 水~）
- ubuntu 安装 flash
- mysql的使用14
- 技术演示----分析听众个人特点
- ZOJ Problem Set - 2812 Quicksum
- 邻接表 小讲
- struts批量上传文件
- 3-1 Point类的构造函数
- stm32的SPI设置步骤，SPI配置参数
- InvSqrt
- 请假模块申请算法(3)
