mysql 创建存储过程插入测试数据

做项目过程中遇到需要插入有序的测试数据，不想写php循环，网上找到方法，复习了一遍存储过程了哈哈。 SQL语句参考自 https://stackoverflow.com/questions/26981901/mysql-insert-with-while-loop

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;