【mysql】函数样例

BEGIN

#declare ROOM_COMBO varchar(32);   

#单行注释

declare  DECORATION_TEXT varchar(32);

if ITEM_DECORATION = '00' then

SET DECORATION_TEXT = '毛坯';

elseif ITEM_DECORATION='01' then

SET DECORATION_TEXT = '简装';

elseif ITEM_DECORATION='02' then

SET DECORATION_TEXT = '普装';

elseif ITEM_DECORATION='03' then

SET DECORATION_TEXT = '豪装';

else 

SET DECORATION_TEXT = '其他';

end if;

return DECORATION_TEXT;

END

参数：ITEM_DECORATION varchar(32),DECORATION_TYPE varchar(32)

返回类型：varchar(32)

类型：FUNCTION