mysql的存储过程

一.存储过程

二.例子

-- in的存储过程
CREATE PROCEDURE sp2(IN id INTEGER)
BEGIN
delete from employee where eid=id;
END
call sp2(2)

-- 带有in ,out参数的存储过程
create PROCEDURE sp3(IN id INT,OUT nums INT)
BEGIN
delete from employee where eid=id;
select COUNT(eid) from employee into nums;
END
CALL sp3(4,@nums);
select @nums;

delete from employee where deptid=2;
select ROW_COUNT();

-- 创建带有多个out的存储过程

DROP PROCEDURE sp4;
create PROCEDURE sp4(IN id INT,OUT updateNums INT,OUT countNums int)
begin
delete from employee where deptid=id;
select ROW_COUNT into updateNums;
select COUNT(eid) from employee into countNums;
END;
CALL SP4(3,@a,@b);
SELECT @a;
select @b;