2023年法定节假日信息表-MySQL_sql计算2023年工作日-CSDN博客

本文链接：https://blog.csdn.net/moshi_monian/article/details/128546802
该SQL脚本创建了一个名为holiday_info的表，存储2023年的周末和法定节假日信息，包括假日名称、日期和备注。数据包括元旦、春节、清明节、劳动节、端午节以及中秋/国庆节等节日，并标记了周末日期。
摘要由CSDN通过智能技术生成
2023年的周末和法定节假日SQL
-- MySQL dump 10.13  Distrib 5.7.35, for Win64 (x86_64)
--
-- ------------------------------------------------------
-- Server version	5.7.37

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `holiday_info`
--

DROP TABLE IF EXISTS `holiday_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `holiday_info` (
  `holiday_id` int(11) NOT NULL AUTO_INCREMENT,
  `holiday_name` varchar(20) DEFAULT NULL COMMENT '假日名称',
  `holiday_time` date DEFAULT NULL COMMENT '假日时间',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`holiday_id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COMMENT='节假日';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `holiday_info`
--

LOCK TABLES `holiday_info` WRITE;
/*!40000 ALTER TABLE `holiday_info` DISABLE KEYS */;
INSERT INTO `holiday_info` VALUES (1,'元旦','2023-01-01','法定节假日'),(2,'元旦','2023-01-02','法定节假日'),(3,'周六','2023-01-07','周末'),(4,'周日','2023-01-08','周末'),(5,'周六','2023-01-14','周末'),(6,'周日','2023-01-15','周末'),(7,'春节','2023-01-21','法定节假日'),(8,'春节','2023-01-22','法定节假日'),(9,'春节','2023-01-23','法定节假日'),(10,'春节','2023-01-24','法定节假日'),(11,'春节','2023-01-25','法定节假日'),(12,'春节','2023-01-26','法定节假日'),(13,'春节','2023-01-27','法定节假日'),(14,'周六','2023-02-04','周末'),(15,'周日','2023-02-05','周末'),(16,'周六','2023-02-11','周末'),(17,'周日','2023-02-12','周末'),(18,'周六','2023-02-18','周末'),(19,'周日','2023-02-19','周末'),(20,'周六','2023-02-25','周末'),(21,'周日','2023-02-26','周末'),(22,'周六','2023-03-04','周末'),(23,'周日','2023-03-05','周末'),(24,'周六','2023-03-11','周末'),(25,'周日','2023-03-12','周末'),(26,'周六','2023-03-18','周末'),(27,'周日','2023-03-19','周末'),(28,'周六','2023-03-25','周末'),(29,'周日','2023-03-26','周末'),(30,'周六','2023-04-01','周末'),(31,'周日','2023-04-02','周末'),(32,'清明节','2023-04-05','法定节假日'),(33,'周六','2023-04-08','周末'),(34,'周日','2023-04-09','周末'),(35,'周六','2023-04-15','周末'),(36,'周日','2023-04-16','周末'),(37,'周六','2023-04-22','周末'),(38,'劳动节','2023-04-29','法定节假日'),(39,'劳动节','2023-04-30','法定节假日'),(40,'劳动节','2023-05-01','法定节假日'),(41,'劳动节','2023-05-02','法定节假日'),(42,'劳动节','2023-05-03','法定节假日'),(43,'周日','2023-05-07','周末'),(44,'周六','2023-05-13','周末'),(45,'周日','2023-05-14','周末'),(46,'周六','2023-05-20','周末'),(47,'周日','2023-05-21','周末'),(48,'周六','2023-05-27','周末'),(49,'周日','2023-05-28','周末'),(50,'周六','2023-06-03','周末'),(51,'周日','2023-06-04','周末'),(52,'周六','2023-06-10','周末'),(53,'周日','2023-06-11','周末'),(54,'周六','2023-06-17','周末'),(55,'周日','2023-06-18','周末'),(56,'端午节','2023-06-22','法定节假日'),(57,'端午节','2023-06-23','法定节假日'),(58,'端午节','2023-06-24','法定节假日'),(59,'周六','2023-07-01','周末'),(60,'周日','2023-07-02','周末'),(61,'周六','2023-07-08','周末'),(62,'周日','2023-07-09','周末'),(63,'周六','2023-07-15','周末'),(64,'周日','2023-07-16','周末'),(65,'周六','2023-07-22','周末'),(66,'周日','2023-07-23','周末'),(67,'周六','2023-07-29','周末'),(68,'周日','2023-07-30','周末'),(69,'周六','2023-08-05','周末'),(70,'周日','2023-08-06','周末'),(71,'周六','2023-08-12','周末'),(72,'周日','2023-08-13','周末'),(73,'周六','2023-08-19','周末'),(74,'周日','2023-08-20','周末'),(75,'周六','2023-08-26','周末'),(76,'周日','2023-08-27','周末'),(77,'周六','2023-09-02','周末'),(78,'周日','2023-09-03','周末'),(79,'周六','2023-09-09','周末'),(80,'周日','2023-09-10','周末'),(81,'周六','2023-09-16','周末'),(82,'周日','2023-09-17','周末'),(83,'周六','2023-09-23','周末'),(84,'周日','2023-09-24','周末'),(85,'中秋/国庆节','2023-09-29','法定节假日'),(86,'中秋/国庆节','2023-09-30','法定节假日'),(87,'中秋/国庆节','2023-10-01','法定节假日'),(88,'中秋/国庆节','2023-10-02','法定节假日'),(89,'中秋/国庆节','2023-10-03','法定节假日'),(90,'中秋/国庆节','2023-10-04','法定节假日'),(91,'中秋/国庆节','2023-10-05','法定节假日'),(92,'中秋/国庆节','2023-10-06','法定节假日'),(93,'周六','2023-10-14','周末'),(94,'周日','2023-10-15','周末'),(95,'周六','2023-10-21','周末'),(96,'周日','2023-10-22','周末'),(97,'周六','2023-10-28','周末'),(98,'周日','2023-10-29','周末'),(99,'周六','2023-11-04','周末'),(100,'周日','2023-11-05','周末'),(101,'周六','2023-11-11','周末'),(102,'周日','2023-11-12','周末'),(103,'周六','2023-11-18','周末'),(104,'周日','2023-11-19','周末'),(105,'周六','2023-11-25','周末'),(106,'周日','2023-11-26','周末'),(107,'周六','2023-12-02','周末'),(108,'周日','2023-12-03','周末'),(109,'周六','2023-12-09','周末'),(110,'周日','2023-12-10','周末'),(111,'周六','2023-12-16','周末'),(112,'周日','2023-12-17','周末'),(113,'周六','2023-12-23','周末'),(114,'周日','2023-12-24','周末'),(115,'周六','2023-12-30','周末'),(116,'周日','2023-12-31','周末');
/*!40000 ALTER TABLE `holiday_info` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-01-04 13:59:07