mysql存储过程批量插入数据
2020-10-28 本文已影响0人
boyiis
delimiter $$$
DROP PROCEDURE IF EXISTS zqtest;
create procedure zqtest()
begin
declare i int default 0;
set i=0;
start transaction;
while i<80000 do
//your insert sql
set i=i+1;
end while;
commit;
end
$$$
delimiter;
call zqtest();
