MySQL:
创建存储过程:
create procedure my_procedure()
begin
declare i int default 0;
set i=0;
while i<500000 do
INSERT INTO `log` (`ID`, `TIME`) VALUES (i, '2017-11-25 14:07:45');
set i=i+1;
end while;
end;
删除存储过程:
drop procedure my_procedure;
执行存储过程:CALL my_procedure
Oracle
插入存储过程:
在plsql developer上执行,不要用Navicat,有bug
create or replace procedure proc_insert as
--i NUMBER(10);
begin
for i in 1..500
loop
INSERT INTO OPERATION_LOG (ID,TIME,TYPE,OBJECT_ID,OPERATOR,ORGANIZATION_ID,CHANNEL_ID,MERCHANT_NO,TERMINAL_NO,CARD_NO,BIZ_TYPE_CODE,OPERATION_CONTENT,ERROR_CODE,ERROR_MESSAGE,REMARK1,REMARK2,RESULT)VALUES
(i,TO_DATE ('2017-09-13 20:02:42','SYYYY-MM-DD HH24:MI:SS'),'insertOperator',
'201709132002429094234343427887','superAdmin',' ',NULL,NULL,NULL,NULL,NULL,
'201709132002429094234343427887',NULL,NULL,NULL,NULL,'1');
commit;
end loop;
end;
DB2
插入存储过程:
--/
CREATE OR REPLACE PROCEDURE abc
begin
declare i integer ;
set i=1;
while i<5 do
INSERT INTO OPERATION_LOG (ID, TIME) VALUES (i, current timestamp);
set i=i+1;
end while;
END
/
执行存储过程:call test4()
删除存储过程: drop procedure test4()
DB2注意:
第一:不能有as
第二:最后一行的/必须顶格(重要)
第三:变量定义的方式
将declare i default integer 1;中的default和integer调换一下位置
或者使用set