SELECT DATE_FORMAT(DATE_ADD(
CONCAT(YEAR(DATE(‘2018-12-01’)),’-01-01’),INTERVAL (CAST( help_topic_id AS SIGNED INTEGER )) MONTH ),’%m’) month
FROM mysql.help_topic
WHERE help_topic_id < 12 ORDER BY month ASC
mysql 查询本年度所有月份
最新推荐文章于 2024-07-17 14:16:37 发布