make dates

gistfile1.sql

delimiter $$

drop procedure if exists make_dates $$
CREATE PROCEDURE make_dates( max_recs int)
begin
  declare start_dt datetime;
  declare numrecs int default 1;
  set start_dt = date_format( now() - interval max_recs minute, '%Y-%m-%d %H:%i:00');

  insert into Couvert (user_id, date, value, created) values (1, start_dt, 3.9, now() );

  while numrecs < max_recs
  do
      insert into Couvert (user_id, date, value, created)
          select 1, date + interval ( numrecs ) day,3.9, now() 
          from Couvert;
      select count(*) into numrecs from Couvert;
      select numrecs;
  end while;
end $$

delimiter ;