select (curdate() + interval(cast(mysql.help_topic.help_topic_id as signed) -2 ) day) as day
from mysql.help_topic having (day <= date_format(curdate(),'%y-%m-%d'))
order by day desc
mysql 获取连续的日期 select (curdate() + interval(cast(mysql.help_topic.help_topic_id as signed) -2 ) day) as day from mysql.help_topic having (day <= date_format(curdate(),'%y-%m-%d')) order by day desc备注:2表示当前天向前推2天的日期。结果如下...