mysql存储过程初级

delimiter//
drop PROCEDURE if EXISTS pr_add;//

create procedure pr_add (a int,b int)
begin
declare c int;
if a is null then
set a = 0;
end if;
if b is null then
set b = 0;
end if;
set c = a + b;
select c as sum;
end

call pr_add(10, 20);


    set @a = 10;
    set @b = 20;
    call pr_add(@a, @b);