首页 > 数据库 >2024年系统节假日sql

2024年系统节假日sql

时间：2023-11-30 09:57:28浏览次数：39  
标签：workday 节假日 INTO system 2024 VALUES sql type day

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);

标签：workday,节假日,INTO,system,2024,VALUES,sql,type,day
From： https://www.cnblogs.com/cuishilei/p/17866601.html

相关文章

  • ubuntu server 22 LTS 安装MySQL8（二进制源码方式）
    原作来源：https://github.com/aminglinux/daily_shell/blob/main/29.sh根据我自己情况稍作修改mysql下载地址：https://downloads.mysql.com/archives/community/ 按照顺序执行逐行执行注意执行过程的提示，报错需处理：tar-xvfmysql-8.0.34-linux-glibc2.17-x86_64.tarsudo......
  • mysql 页级锁
    页级锁是MySQL中锁定粒度介于行级锁和表级锁中间的一种锁。表级锁速度快，但冲突多，行级冲突少，但速度慢。因此，采取了折衷的页级锁，一次锁定相邻的一组记录。BDB引擎支持页级锁。 从上到下，锁的粒度逐渐细粒化,但实现开销逐渐增大。 同时我们也要须知，表锁，页锁，行锁并不是一个具......
  • dwva 的SQL注入一关解决” Illegal mix of collations for operation ‘UNION’“ 问
    我是在phpstudy上面搭建的dvwa背景是我在一天晚上练习SQL注入出现了”Illegalmixofcollationsforoperation‘UNION’“问题就在网上搜索解决办法，发现是因为users表和table表的编码方式不一样导致的网上查到了table_name的排序编码，然后下载解压phpMyAdmin放到WWW目录下......
  • 2023-2024 20231313《计算机基础与程序设计》第十周学习总结
    2023-202420231313《计算机基础与程序设计》第十周学习总结作业速达作业课程班级链接作业要求计算机基础与程序设计第十周学习总结作业内容计算机科学概论第12，13，14章《C语言程序设计》第9章并完成云班课测试，信息系统、数据库与SQL、人工智能与专家系统、人工......
  • 第十三周Linux教材第十四章学习笔记——MySQL数据库系统
    MySQL数据库系统MySQL是一个广泛使用的关系型数据库管理系统（RDBMS），它是开源的，支持多用户和多线程。14.1基础知识1.数据库基础概念数据库（Database）：**数据库是一个包含相关数据的集合，并提供了对这些数据的有效管理和访问。表（Table）：**表是数据库中的基本数据结构，用于存储相关......
  • mysql慢查询日志
    一、开启并查看慢查询日志1、查看慢查询配置showvariableslike'%query%' 可以看到slow_query_log的值是OFF，也就是mysql默认是不启用慢查询日志的。这里还有个long_query_time，默认是10秒，也就是超过了10秒即为慢查询。log_queries_not_using_indexes，如果设置为ON，则会将所......
  • SQL HAVING 子句详解：在 GROUP BY 中更灵活的条件筛选
    SQLHAVING子句HAVING子句被添加到SQL中，因为WHERE关键字不能与聚合函数一起使用。HAVING语法SELECTcolumn_name(s)FROMtable_nameWHEREconditionGROUPBYcolumn_name(s)HAVINGconditionORDERBYcolumn_name(s);演示数据库以下是Northwind示例数据库中“Customers......
  • SQL HAVING 子句详解：在 GROUP BY 中更灵活的条件筛选
    SQLHAVING子句HAVING子句被添加到SQL中，因为WHERE关键字不能与聚合函数一起使用。HAVING语法SELECTcolumn_name(s)FROMtable_nameWHEREconditionGROUPBYcolumn_name(s)HAVINGconditionORDERBYcolumn_name(s);演示数据库以下是Northwind示例数据库中“Customers......
  • 2023-2024-1 学期20232423《网络空间安全导论》第四周学习总结
    教材学习——系统安全基础系统安全的两层含义：①以系统思维应对安全问题；②应对系统所面临的安全问题4.1系统安全概述时代在不断发展，系统安全也在不断演变：从二十世纪四十年代的第一台计算机，五十年代的第一个操作系统，六十年代的第一个分时系统CTSS、第一个安全操作系统Adept-50......
  • 2023-2024-1 20232404 《网络空间安全导论》第4周学习总结
    教材学习内容总结4.1系统安全概述世界上第一台通用电子计算机ENIAC，是纯粹的硬件裸机。世界上第一个安全系统Adept-50，属于分时系统。自外观察法是通过观察系统输入输出来分析系统的行为。一个系统是一个统一的整体，系统中的元素紧密关联。自内观察者属于系统的某个部分。......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99