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);
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);