1 delimiter $$ 2 create PROCEDURE addDate3(i INT) 3 BEGIN 4 set i=1; 5 WHILE i<=10000 DO 6 INSERT INTO test1(name) VALUES ("测试"); 7 SET i = i + 1; 8 END WHILE; 9 END $$