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

 

posted @ 2023-02-24 16:06  不再蒙查查  阅读(38)  评论(0编辑  收藏  举报