-
tb_work_day(2015-2021).sql下载
资源介绍
包括数据:2015-2021 每一天的数据,
举例 work_day_type:0工作日,1法定节假日, 2休息日加班, 3休息日
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211001', '2021-10-01', 5, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211002', '2021-10-02', 6, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211003', '2021-10-03', 0, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211004', '2021-10-04', 1, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211005', '2021-10-05', 2, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211006', '2021-10-06', 3, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211007', '2021-10-07', 4, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211008', '2021-10-08', 5, '0');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211009', '2021-10-09', 6, '2');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211010', '2021-10-10', 0, '3');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211011', '2021-10-11', 1, '0');
- 上一篇: 数据表的创建与维护管理实验--实验报告
- 下一篇: 完整的Oracle12C物理DG搭建.pdf