mysql存储过程procedure

传送门

http://www.blogjava.net/sxyx2008/archive/2009/11/24/303497.html

 

set @count = (SELECT count(1) from t_b_cardgroup WHERE t_u_user_id=126);
DROP PROCEDURE  IF  EXISTS judgeGroup;
 delimiter //
CREATE PROCEDURE judgeGroup(INOUT p int)
BEGIN
    SELECT p;-- p=0
      if p=0 then 
            SELECT 111 from dual;
        else SELECT 222 from dual;
        end if;
end
//
CALL  judgeGroup(@count);