书中教学案例(例题)使用的数据库为empMIS(员工管理信息系统)- 创建员工管理信息系统数据库(empMIS)create database empMIS default character set utf8;- 打开empMIS数据库use empMIS;- 创建部门表(departments)列名类型描述dnoint部门编号(主键)dnamevarchar部门名称(唯一约束)dlocvarchar部门所在城市create table departments( dno int primary key, dname varchar(30) unique, dloc varchar(50) );-显示departments的表结构desc departments;- 向部门表插入数据 insert into departments(dno,dname,dloc) values(1,销售部,长春 ),(2,财务部,沈阳 ),(3,开发部,哈尔滨 ),(4,人事部,北京 ),(5,董事会,北京 ),(6,后勤部,长春 );select * from departments;- 创建员工表(employees)列名类型描述enoint员工编号(主键)enamevarchar员工姓名ehiredatedate雇佣日期ejobvarchar员工职位emgrint员工领导的编号，领导也是员工esaldecimal员工工资ebonusdecimal员工奖金deptnoint部门编号(外键) create table employees ( eno int primary key, ename varchar(20), ehiredate date, ejob varchar(16), emgr int, esal decimal, ebonus decimal, deptno int references departments(dno) );-显示employees的表结构desc employees;- 向员工表插入数据insert into employees(eno,ename,ehiredate,ejob,emgr,esal,ebonus,deptno)values (1001,郑莹,1999-1-1,销售部长,5001,10000,1500,1),(1002,梁睿,1999-7-7,经理,1001,6000,1000,1),(1003,赵思,1999-7-7,销售员,1002,1500,2000,1),(1004,高文,2000-1-1,销售员,1002,1500,2000,1),(1005,杨幂,2005-1-1,销售员,1002,1500,2000,1),(2001,张松,1998-10-3,财务部长,5001,8000,1000,2),(2002,孙威,1998-10-20,会计,2001,4000,null,2),(2003,王东,1998-10-20,出纳,2001,3000,null,2),(3001,胡歌,1999-6-1,开发部长,5001,12000,3000,3),(3002,邓超,1999-12-6,项目经理,3001,7000,1000,3),(3003,陈赫,2000-1-1,程序员,3001,6000,1000,3),(3004,鹿晗,2000-1-1,程序员,3001,6500,2000,3),(3005,杨洋,2003-9-1,程序员,3001,4000,1000,3),(4001,李丽,1999-1-1,人事部长,5001,8000,1000,4),(4002,邵强,1999-2-10,办事员,4001,4000,null,4),(4003,吴坤,2007-10-1,办事员,4001,3500,null,4),(4004,马萍,2009-5-17,办事员,4001,3000,null,4),(5001,姜红,1998-1-1,董事长,null,20000,null,5),(1,栾凯,2010-1-1,null,null,1500,null,null),(2,程程,2010-1-1,null,null,1500,null,null);select * from employees;附录：empMIS数据库、stuMIS数据库中的表及数据*- 创建员工管理信息系统数据库(empMIS)create database empMIS default character set utf8;- 打开empMIS数据库use empMIS;*- 创建部门表(departments)create table departments( dno int primary key, dname varchar(30) unique, dloc varchar(50) default 北京);-显示departments的表结构desc departments;- 向部门表插入数据 insert into departments(dno,dname,dloc) values(1,销售部,长春 ),(2,财务部,沈阳 ),(3,开发部,哈尔滨 ),(4,人事部,北京 ),(5,董事会,北京 ),(6,后勤部,北京 );- 查询departments表中的数据select * from departments;*- 创建员工表(employees)create table employees( eno int primary key, ename varchar(20), ehiredate date, ejob varchar(16), emgr int, esal decimal, ebonus decimal, deptno int,constraint fk_deptno foreign key( deptno) references departments(dno);-显示employees的表结构desc employees;- 向员工表插入数据insert into employees(eno,ename,ehiredate,ejob,emgr,esal,ebonus,deptno)values (1001,郑莹,1999-1-1,销售部长,5001,10000,1500,1),(1002,梁睿,1999-7-7,经理,1001,6000,1000,1),(1003,赵思,1999-7-7,销售员,1002,1500,2000,1),(1004,smith,2000-1-1,销售员,1002,1500,2000,1),(1005,杨幂,2005-1-1,销售员,1002,1500,2000,1),(2001,张松,1998-10-3,财务部长,5001,8000,1000,2),(2002,孙威,1998-10-20,会计,2001,4000,null,2),(2003,王东,1998-10-20,出纳,2001,3000,null,2),(3001,胡歌,1999-6-1,开发部长,5001,12000,3000,3),(3002,邓超,1999-12-6,项目经理,3001,7000,1000,3),(3003,陈赫,2000-1-1,程序员,3001,6000,1000,3),(3004,鹿晗,2000-1-1,程序员,3001,6500,2000,3),(3005,杨洋,2003-9-1,程序员,3001,4000,1000,3),(4001,李丽,1999-1-1,人事部长,5001,8000,1000,4),(4002,rose,1999-2-10,办事员,4001,4000,null,4),(4003,吴坤,2007-10-1,办事员,4001,3500,null,4),(4004,马萍,2009-5-17,办事员,4001,3000,null,4),(5001,姜红,1998-1-1,董事长,null,20000,null,5),(1,栾凯,2010-1-1,null,null,1500,null,null),(2,程程,2010-1-1,null,null,1500,null,null);- 查询employees表中的数据select * from employees;*-创建工资表(salary)create table salary( eno int primary key, ejob varchar(16), esal decimal, ebonus decimal);-显示salary的表结构desc salary;- 向工资表插入数据insert into salary select eno,ejob,esal,ebonus from employees;- 查询salary表中的数据select * from salary;*- 创建学生管理信息系统数据库(stuMIS)create database stuMIS default character set utf8;- 打开stuMIS数据库use stuMIS;*- 创建部门表(department)