请问如何在informix的存储过程中加入循环语句?

2025-03-23 04:16:36
推荐回答(1个)
回答1:

create procedure inserttest(numrows int)
define i int;
let i=0;
while i< numrows
insert into test values(i,i+1,i*3);
let i=i+1;
delete test where a=i;
end while
end procedure;
适当的地方你改一下吧