mysql存储过程模拟插入不同日期时间数据

DROP PROCEDURE IF EXISTS insertDaKa; 
create procedure  insertDaKa(OUT result datetime)
begin
DECLARE i int; 
DECLARE EDate datetime default '2018-07-07';
DECLARE ETime datetime;
 SET EDate = '2018-07-07';        
 SET ETime = '2018-07-07 15:58:49';
set i = 1;


while i<50 do
set EDate = DATE_SUB(EDate,INTERVAL 1 DAY);  -- 时间减去一天
set ETime = DATE_SUB(ETime,INTERVAL 1 DAY);  -- 时间减去一天
insert into t_efen_activity_detail values('00','7', EDate, '1', '0', '10', null, '7', ETime, null, null, null, '1');
 set i = i+1;
    -- SELECT  ETime into result;
    end WHILE;
end;;


call insertDaKa(@result);