MySql时间 本年度月份查询

SELECT DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 11 MONTH),'%Y-%m')  t
	union ALL select	 
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 10 MONTH),'%Y-%m') t
	union ALL select 
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 9 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 8 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 7 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 6 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 5 MONTH),'%Y-%m') t
	union ALL select
    DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 4 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 3 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 2 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(date_add(curdate() - DAY (curdate()) + 1,INTERVAL - 1 MONTH),'%Y-%m') t
	union ALL select
	DATE_FORMAT(last_day(SYSDATE()),'%Y-%m') t