求教MySql函数问题: ?

Question

CREATE OR REPLACE FUNCTION FUN_GETBRNAME (pbrno varchar)
returns varchar(80)
begin
declare @pbrname varchar(80);
set @pbrname = select br_name from TBL_ORG_DEPARTMENTS where br_no = pbrno;
return @pbrname;
end;
这个找不到哪里有错误，请大神指正。

Answer 1

CREATE OR REPLACE FUNCTION FUN_GETBRNAME (pbrno varchar)returns varchar(80)begindeclare @pbrname varchar(80);select br_name into @pbrname from TBL_ORG_DEPARTMENTS where br_no = pbrno;return @pbrname;end;CREATE FUNCTION FUN_GETBRNAME (pbrno varchar(80))     returns varchar(80)  begin    declare pbrname varchar(80);     select br_name  into pbrname  from TBL_ORG_DEPARTMENTS where br_no = pbrno;    return pbrname; end;

Answer 2

这句错了，直接改成select @pbrname = br_name from TBL_ORG_DEPARTMENTS where br_no = pbrno;