2025年系统节假日sql

最新推荐文章于 2025-04-27 09:29:34 发布
最新推荐文章于 2025-04-27 09:29:34 发布
阅读量923 收藏 8
点赞数 5
文章标签： sql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_41040364/article/details/143850022
版权 
CREATE TABLE `calendar` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `day` date DEFAULT NULL COMMENT '日期',
  `code` smallint(2) DEFAULT NULL COMMENT '0.工作日 1.法定节假日 2.休息日加班 3.休息日',
  PRIMARY KEY (`id`),
  KEY `day` (`day`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
-- 一月
INSERT INTO `calendar` (`day`,`code`) VALUES (20250101,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250102,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250103,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250104,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250105,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250106,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250107,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250108,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250109,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250110,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250111,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250112,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250113,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250114,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250115,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250116,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250117,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250118,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250119,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250120,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250121,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250122,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250123,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250124,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250125,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250126,2);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250127,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250128,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250129,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250130,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250131,1);
												 
-- 二月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250201,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250202,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250203,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250204,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250205,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250206,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250207,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250208,2);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250209,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250210,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250211,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250212,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250213,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250214,9);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250215,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250216,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250217,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250218,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250219,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250220,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250221,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250222,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250223,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250224,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250225,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250226,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250227,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250228,0);
												 
-- 三月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250301,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250302,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250303,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250304,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250305,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250306,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250307,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250308,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250309,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250310,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250311,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250312,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250313,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250314,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250315,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250316,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250317,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250318,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250319,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250320,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250321,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250322,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250323,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250324,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250325,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250326,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250327,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250328,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250329,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250330,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250331,0);
												 
-- 四月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250401,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250402,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250403,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250404,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250405,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250406,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250407,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250408,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250409,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250410,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250411,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250412,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250413,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250414,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250415,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250416,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250417,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250418,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250419,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250420,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250421,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250422,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250423,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250424,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250425,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250426,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250427,2);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250428,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250429,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250430,0);
												 
-- 五月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250501,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250502,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250503,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250504,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250505,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250506,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250507,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250508,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250509,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250510,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250511,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250512,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250513,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250514,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250515,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250516,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250517,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250518,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250519,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250520,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250521,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250522,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250523,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250524,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250525,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250526,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250527,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250528,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250529,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250530,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250531,1);
												 
-- 六月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250601,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250602,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250603,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250604,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250605,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250606,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250607,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250608,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250609,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250610,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250611,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250612,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250613,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250614,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250615,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250616,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250617,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250618,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250619,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250620,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250621,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250622,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250623,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250624,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250625,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250626,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250627,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250628,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250629,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250630,0);
												 
-- 七月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250701,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250702,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250703,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250704,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250705,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250706,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250707,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250708,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250709,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250710,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250711,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250712,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250713,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250714,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250715,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250716,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250717,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250718,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250719,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250720,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250721,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250722,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250723,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250724,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250725,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250726,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250727,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250728,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250729,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250730,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250731,0);
												 
-- 八月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250801,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250802,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250803,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250804,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250805,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250806,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250807,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250808,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250809,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250810,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250811,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250812,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250813,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250814,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250815,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250816,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250817,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250818,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250819,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250820,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250821,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250822,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250823,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250824,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250825,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250826,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250827,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250828,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250829,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250830,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250831,3);
												 
-- 九月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20250901,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250902,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250903,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250904,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250905,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250906,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250907,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250908,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250909,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250910,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250911,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250912,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250913,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250914,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250915,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250916,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250917,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250918,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250919,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250920,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250921,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250922,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250923,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250924,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250925,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250926,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250927,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250928,2);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250929,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20250930,0);
												 
-- 10月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20251001,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251002,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251003,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251004,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251005,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251006,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251007,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251008,1);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251009,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251010,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251011,2);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251012,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251013,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251014,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251015,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251016,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251017,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251018,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251019,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251020,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251021,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251022,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251023,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251024,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251025,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251026,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251027,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251028,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251029,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251030,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251031,0);
												 
-- 11月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20251101,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251102,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251103,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251104,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251105,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251106,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251107,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251108,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251109,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251110,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251111,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251112,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251113,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251114,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251115,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251116,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251117,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251118,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251119,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251120,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251121,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251122,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251123,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251124,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251125,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251126,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251127,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251128,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251129,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251130,3);
												 
-- 12月                                          
INSERT INTO `calendar` (`day`,`code`) VALUES (20251201,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251202,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251203,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251204,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251205,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251206,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251207,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251208,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251209,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251210,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251211,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251212,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251213,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251214,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251215,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251216,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251217,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251218,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251219,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251220,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251221,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251222,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251223,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251224,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251225,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251226,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251227,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251228,3);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251229,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251230,0);
INSERT INTO `calendar` (`day`,`code`) VALUES (20251231,0);

qq_41040364
关注
MySQL 配置 2025 年节假日表 | 2025节假日配置
圆圈圈的博客
01-02 807
2025法定节假日配置 MySQL 配置 2025 年节假日表
2024年法定节假日数据库sql配置
qq_40563534的博客
12-28 1283
2024年法定节假日数据库sql配置
MYSQL数据库中2025年中国国家法定节假日与周末处理脚本
01-15
内容概要：文档详细记录了用于2025年的中国国家法定假日及其调休情况，在MySQL环境下执行的数据操作语句。首先定义并创建了一个存储公共假日信息的表格，接着分别对全年的重要节日如元旦、春节、清明节、劳动节、端午节以及国庆节和中秋节的假期进行了明确标识并填充进表格。为了保证查询精确，还包括额外插入非假日的工作周末并移除相应冲突日期的操作，使得全年各个日子的状态都得到了准确描述。 适合人群：从事数据库管理和应用系统开发的技术人员。 使用场景及目标：①在企业级业务信息系统规划中确定哪些时间为法定休假日期；②用于人力资源管理系统中排班安排或者薪资计算模块来识别非工作日；③辅助项目管理者制定合理的计划进度安排避免误算有效工作时长。 阅读建议：建议读者熟悉 MySQL 基础语法后再阅读本文档以便更好地理解和掌握其中涉及的各项 SQL 语句的应用方法和逻辑结构，可以尝试将此段SQL直接应用于实际环境进行测试学习
2025年节假日工作日可执行.sql文件
12-31
2025年节假日工作日可执行.sql文件
最新！2025年节假日sql脚本（区分休息日、节假日、工作日、调休工作）
bfsz的博客
11-13 2057
2025年节假日sql脚本（区分休息日、节假日、工作日、调休工作）
数据库增加2024,2025年所有法定节假日并去除调休SQL
青及笄经验分享
11-29 4018
在数据库中根据国家规定增加对应日期的调休，即周末也可能为工作日的情况，本次操作执行参考2024年所有调休以及法定节假日（包含双休），使用sql插入数据，有需要可以根据以下SQL进行调整。在很多业务场景中，需要特殊考虑到一些特殊的法定节假日，这些日期在实际对的业务逻辑中需要特殊计算，所以就需要在对应的库表中增加对应的日期记录，在实际操作时进行绕过。以下为插入所有节假日的日期的sql。
2024年节假日sql脚本（区分休息日、节假日、工作日、调休工作）
bfsz的博客
11-09 3394
【代码】2024年节假日sql（包括周末及调休）
2025日历sql语句：状态【0工作日 1周末休息 2节假日】
11-14
2025日历sql语句，拿走直接用。
2025年日历excel和Oracle新增sql（标记上班日，周末，节假日）
11-12
1、根据2024年11月12日所颁发的《2025年部分节假日安排的通知》文件中的通知内容所整理，手动整理了2025年的日历，并标注了工作日，周末，节假日 2、压缩包内有2个文件： ①.Excel表列举了2025年所有日期，并标记了...
2024年 节假日 sql (0.工作日 1周末休息 2节假日)
xiaocui_hot的博客
11-30 1605
ENGINE=InnoDB AUTO_INCREMENT=1096 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统节假日数据';`day_type` int(4) DEFAULT '0' COMMENT '类型 0.工作日 1周末休息 2节假日 ',`day_day` int(11) DEFAULT NULL COMMENT '时间 年月日',
2025年节假日sql oracle
qq_38190509的博客
11-13 1623
('星期六', '星期日') THEN。DAY_TYPE ：1工作日，2周末，3节假日。
2024-2025 节假日 生成sql脚本 ORACLE
kongbaixlw的博客
11-02 948
2024、2025 节假日 生成sql脚本 ORACLE
2025年法定节假日日历
kejia90的专栏
11-13 6340
2025节假日日历
2025年法定节假日JSON文本
yjy000的博客
12-04 1908
（周五也算周末）用于游戏的法定节假日判定，未成年周五也让玩。
史上最全mysql日期计算（月初、月末、上中下旬判断、年初、年末、季初、季末）
qq_42630887的博客
03-23 8392
其中 startDay 格式为 = ‘2021-01-01’，替换即可使用，如果对你有帮助的话，请多多关注，感谢大家~~ select DATE_FORMAT(startDay,'%Y%m%d') #3.日期(格式YYYYMMDD) select DATE_FORMAT(startDay,'%Y-%m-%d') #4.日期(格式YYYY-MM-DD) select DATE_FORMAT(startDay,'%Y/%m/%d') #5.日期(格式YYYY/MM/DD) SET workOrWe
2024 节假日 生成sql脚本 ORACLE
qq_38190509的博客
01-02 975
('星期六', '星期日') THEN。
springboot不连接数据库启动(原先连接了mysql数据库)
最新发布
uncofish的博客
04-27 277
配置application.properties。配置H2内存数据库（无需真实数据库）
MySQL索引优化、SQL分析与运行原理 - Java架构师面试实战
南客先生的博客
04-25 712
面试官：马架构，请问您对MySQL的B+树索引有什么理解？马架构：B+树是一种平衡多路查找树，所有的数据节点都存储在叶子节点上。相比于B树，B+树更适合范围查询和排序操作。面试官：那么覆盖索引是什么？马架构：覆盖索引是指查询的数据可以通过索引直接获取，而无需回表读取数据。面试官：如何选择合适的索引？马架构：需要根据查询条件、数据分布和查询频率进行综合评估。面试官：请解释SQL执行计划中的`EXPLAIN`关键字的作用。马架构：`EXPLAIN`可以帮助我们分析SQL的执行过程，包括使用的索引、扫描行数等信息
PostgreSQL的扩展 pgcrypto
文牧之的博客
04-27 414
pgcrypto 是 PostgreSQL 提供的加密扩展，包含各种加密函数、哈希函数和随机数生成器，是数据库级加密的重要工具。
2025年节假日sql
12-03
对不起，我无法提供具体的2025年节假日SQL查询，因为法定节假日通常是固定的，但由于日期的具体安排可能会因国家和地区而异，也受到政治、文化等因素影响，通常官方会在每年年初发布当年的放假安排。如果你需要查询某个特定地区的节假日信息，通常会涉及到数据库操作来查找相关的公告或历法数据。 假设你想了解如何编写查询来获取某年的节假日，你可以参考以下步骤： 1. **创建假日表**：首先，你需要有一个包含节日日期的表，其中可能包括字段如`holiday_name`(节日名称)、`date`(日期) 和 `is_holiday`(是否为假日标志)。 ```sql CREATE TABLE holidays ( id INT PRIMARY KEY, holiday_name VARCHAR(50), date DATE, is_holiday BOOLEAN ); ``` 2. **填充数据**：将每个年度的法定节假日插入到这个表里。 3. **查询2025年的节假日**：你可以使用以下基本结构来查询2025年的所有假日。这只是一个示例，实际的SQL取决于你的数据库架构： ```sql SELECT * FROM holidays WHERE YEAR(date) = 2025 AND is_holiday = 1; ```
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值