sql 반복문으로 년도 만들기

 sql 에서 join을 위해 년도 테이블을 읨의로 만드는 방법 

 

SELECT 
    T.date AS 'year',
    COUNT(r.issue_de) AS year_count
FROM 
    (
     SELECT
     DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL seq - 1 YEAR), '%Y') AS date
     FROM (
           SELECT @num := @num + 1 AS seq
           FROM information_schema.tables a
              , information_schema.tables b
              , (SELECT @num := 0) c
          ) seq_table
     WHERE seq <=  300
    ) T
LEFT JOIN 
    ㅁ.ㅁ r
ON 
    T.date = YEAR(r.issue_de)
WHERE 
	mbr_id = 'ㅁㅁㅁㅁ'
GROUP BY 
    T.date;