介绍
涉及的表的结构
table department
用来表示部门信息的表，通过dno字段与其他表关联
mysql> select * from department;
+---------------------------+-----+--------+--------------+
| dname | dno | mgrssn | mgrstartdata |
+---------------------------+-----+--------+--------------+
| Economy Department | 000 | 09 | 2020-03-01 |
| Sales Department | 001 | 06 | 2017-06-01 |
| Human Resource Department | 010 | 12 | 2003-12-01 |
| Produce Department | 011 | 14 | 2009-05-01 |
| Research Department | 100 | 20 | 2026-09-01 |
+---------------------------+-----+--------+--------------+
5 rows in set (0.05
版权声明：本文为qq_40261735原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。