1. 查询最近12个月月份列表
SELECT @s :=@s + 1 as index
, DATE_FORMAT(DATE(DATE_SUB(CURRENT_DATE, INTERVAL @s MONTH)),’%Y-%m’) AS date
FROM mysql.help_topic,(SELECT @s := -1) temp
WHERE @s < 12
ORDER BY date
2.查询时间段范围内月份列表
SELECT @s :=@s + 1 as index
, DATE_FORMAT(DATE(DATE_SUB(‘2020-12-30’, INTERVAL @s MONTH)),’%Y-%m’) AS date
FROM mysql.help_topic,(SELECT @s := -1) temp
where DATE(DATE_SUB(CURRENT_DATE, INTERVAL @s+1 MONTH))>=DATE_FORMAT(‘2020-06-30’,’%Y-%m’)
order by date asc