【mysql】函数样例 桃扇骨 2022-08-21 10:37 139阅读 0赞 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
还没有评论,来说两句吧...