简单的mysql存储过程

来源：互联网发布：找不到windows update 编辑：程序博客网时间：2024/06/01 07:41

一个非常简单的mysql存储过程，写的时候注意语句定界符（不能是;）

计算两个数的和

delimiter $$  create procedure proc_add(in a int,in b int, out c 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;  end$$  delimiter ;

调用存储过程

call proc_add(1,2,@c);select @c;

结果

@c3

查看存储过程

show procedure status;

显示

DbNameTypeDefinerModifiedCreatedSecurity_typeCommentcharacter_set_clientcollation_connectionDatabase Collationevaluationproc_addPROCEDUREroot@localhost2014-04-17 20:02:102014-04-17 20:02:10DEFINER utf8utf8_general_cilatin1_swedish_cievaluationsp_addPROCEDUREroot@localhost2014-04-17 20:22:052014-04-17 20:22:05DEFINER utf8utf8_general_cilatin1_swedish_ci

查看存储过程创建过程

SHOW CREATE PROCEDURE proc_add

显示

Proceduresql_modeCreate Procedurecharacter_set_clientcollation_connectionDatabase Collationproc_add CREATE DEFINER=`root`@`localhost` PROCEDURE `proc_add`(in a int,in b int, out c int)
begin
if a is null then
set a = 0;
end if;
if b is null then
set b = 0;
end if;

set c = a + b;
endutf8utf8_general_cilatin1_swedish_ci

@c3

0 0