sql 循环添加数据+时间生成

CREATE DEFINER=root@% PROCEDURE NewProc()
BEGIN
DECLARE
i INT;

SET i = 1;
WHILE
i < 100 DO
INSERT INTO a ( NAME, date, insetid, datea )
VALUES
(
i,
FROM_UNIXTIME(
UNIX_TIMESTAMP(
DATE_ADD(
DATE_ADD( ‘2021-01-01 10:00:00’, INTERVAL FLOOR( 1+ RAND( ) * 28800 ) SECOND ),
INTERVAL FLOOR( 1+ RAND( ) * 60 ) DAY
)
),
‘%Y-%m-%d %T’
),
‘maifang’,
FROM_UNIXTIME(
UNIX_TIMESTAMP(
DATE_ADD(
DATE_ADD( ‘2021-01-01 10:00:00’, INTERVAL FLOOR( 1+ RAND( ) * 28800 ) SECOND ),
INTERVAL FLOOR( 1+ RAND( ) * 60 ) DAY
)
),
‘%Y-%m-%d’
)
);

SET i = i + 1;

END WHILE;

END