mysql存储过程批量提交

 

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

CREATE DEFINER=`hxl`@`%` PROCEDURE `sp_insert_data`() BEGIN     #Routine body goes here...   declare i INT default 0;     set i = 0;     set autocommit = 0;     while i <= 1000000 do         set i = i+1;       insert into tb_test(name1,name2,name3) values(concat('nameA',i),concat('nameB',i),concat('nameB',i));     if mod(i,10000)=0 THEN        commit;               ##select sleep(10000);         end if;         ##select i;     end while;     commit; END