5,889
社区成员
发帖
与我相关
我的任务
分享
create OR REPLACE procedure insertdb
language SQL
begin
declare vcount int;
declare vindex int;
declare p1 int;
declare p2 int;
declare p3 int;
set vcount=10;
set vindex=1;
set p1 = 100000000001;
set p2 = 200000000001;
set p3 = 300000000001;
LOOP
while (vindex < vcount)
do
insert into TORGANIC_NUMBER_17
( ORGANIC_NUMBER_ID,
ORGANIC_NUMBER,
ORGANIC_NUMBER_BATCH_ID)
values
(p1,p2,p3);
set vindex=vindex+1;
set p1=p1+1;
set p2=p2+1;
set p3=p3+1;
end loop ;
end;