2024年 节假日 sql (0.工作日 1周末休息 2节假日)


CREATE TABLE `system_workday` (
  `day_id` int(11) NOT NULL AUTO_INCREMENT,
  `day_day` int(11) DEFAULT NULL COMMENT '时间  年月日',
  `day_type` int(4) DEFAULT '0' COMMENT '类型  0.工作日 1周末休息 2节假日  ',
  PRIMARY KEY (`day_id`)
)  COMMENT='系统节假日数据';


INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240101,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240102,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240103,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240104,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240105,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240106,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240107,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240108,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240109,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240110,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240111,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240112,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240113,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240114,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240115,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240116,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240117,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240118,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240119,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240120,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240121,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240122,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240123,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240124,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240125,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240126,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240127,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240128,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240129,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240130,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240131,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240201,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240202,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240203,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240204,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240205,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240206,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240207,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240208,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240209,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240210,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240211,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240212,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240213,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240214,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240215,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240216,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240217,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240218,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240219,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240220,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240221,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240222,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240223,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240224,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240225,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240226,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240227,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240228,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240229,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240301,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240302,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240303,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240304,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240305,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240306,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240307,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240308,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240309,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240310,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240311,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240312,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240313,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240314,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240315,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240316,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240317,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240318,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240319,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240320,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240321,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240322,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240323,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240324,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240325,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240326,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240327,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240328,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240329,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240330,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240331,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240401,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240402,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240403,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240404,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240405,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240406,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240407,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240408,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240409,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240410,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240411,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240412,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240413,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240414,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240415,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240416,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240417,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240418,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240419,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240420,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240421,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240422,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240423,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240424,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240425,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240426,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240427,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240428,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240429,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240430,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240501,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240502,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240503,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240504,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240505,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240506,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240507,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240508,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240509,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240510,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240511,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240512,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240513,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240514,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240515,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240516,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240517,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240518,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240519,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240520,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240521,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240522,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240523,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240524,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240525,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240526,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240527,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240528,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240529,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240530,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240531,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240601,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240602,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240603,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240604,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240605,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240606,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240607,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240608,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240609,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240610,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240611,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240612,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240613,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240614,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240615,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240616,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240617,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240618,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240619,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240620,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240621,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240622,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240623,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240624,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240625,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240626,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240627,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240628,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240629,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240630,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240701,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240702,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240703,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240704,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240705,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240706,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240707,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240708,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240709,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240710,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240711,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240712,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240713,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240714,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240715,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240716,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240717,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240718,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240719,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240720,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240721,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240722,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240723,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240724,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240725,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240726,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240727,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240728,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240729,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240730,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240731,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240801,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240802,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240803,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240804,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240805,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240806,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240807,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240808,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240809,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240810,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240811,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240812,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240813,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240814,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240815,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240816,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240817,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240818,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240819,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240820,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240821,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240822,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240823,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240824,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240825,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240826,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240827,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240828,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240829,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240830,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240831,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240901,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240902,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240903,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240904,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240905,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240906,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240907,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240908,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240909,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240910,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240911,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240912,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240913,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240914,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240915,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240916,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240917,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240918,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240919,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240920,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240921,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240922,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240923,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240924,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240925,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240926,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240927,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240928,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240929,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20240930,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241001,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241002,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241003,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241004,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241005,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241006,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241007,2);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241008,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241009,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241010,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241011,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241012,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241013,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241014,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241015,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241016,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241017,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241018,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241019,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241020,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241021,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241022,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241023,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241024,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241025,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241026,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241027,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241028,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241029,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241030,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241031,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241101,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241102,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241103,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241104,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241105,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241106,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241107,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241108,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241109,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241110,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241111,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241112,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241113,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241114,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241115,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241116,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241117,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241118,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241119,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241120,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241121,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241122,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241123,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241124,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241125,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241126,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241127,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241128,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241129,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241130,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241201,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241202,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241203,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241204,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241205,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241206,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241207,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241208,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241209,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241210,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241211,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241212,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241213,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241214,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241215,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241216,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241217,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241218,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241219,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241220,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241221,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241222,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241223,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241224,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241225,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241226,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241227,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241228,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241229,1);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241230,0);
INSERT INTO `system_workday` (`day_day`,`day_type`) VALUES (20241231,0);
 

  • 12
    点赞
  • 13
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
要编写2024节假日SQL脚本,需要考虑中国的法定节假日周末。下面是一个可以参考的示例脚本: ``` -- 创建节假日表 CREATE TABLE holidays ( id INT AUTO_INCREMENT PRIMARY KEY, date DATE NOT NULL, description VARCHAR(255) NOT NULL ); -- 插入法定节假日 INSERT INTO holidays (date, description) VALUES ('2024-01-01', '元旦'), ('2024-02-04', '春节'), ('2024-02-05', '春节'), ('2024-02-06', '春节'), ('2024-02-07', '春节'), ('2024-02-08', '春节'), ('2024-04-04', '清明节'), ('2024-05-01', '劳动节'), ('2024-05-02', '劳动节'), ('2024-05-03', '劳动节'), ('2024-06-07', '端午节'), ('2024-09-22', '中秋节'), ('2024-10-01', '国庆节'), ('2024-10-02', '国庆节'), ('2024-10-03', '国庆节'), ('2024-10-04', '国庆节'), ('2024-10-05', '国庆节'), ('2024-10-06', '国庆节'), ('2024-10-07', '国庆节'); -- 插入周末 INSERT INTO holidays (date, description) SELECT DATE_ADD('2024-01-01', INTERVAL (a.n + b.n*7) DAY) as date, '周末' as description FROM (SELECT 0 as n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6) a, (SELECT 0 as n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6) b WHERE DATE_ADD('2024-01-01', INTERVAL (a.n + b.n*7) DAY) BETWEEN '2024-01-01' AND '2024-12-31'; -- 输出节假日数据 SELECT * FROM holidays; ``` 上述脚本首先创建了一个名为"holidays"的表,用于存储节假日数据。然后通过INSERT语句插入了2024的法定节假日周末数据。最后通过SELECT语句输出了节假日数据。 注意:上述脚本仅作为示例,实际使用时可能需要根据具体需求进行修改。此外,中国的法定节假日可能会根据政府公告进行调整,因此脚本中的节假日日期和描述需要根据最新的官方公告进行更新。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值