-- 1、给部门表depart添加数据，如下图所示：(4分) INSERT INTO depart (departid,departname,departlocation) VALUES ('01','总裁办','北京'), ('02','财务处','上海'), ('03','研发部','武汉'), ('04','销售部','深圳'); -- 2、给职位表job添加数据，如下图所示：(4分) INSERT INTO job (jobid,jobname,joblevel) VALUES ('01','董事长',20), ('02','总经理',18), ('03','经理',16), ('04','销售员',11), ('05','分析师',14), ('06','文员',10), ('07','会计',12); -- 3、给员工表employee添加数据，如下图所示：(7分) INSERT INTO employee (empid,empname,empsex,empjob,empmgr,diredate,Salary,departid) VALUES ('10001','李俊涛','男','01',NULL,'2001-09-01',99999,'01'), ('10002','刘备','男','02','10001','2005-10-01',50000,'01'), ('10003','关羽','男','03','10002','2006-05-01',30000,'04'), ('10004','张飞','男','03','10002','2006-05-01',30000,'04'), ('10005','诸葛亮','男','05','10002','2012-07-13',45000,'03'), ('10006','赵云','男','03','10002','2008-04-24',25000,'02'), ('20003','孙尚香','女','06','10006','2016-09-26',5500,'03'), ('10008','黄月英','女','07','10005','2014-01-12',13500,'02'), ('30010','徐庶','男','06','10006','2007-11-11',28000,'02'), ('30035','周仓','男','04','10003','2015-03-12',5800,'04'), ('40001','马超','男','04','10004','2018-08-22',7900,'04'), ('50001','孟获','男','04','10002','2021-02-13',4500,'04');
扫一扫
1358
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
