Question

用sql写个脚本,向数据库插入10000条记录,每5条提交一次

Answer 1

create table test(id int);
declare
begin
for i in 1..10000 loop
insert into test values(i);
if mod(i,5)=0 then
commit;
end if;
end loop
end;