mysql 批量插入数据

DROP PROCEDURE IF EXISTS proc_initData;--如果存在此存储过程则删掉
DELIMITER ;; -- 设置mysql的分隔符为;; CREATE PROCEDURE test_insert()

BEGIN

DECLARE i INT DEFAULT 10000162;

WHILE i<=10001152
DO
insert into exchange_user_bank (`userId`, `bankName`, `name`, `province`, `city`, `branchName`, `cardNo`, `createTime`, `updateTime`, `deleted`)
values (i, '平安银行', '张三', '', '', '大冲支行', 'fQ0OsOZEQxbsCnFf6sypgCOBdQACt+2q3zsaWuOc7Sc=', '1528082036', '1528775923', '2');
SET i=i+1;
END WHILE ;
commit;

END;;

CALL test_insert();   -- 调用存储过程