select date_add(curdate(), interval(cast(help_topic_id as signed integer) - 30) day) day
from mysql.help_topic
where help_topic_id <= day(last_day(curdate()))
order by help_topic_id
-- 最近7天
select date_add(curdate(), interval(cast(help_topic_id as signed integer) - 6) day) day
from mysql.help_topic
where help_topic_id <= 6
order by help_topic_id
-- 一年内的每个月
select mid(date_add(curdate(), interval(cast(help_topic_id as signed integer) - 11) day) ,1,7) day
from mysql.help_topic
where help_topic_id <= 11
order by help_topic_id
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。