SELECT
YEAR (CURDATE()) as d
UNION select YEAR (CURDATE()) -1 as d
UNION select YEAR (CURDATE()) -2 as d
UNION select YEAR (CURDATE()) -3 as d
按需求增加递增
SELECT
YEAR (CURDATE()) as d
UNION select YEAR (CURDATE()) -1 as d
UNION select YEAR (CURDATE()) -2 as d
UNION select YEAR (CURDATE()) -3 as d
按需求增加递增