mysql存储过程实现表中插入10000条数据

 1 DELIMITER $$
 2 CREATE  PROCEDURE insert_many_i_data()
 3 BEGIN
 4     DECLARE i INT;
 5     SET i=0;
 6     WHILE i <10000 DO
 7         SET i=i+1;
 8         INSERT INTO account(accountid,balance) VALUES(i,1);
 9     END WHILE;
10 END$$

 1 DELIMITER $$
 2 CREATE  PROCEDURE insert_repeat_data()
 3 BEGIN
 4     DECLARE i INT;
 5     SET i=0;
 6     REPEAT
 7         SET i=i+1;
 8         INSERT INTO account(accountid,balance) VALUES(i,1);
 9     UNTIL i <10000 
10     END REPEAT;
11 END$$

DELIMITER $$
CREATE  PROCEDURE insert_loop_data()
BEGIN
    DECLARE i INT;
    SET i=0;
    loop_name:LOOP    
                SET i=i+1;
                INSERT INTO account(accountid,balance) VALUES(i,1);
                IF i <10000  THEN
                  LEAVE loop_name;
                END IF;
              END LOOP;
END$$