Revision: 65544
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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