mysql 批量插入数据千万条

drop procedure if exists GetAllProducts;

DELIMITER //
 CREATE PROCEDURE GetAllProducts()
   BEGIN
     
DECLARE i INT;
set i=2;
WHILE i<10000000
DO 
     insert into tbl_dept_pro(dept_id,orgcode,weburl,dbdriver,dburl,dbname,servername,serverip,create_on) values
('1','1001','http://www.baidiu.com','mysql','jdbc:mysql:','tms','test','192.168.0.0.1',now());

SET i=i+1; 
END WHILE ; 
commit; 
   END //

 
call  GetAllProducts();

 

转载于:https://my.oschina.net/mellen/blog/3097683