Update By Date - Stored Procedure

gistfile1.txt

delimiter $$
drop procedure if exists update_by_date$$
CREATE PROCEDURE update_by_date(IN startdate DATE, IN enddate date)
PROC:BEGIN
 DECLARE idate date;
 DECLARE cr BIGINT;
 DECLARE done INT DEFAULT FALSE;
 
 -- requires data_dimension table - be found in my github repo
 DECLARE curs1 CURSOR FOR SELECT date FROM date_dimension WHERE date between startdate and enddate;
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
 OPEN curs1;
read_loop: LOOP
FETCH curs1 INTO idate;
IF done THEN
LEAVE read_loop;
END IF;

-- do something 
-- WHERE date = idate;

END LOOP;
CLOSE curs1;

END$$
delimiter ;


-- call update_by_date('2014-01-01','2015-01-01');