mysql安装时间循环脚本例子

前两天做一张报表，里边涉及历史数据清洗，所以记录下，以便以后直接用。

DELIMITER $$

USE `TopJet560Report`$$

DROP PROCEDURE IF EXISTS `pr_date`$$

CREATE DEFINER=`root`@`%` PROCEDURE `pr_date`(IN beginDate DATETIME,IN endDate DATETIME)
BEGIN
DECLARE nowdate DATETIME DEFAULT NOW();
DECLARE zhongjiandate DATETIME DEFAULT NOW();
DECLARE endtmp DATETIME DEFAULT NOW();
SET nowdate = DATE_FORMAT(beginDate,'%Y-%m-%d 00:00:00');
SET endtmp = DATE_FORMAT(endDate,'%Y-%m-%d 00:00:00');
WHILE nowdate<endtmp
DO
CALL pr_bonus_statistics_updatev2(nowdate);
SET nowdate = DATE_ADD(nowdate,INTERVAL 1 DAY);
-- set nowdate=nowdate+' 00:00:00';
END WHILE;
END$$

DELIMITER ;