简单的mysql存储过程，批量插数据

drop PROCEDURE IF EXISTS insertLabel;
CREATE PROCEDURE insertLabel (in size int)
  BEGIN
    DECLARE i int;
    DECLARE label_name VARCHAR(100);
    DECLARE label_value VARCHAR(10);
    set i = 0;
    WHILE i<size DO
      set label_value = floor(RAND() * 10000000000);
      set label_name = CONCAT('TEST-',label_value);
      INSERT into t_label_info (merchant_code, label_name,
                                         label_value, reserve1,
                                         label_type,label_state)
      values('0313432',label_name,label_value,'批量测试','01','00');
      set i =i+1;
    END WHILE;
  COMMIT ;
  END;

--  执行
call insertLabel(10000);