DROP PROCEDURE IF EXISTS `insert`;

CREATE PROCEDURE `insert`(num int)
BEGIN
DECLARE i INT;
DECLARE var INT;
SET i=1;
WHILE i<num DO
    SET var=FLOOR(RAND()*10000000000);
    INSERT INTO table VALUES (var);
    SET i=i+1;
END WHILE;
END;
CALL insert(1000);