主要是使用RAND() ,例如 RAND()*100 表示(0~100)之间的随机
话不多说,直接上代码:
DELIMITER ;;
drop procedure if exists test_insert;
create procedure test_insert()
begin
DECLARE i INT DEFAULT 1490544300;
DECLARE v INT DEFAULT 0;
WHILE i <= 1490630400
DO
select RAND()*100 into v;
insert into mytesttable(time, xid, power, mp, qu) values(i, 1, v, 0, 0);
SET i = i + 300;
END WHILE;
END
;;
CALL test_insert();
------------