mysql循环插入数据

1、建立表结构

2、循环插入sql

DELIMITER //
DROP FUNCTION IF EXISTS `generate_order_with_given_number`//
create FUNCTION `generate_order_with_given_number`(p_quantity INT) RETURNS INT
BEGIN
DECLARE i INT DEFAULT 0;
while i< p_quantity do
SET i=i+1;
INSERT INTO test(`name`,`desc`) values(concat("xxxx",i), concat("xxxx", i));
end while;
RETURN 0;
END//
SELECT generate_order_with_given_number(30)//
SELECT * FROM `test`//
DELIMITER ;

执行