MySQL Loop Usage --- select whole year status

-- Create Procedure
DELIMITER $$
CREATE PROCEDURE TIMELOOP()

   BEGIN
      DECLARE a INT Default 0 ;
      simple_loop: LOOP
         select DATE_ADD('20120101',interval a day) "Date", week(DATE_ADD('20120101',interval a day)) "Week", date_format(DATE_ADD('20120101',interval a day),"%m") "Month",quarter(DATE_ADD('20120101',interval a day)) "Season", date_format(DATE_ADD('20120101',interval a day),"%Y") "Year";
         SET a=a+1;
         IF a=366 THEN
            LEAVE simple_loop;
         END IF;
   END LOOP simple_loop;
END $$

-- Run Procedure
call TIMELOOP();

-- Delete Procedure
DROP PROCEDURE IF EXISTS `TIMELOOP`;

-- Check If exists procedures
show PROCEDURE status;