SELECT
DISTINCT DATE_FORMAT(date_add(concat('2019-01-01'), INTERVAL(help_topic_id)DAY), '%Y-%m' ) DT
FROM
mysql.help_topic
WHERE
help_topic_id <= timestampdiff(DAY,concat('2019-01-01'), concat('2019-12-01'))
//TODO
具体实现原理自己查是怎么回事吧,项目着急先实现了就,过后有功夫再来补充
网友评论