oracle 与 mysql 存储过程实例

chaomeili

举两个实例，来说明存储过程比较实际一点。。
oracle (10g):
create or replace procedure aabb as
begin
     for i in 1..200 loop
     insert into ta(id,name,telephone,address)
     values(i,'aa','12345','abcd')
     end loop;
     commit;
end;
/
call aabb();

mysql:
带参数
delimiter //
drop procedure if exists abc;
create procedure abc(in n bigint)
begin
     select * from test where id=n;
end //
delimiter;
set@n=1;
call abc(@n)
不带参数
delimiter //
drop procedure if exists cnumber;

create procedure cnumber()
begin
     declare i int;
     set i=0;
     where i<=1000 do
          insert into tb(code ,name)values
          (10000+i,concat('aaa',100+i));
     set i=i+1;
     end while;
end //
delimiter;
call cnumber();