#1、oracle 插入数据存储过程
create or replace procedure test_for_loop_oracle2 as
i number := 0;
j number := 0;
BEGIN
for j in 1 .. 4 loop
for i in 1 .. 50000 loop
INSERT INTO cmis_cx.wktest VALUES (i);
commit;
end loop;
DBMS_LOCK.SLEEP(3);
end loop;
END;
执行存储过程
begin
test_for_loop_oracle2;
end;
#2、mysql 插入数据存储过程
DROP PROCEDURE IF EXISTS test_for_loop_mysql;CREATE PROCEDURE test_for_loop_mysql()
BEGIN
DECLARE aa INT DEFAULT 0; # 定义变量 默认值为0
loopName:LOOP # 循环开始:loopName 定义循环名
SET aa = aa + 1; # 设置变量自增
#select sleep(1); #每一秒插入一条
INSERT INTO `test_03s` VALUES ('2020-06-03', '2020-06-03', 'addr1', 'test_01');
IF aa >= 100 THEN # loop 需要设置跳出条件,不然会变成死循环
LEAVE loopName; # 结束循环
END IF; # 结束if 语句
END LOOP; # 结束loop 循环语句
END;
#执行存储过程:
CALL test_for_loop_mysql();