Return to Snippet

Revision: 65544
at December 17, 2013 08:48 by kidmizere


Initial Code
CREATE PROCEDURE filldates (dateStart DATE, dateEnd DATE)
BEGIN

WHILE dateStart <= dateEnd DO
	INSERT INTO workflow (workdate)
VALUES
	(dateStart);


SET dateStart = date_add(dateStart, INTERVAL 1 DAY);


END
WHILE;


END;

Initial URL
http://stackoverflow.com/questions/10132024/how-to-populate-a-table-with-a-range-of-dates

Initial Description
Not Mine but nicely done

Initial Title
fill dates MYSQL

Initial Tags


Initial Language
MySQL