drop function getName;
create function getName(nam varchar(20)) returns varchar(20) begin declare na varchar(20); select tele into na from stu where Name=nam ; if substring(na,1,1)='1' set na='guo'; else set na='pengtao'; return na; end ; select getName('李明');
drop function getfun; create function getfun() returns varchar(20) begin declare na varchar(20); declare nb varchar(20); declare temp varchar(20); set na='23123123'; if(substring(na,1,1)=2) then set temp='ok'; end if ; return temp; end;