MySql数据模拟

# 创建员工表
create table Demo.emp(
	id INT auto_increment NOT NULL,
	
	name varchar(20) null,
	sex char(2) null,
	salary double null,
	hire_date DATETIME null,
	dept_name varchar(20) null,
	PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_general_ci;

# 添加测试数据
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('孙悟空','男',7200,'2013-02-04','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('猪八戒','男',3600,'2010-12-02','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('唐僧','男',9000,'2008-08-08','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('白骨精','女',5000,'2015-10-07','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('蜘蛛精','女',5000,'2011-03-14','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('玉兔精','女',200,'2000-03-14','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('林黛玉','女',10000,'2019-10-07','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('黄蓉','女',3500,'2011-09-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('吴承恩','男',20000,'2000-03-14',null);
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('孙悟饭','男', 10,'2020-03-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('兔八哥','女', 300,'2010-03-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('Tom','男', null,'2010-03-14','财务部');

insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('孙悟空222','男',7200,'2013-02-04','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('猪八戒222','男',3600,'2010-12-02','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('唐僧222','男',9000,'2008-08-08','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('白骨精222','女',5000,'2015-10-07','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('蜘蛛精222','女',5000,'2011-03-14','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('玉兔精222','女',200,'2000-03-14','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('林黛玉222','女',10000,'2019-10-07','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('黄蓉222','女',3500,'2011-09-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('吴承恩222','男',20000,'2000-03-14',null);
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('孙悟饭222','男', 10,'2020-03-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('兔八哥222','女', 300,'2010-03-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('Tom222','男', null,'2010-03-14','财务部');

insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('孙悟空333','男',7200,'2013-02-04','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('猪八戒333','男',3600,'2010-12-02','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('唐僧333','男',9000,'2008-08-08','教学部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('白骨精333','女',5000,'2015-10-07','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('蜘蛛精333','女',5000,'2011-03-14','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('玉兔精333','女',200,'2000-03-14','市场部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('林黛玉333','女',10000,'2019-10-07','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('黄蓉333','女',3500,'2011-09-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('吴承恩333','男',20000,'2000-03-14',null);
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('孙悟饭333','男', 10,'2020-03-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('兔八哥333','女', 300,'2010-03-14','财务部');
insert into Demo.emp(name,sex,salary,hire_date,dept_name) VALUES('Tom333','男', null,'2010-03-14','财务部');