日历辅助生成日期数据

DROP TABLE IF EXISTS `t_calendar_auxiliary`;
CREATE TABLE `t_calendar_auxiliary` (
  `i` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日历辅助表';
INSERT INTO `t_calendar_auxiliary` VALUES ('0');
INSERT INTO `t_calendar_auxiliary` VALUES ('1');
INSERT INTO `t_calendar_auxiliary` VALUES ('2');
INSERT INTO `t_calendar_auxiliary` VALUES ('3');
INSERT INTO `t_calendar_auxiliary` VALUES ('4');
INSERT INTO `t_calendar_auxiliary` VALUES ('5');
INSERT INTO `t_calendar_auxiliary` VALUES ('6');
INSERT INTO `t_calendar_auxiliary` VALUES ('7');
INSERT INTO `t_calendar_auxiliary` VALUES ('8');
INSERT INTO `t_calendar_auxiliary` VALUES ('9');
# 通过CROSS JOIN（笛卡尔乘积） 将两个表乘起来
SELECT
    adddate( '2020-02-01', numlist.id ) AS date_day
FROM
    (
SELECT
    n1.i + n10.i * 10 + n100.i * 100 AS id
FROM
    t_calendar_auxiliary n1
    CROSS JOIN t_calendar_auxiliary AS n10
    CROSS JOIN t_calendar_auxiliary AS n100
    ) AS numlist
WHERE
    adddate( '2020-02-01', numlist.id ) <= '2020-03-01'