1、语法
显示所有存储过程 show procedure status
删除存储过程 drop procedure 名字
调用存储过程 call 名字();
创建例子:
delimiter $
create porcedure p2(n int)
begin
select * from goods where goods_number > n;
end$
//调用
call p2(10)
delimiter $
create porcedure p3(n int, j char(1))
begin
if j = 'h' then
select * from goods where goods_number > n;
else
select * from goods where goods_number > n
end if;
end$
//调用
call p3(10,'h')$
//计算 1-n 得和
delimiter $
create porcedure p4(n smallint)
begin
declare i int;
declare s int;
set i = 1;
set s = 0;
while i <= n do
set s = s +i;
set i = i + 1;
end while;
select s; //查询输出
end$
//调用
call p4(10)$