如何在MYSQL命令行创建存储过程.
delimiter //
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(1,2) //
一定加上"//"部分,否则要报错.