Mysql 触发器语法

Mysql触发器语法和Oracle不一样, if用法相当于Oracle的nvl()函数

CREATE DEFINER=`mdmdev`@`%` TRIGGER T_WLMY_SEND_BY_ZZJBMY
BEFORE INSERT ON MDM_KSTEMP_CODE FOR EACH ROW
  BEGIN
        SET NEW.DESC12 = NEW.CODE;
        -- 设置客商类别
        SET NEW.DESC17 = IF( new.DESC2 LIKE '%银行%', 'Z007', IF(NEW.DESC15 LIKE 'CN','Z002','Z003'));

    UPDATE mdm_kstemp_codevalue
    SET PROPERTYVALUE =(IF( new.DESC2 LIKE '%银行%', 'Z007', IF(NEW.DESC15 LIKE 'CN','Z002','Z003')))
    WHERE
        propertycode = 'KSFL'
        AND codeid = new.codeid;

        -- 设置编码
        UPDATE mdm_kstemp_codevalue
    SET PROPERTYVALUE = NEW.CODE
    WHERE
        propertycode = 'KSBH'
        AND codeid = new.codeid;     

  END