# 創建員工表 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','財務部');

總結

以上是生活随笔為你收集整理的MySql数据模拟的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。