MySql 关于如何利用SQL设置整年的周六周日
有时候有些需求是需要工作日才能处理，节假日要顺延的，碰到这种我们就需要自己维护自己的日期表。
本文维护的是全年的，建议只维护节假日的，这样维护的数据会少很多，因为我已经是维护全年的啦，就为了自己方便，总结了几句SQL可以快速设置周六周日，至于法定节假日，因为全年也没几天，所以是在设置好周六周日后，再逐个对照日历表设置的。
如果是设置下下年的，就只维护节假日当天的日期，其他国家怎么安排的等国务院出了，再次维护！！
写此文方便自己，如果有正好需要维护日期的小伙伴，建议只需维护节假日哦！！
一、创建表
create table zy_work_day ( id bigint auto_increment comment '主键' primary key, years varchar(50) null comment '年份', date varchar(50) null comment '日期', date_type int null comment '类型;0=工作日,1=法定节假日,2=休息日加班,3=休息日', state int default 1 null comment '状态;0=失效，1=有效', enable char default 'Y' null comment '是否可用 默认为Y （Y:是,N:否）', create_by varchar(50) null comment '创建人', create_time datetime default CURRENT_TIMESTAMP null comment '创建时间', update_by varchar(50) null comment '更新人', update_time datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '更新时间', remark varchar(500) null comment '备注' ) comment '工作日日期信息表' collate = utf8mb4_unicode_ci;
二、导入2022年整年数据
INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-01-31', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-02-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-03-31', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-04-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-05-31', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-06-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-07-31', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-08-31', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-09-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-10-31', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-11-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-01', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-02', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-03', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-04', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-05', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-06', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-07', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-08', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-09', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-10', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-11', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-12', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-13', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-14', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-15', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-16', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-17', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-18', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-19', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-20', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-21', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-22', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-23', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-24', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-25', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-26', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-27', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-28', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-29', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-30', 0, 1, 'Y', null, NOW(), null, NOW(), null); INSERT INTO zy_work_day (years, date, date_type, state, enable, create_by, create_time, update_by, update_time, remark) VALUES ('2022', '2022-12-31', 0, 1, 'Y', null, NOW(), null, NOW(), null);
三、首先设置state字段值为自增
set @rownum=0; UPDATE zy_work_day set state = (select @rownum := @rownum +1 as nid) where years = '2022';
四、查看日历2022年的第一个周六日在哪天
五、根据日历和数据库的State值设置SQL
-- 由日历和数据库的数据可以看出；周六、周日%7分别等于1和2；于是可以设置where后的条件；
update zy_work_day set date_type = 3 where id in ( select c.id from (select @n := @n + 1 as n, a.* from (select * from zy_work_day where years = '2022' order by state asc) a, (select @n := 0) b) c where c.n % 7 = 1 or c.n % 7 = 2 );
六、最后设置好State，就完成咯！🌞
update zy_work_day set state= 1 where years = '2022';
