create procedure wk() begin declare i int; set i = 1; while i < 5 do insert into t (myday) values (date_sub(curdate(),interval -i day)); -- select i; set i = i +1; end while; end $$
mysql 循环插入日期递增
原文：http://www.cnblogs.com/benlightning/p/4920097.html
