Mysql 查询指定时间内的每一天日期

select date_add('2021-04-04', interval (cast(help_topic_id as signed integer)) day) day
from mysql.help_topic
where help_topic_id < datediff('2021-07-04', '2021-04-04') + 1
order by help_topic_id

posted @ 2021-07-04 09:11  aliRicky  阅读(784)  评论(0)    收藏  举报