delimiter $$
CREATE PROCEDURE myproc()
BEGIN
DECLARE i int DEFAULT 9;
WHILE i <= 1000 DO
INSERT INTO test_tbl (test_url) VALUES (concat(‘https://test.com/test‘,i));
SET i = i + 1;
END WHILE;
END$$
delimiter ;
call myproc();
drop procedure myproc;
原文：http://blog.51cto.com/brucetam/2136705