mysql存储过程

MySql存储过程初识<br>1.创建存储过程<br>create procedure myproc()<br>  begin<br>    declare num int;<br>    set num=1;<br>    while num <= 10000000 do<br>      insert into tbl_store_order_revoke_info12(id,shopRefuseCase,revokeCase) values(num, CONCAT(num ,‘@qq.com‘), MD5(num));<br>      set num=num+1;<br>    end while;<br>  end;

2.调用存储过程<br>call myproc();<br>3.删除存储过程<br>drop procedure myproc ;<br>4.查询结果<br><em id="__mceDel"><em id="__mceDel"><em id="__mceDel">select count(*) from tbl_store_order_revoke_info;</em></em></em>

<em id="__mceDel"><em id="__mceDel"><em id="__mceDel"> </em></em></em>

mysql存储过程

标签：sel   roc   case   查询   usecase   cat   procedure   count   创建