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;