尝试这个：
DROp PROCEDURE IF EXISTS filldates;DELIMITER |CREATE PROCEDURE filldates(dateStart DATE, dateEnd DATE)BEGIN WHILE dateStart <= dateEnd DO INSERT INTO tablename (_date) VALUES (dateStart); SET dateStart = date_add(dateStart, INTERVAL 1 DAY); END WHILE;END;|DELIMITER ;CALL filldates('2011-01-01','2011-12-31');这是使用它的SQL Fiddle：http：//sqlfiddle.com/#！2
/ 65d13 / 1
按照 Andrew Fox的要求进行编辑（以检查日期是否已经存在）。
CREATE PROCEDURE filldates(dateStart DATE, dateEnd DATE)BEGINDECLARE adate date; WHILE dateStart <= dateEnd DO SET adate = (SELECT mydate FROM MyDates WHERe mydate = dateStart); IF adate IS NULL THEN BEGIN INSERT INTO MyDates (mydate) VALUES (dateStart); END; END IF; SET dateStart = date_add(dateStart, INTERVAL 1 DAY); END WHILE;END;//
这是使用它的SQL小提琴：http
://sqlfiddle.com/#!2/66f86/1
