DELIMITER //
CREATE PROCEDURE test2(IN savetime DATETIME,IN Y INT(10),IN t INT(10))
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i< Y DO
INSERT INTO t_date (
t_date,
t_time
)
VALUES
(
savetime,
savetime
) ;
SET i = i +1;
SET savetime = DATE_ADD(savetime,INTERVAL t SECOND); //等量时间间隔递增
SET savetime = DATE_SUB(savetime,INTERVAL t SECOND); //等量时间间隔递减
END WHILE;
END
CALL test2('2020-01-01 00:00:00',20,10);