MySQL循环日期

DROP PROCEDURE IF EXISTS `insertManyDate`$$

CREATE DEFINER=`root`@`%` PROCEDURE `insertManyDate`(IN `beginDate` DATE,IN `endDate` DATE)
BEGIN 
DECLARE nowdate DATE DEFAULT NOW();
DECLARE endtmp DATE DEFAULT NOW();
SET nowdate = DATE_FORMAT(beginDate,'%Y%m%d');
SET endtmp = DATE_FORMAT(endDate,'%Y%m%d');
WHILE nowdate<endtmp 
DO
INSERT INTO dibao_day_loop(ymd) VALUES(nowdate);
SET nowdate = DATE_ADD(nowdate,INTERVAL 1 DAY);
END WHILE;
END$$

DELIMITER ;