使用存储过程的WHILE循环语句+IF语句+mod函数,WHILE是小于多少次,IF是提交的条件。这里只是举例循环30次,能被2整除时就commit。
-- 插入接口表数据
DECLARE
I INT;
BEGIN
I := 0;
WHILE (I < 30) LOOP
I := I + 1;
insert into tl_imt_sms_content
(VC2CONTENT,
NUMMESSAGEFORMAT,
NUMSENDMETHOD,
NUMPRIORITY,
DATSTART,
DATEND,
DATCREATE,
NUMSTATE,
NUMTYPE,
NUMTYPELIST,
NUMSOURCENUN,
NUMSENDBATCH,
NUMID,
VC2MOBILE,
VC2SRCNUMBER,
NUMCONTENTID,
NUMMOSEQID,
VC2RESERVE1,
NUMBLACKFLAG)
values
('NUMBLACKFLAG33',
32,
1,
3,
sysdate,
sysdate + 1,
sysdate,
0,
1,
10,
'11',
231168371,
579614613,
'15881297563',
'',
-101,
null,
'002@215856',
0);
IF mod(i,2)= 0 THEN
COMMIT;
END IF;
END LOOP;
COMMIT;
END;