mysql 按范围生成记录
如按月生成每日日期,2023-02-01 与 2023-02-28 为给定的范围
SELECT
DATE_ADD( '2023-02-01', INTERVAL help_topic_id DAY ) AS date
FROM
mysql.help_topic
WHERE
help_topic_id <= DATEDIFF('2023-02-28','2023-02-01')
如按月生成每日日期,2023-02-01 与 2023-02-28 为给定的范围
SELECT
DATE_ADD( '2023-02-01', INTERVAL help_topic_id DAY ) AS date
FROM
mysql.help_topic
WHERE
help_topic_id <= DATEDIFF('2023-02-28','2023-02-01')