MariaDB的存储过程和函数

创建存储过程

DELIMITER $$
DROP PROCEDURE IF EXISTS `sp_test1`;
CREATE PROCEDURE sp_test1(IN a int, IN b int, OUT sum 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 sum  = a + b;
END; $$
DELIMITER ;DELIMITER $$
DROP PROCEDURE IF EXISTS `