登录 注册
当前位置:主页 > 资源下载 > 27 > tb_work_day(2015-2021).sql下载

tb_work_day(2015-2021).sql下载

  • 更新:2024-07-09 17:12:26
  • 大小:176KB
  • 推荐:★★★★★
  • 来源:网友上传分享
  • 类别:MySQL - 数据库
  • 格式: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');