MySQL批量增加100W数据

存储过程定义

CREATE PROCEDURE batchInsert(in number int) BEGIN declare i int default 1; start TRANSACTION; while i <= number DO #INSERT INTO base_user(open_id,pwd, user_desc, user_name, dept_open_id, user_status, user_type, deleted) VALUES (concat('sFtest', i),'Q5sPxaVInlo1WyBD2BjnueHlK0mRoSVu4kQts4HcjC7CKgWDDrcrsv7TQJKQ9Tcu', concat('sFtest', i), concat('sFtest', i), '48157172ad2744c7b303ec2775c55702', 1, -1, 0); #定义你自己的SQL set i = i+1; end while; COMMIT; end;

执行

call batchInsert(1000000);