当前位置：首页 > news >正文

2024年节假日sql脚本（区分休息日、节假日、工作日、调休工作）

news 2025/9/3 21:57:34

建表

CREATE TABLE `no_work_day` (`id` int NOT NULL AUTO_INCREMENT,`day` varchar(255) DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='节假日表';

执行脚本插入数据

INSERT INTO `no_work_day` (`day`) VALUES ('20240101');
INSERT INTO `no_work_day` (`day`) VALUES ('20240106');
INSERT INTO `no_work_day` (`day`) VALUES ('20240107');
INSERT INTO `no_work_day` (`day`) VALUES ('20240113');
INSERT INTO `no_work_day` (`day`) VALUES ('20240114');
INSERT INTO `no_work_day` (`day`) VALUES ('20240120');
INSERT INTO `no_work_day` (`day`) VALUES ('20240121');
INSERT INTO `no_work_day` (`day`) VALUES ('20240127');
INSERT INTO `no_work_day` (`day`) VALUES ('20240128');
INSERT INTO `no_work_day` (`day`) VALUES ('20240203');
INSERT INTO `no_work_day` (`day`) VALUES ('20240210');
INSERT INTO `no_work_day` (`day`) VALUES ('20240211');
INSERT INTO `no_work_day` (`day`) VALUES ('20240212');
INSERT INTO `no_work_day` (`day`) VALUES ('20240213');
INSERT INTO `no_work_day` (`day`) VALUES ('20240214');
INSERT INTO `no_work_day` (`day`) VALUES ('20240215');
INSERT INTO `no_work_day` (`day`) VALUES ('20240216');
INSERT INTO `no_work_day` (`day`) VALUES ('20240217');
INSERT INTO `no_work_day` (`day`) VALUES ('20240224');
INSERT INTO `no_work_day` (`day`) VALUES ('20240225');
INSERT INTO `no_work_day` (`day`) VALUES ('20240302');
INSERT INTO `no_work_day` (`day`) VALUES ('20240303');
INSERT INTO `no_work_day` (`day`) VALUES ('20240309');
INSERT INTO `no_work_day` (`day`) VALUES ('20240310');
INSERT INTO `no_work_day` (`day`) VALUES ('20240316');
INSERT INTO `no_work_day` (`day`) VALUES ('20240317');
INSERT INTO `no_work_day` (`day`) VALUES ('20240323');
INSERT INTO `no_work_day` (`day`) VALUES ('20240324');
INSERT INTO `no_work_day` (`day`) VALUES ('20240330');
INSERT INTO `no_work_day` (`day`) VALUES ('20240331');
INSERT INTO `no_work_day` (`day`) VALUES ('20240404');
INSERT INTO `no_work_day` (`day`) VALUES ('20240405');
INSERT INTO `no_work_day` (`day`) VALUES ('20240406');
INSERT INTO `no_work_day` (`day`) VALUES ('20240413');
INSERT INTO `no_work_day` (`day`) VALUES ('20240414');
INSERT INTO `no_work_day` (`day`) VALUES ('20240420');
INSERT INTO `no_work_day` (`day`) VALUES ('20240421');
INSERT INTO `no_work_day` (`day`) VALUES ('20240427');
INSERT INTO `no_work_day` (`day`) VALUES ('20240501');
INSERT INTO `no_work_day` (`day`) VALUES ('20240502');
INSERT INTO `no_work_day` (`day`) VALUES ('20240503');
INSERT INTO `no_work_day` (`day`) VALUES ('20240504');
INSERT INTO `no_work_day` (`day`) VALUES ('20240505');
INSERT INTO `no_work_day` (`day`) VALUES ('20240512');
INSERT INTO `no_work_day` (`day`) VALUES ('20240518');
INSERT INTO `no_work_day` (`day`) VALUES ('20240519');
INSERT INTO `no_work_day` (`day`) VALUES ('20240525');
INSERT INTO `no_work_day` (`day`) VALUES ('20240526');
INSERT INTO `no_work_day` (`day`) VALUES ('20240601');
INSERT INTO `no_work_day` (`day`) VALUES ('20240602');
INSERT INTO `no_work_day` (`day`) VALUES ('20240608');
INSERT INTO `no_work_day` (`day`) VALUES ('20240609');
INSERT INTO `no_work_day` (`day`) VALUES ('20240610');
INSERT INTO `no_work_day` (`day`) VALUES ('20240615');
INSERT INTO `no_work_day` (`day`) VALUES ('20240616');
INSERT INTO `no_work_day` (`day`) VALUES ('20240622');
INSERT INTO `no_work_day` (`day`) VALUES ('20240623');
INSERT INTO `no_work_day` (`day`) VALUES ('20240629');
INSERT INTO `no_work_day` (`day`) VALUES ('20240630');
INSERT INTO `no_work_day` (`day`) VALUES ('20240706');
INSERT INTO `no_work_day` (`day`) VALUES ('20240707');
INSERT INTO `no_work_day` (`day`) VALUES ('20240713');
INSERT INTO `no_work_day` (`day`) VALUES ('20240714');
INSERT INTO `no_work_day` (`day`) VALUES ('20240720');
INSERT INTO `no_work_day` (`day`) VALUES ('20240721');
INSERT INTO `no_work_day` (`day`) VALUES ('20240727');
INSERT INTO `no_work_day` (`day`) VALUES ('20240728');
INSERT INTO `no_work_day` (`day`) VALUES ('20240803');
INSERT INTO `no_work_day` (`day`) VALUES ('20240804');
INSERT INTO `no_work_day` (`day`) VALUES ('20240810');
INSERT INTO `no_work_day` (`day`) VALUES ('20240811');
INSERT INTO `no_work_day` (`day`) VALUES ('20240817');
INSERT INTO `no_work_day` (`day`) VALUES ('20240818');
INSERT INTO `no_work_day` (`day`) VALUES ('20240824');
INSERT INTO `no_work_day` (`day`) VALUES ('20240825');
INSERT INTO `no_work_day` (`day`) VALUES ('20240831');
INSERT INTO `no_work_day` (`day`) VALUES ('20240901');
INSERT INTO `no_work_day` (`day`) VALUES ('20240907');
INSERT INTO `no_work_day` (`day`) VALUES ('20240908');
INSERT INTO `no_work_day` (`day`) VALUES ('20240915');
INSERT INTO `no_work_day` (`day`) VALUES ('20240916');
INSERT INTO `no_work_day` (`day`) VALUES ('20240917');
INSERT INTO `no_work_day` (`day`) VALUES ('20240921');
INSERT INTO `no_work_day` (`day`) VALUES ('20240922');
INSERT INTO `no_work_day` (`day`) VALUES ('20240928');
INSERT INTO `no_work_day` (`day`) VALUES ('20241001');
INSERT INTO `no_work_day` (`day`) VALUES ('20241002');
INSERT INTO `no_work_day` (`day`) VALUES ('20241003');
INSERT INTO `no_work_day` (`day`) VALUES ('20241004');
INSERT INTO `no_work_day` (`day`) VALUES ('20241005');
INSERT INTO `no_work_day` (`day`) VALUES ('20241006');
INSERT INTO `no_work_day` (`day`) VALUES ('20241007');
INSERT INTO `no_work_day` (`day`) VALUES ('20241013');
INSERT INTO `no_work_day` (`day`) VALUES ('20241019');
INSERT INTO `no_work_day` (`day`) VALUES ('20241020');
INSERT INTO `no_work_day` (`day`) VALUES ('20241026');
INSERT INTO `no_work_day` (`day`) VALUES ('20241027');
INSERT INTO `no_work_day` (`day`) VALUES ('20241102');
INSERT INTO `no_work_day` (`day`) VALUES ('20241103');
INSERT INTO `no_work_day` (`day`) VALUES ('20241109');
INSERT INTO `no_work_day` (`day`) VALUES ('20241110');
INSERT INTO `no_work_day` (`day`) VALUES ('20241116');
INSERT INTO `no_work_day` (`day`) VALUES ('20241117');
INSERT INTO `no_work_day` (`day`) VALUES ('20241123');
INSERT INTO `no_work_day` (`day`) VALUES ('20241124');
INSERT INTO `no_work_day` (`day`) VALUES ('20241130');
INSERT INTO `no_work_day` (`day`) VALUES ('20241201');
INSERT INTO `no_work_day` (`day`) VALUES ('20241207');
INSERT INTO `no_work_day` (`day`) VALUES ('20241208');
INSERT INTO `no_work_day` (`day`) VALUES ('20241214');
INSERT INTO `no_work_day` (`day`) VALUES ('20241215');
INSERT INTO `no_work_day` (`day`) VALUES ('20241221');
INSERT INTO `no_work_day` (`day`) VALUES ('20241222');
INSERT INTO `no_work_day` (`day`) VALUES ('20241228');
INSERT INTO `no_work_day` (`day`) VALUES ('20241229');