mysql 自定义函数

create function getTravelLeader(travelidin Varchar(12))
       returns Varchar(12)

       READS SQL DATA

BEGIN
     DECLARE travelLeader Varchar(12);

     select leaderid Into travelLeader From t_travelinfo Where travelid = travelidin ;

     return travelLeader;

end;

 

 

create function getMemberNum(travelidin Varchar(12))

returns int

READS SQL DATA 

begin

     DECLARE memberNum int;    

     select Count(*) Into memberNum From t_travelmembers Where travelid = travelidin And statusflag = 1 ;

     return memberNum;

end;