Mysql 触发器语法

63 阅读 0 评论 42 点赞

我是靠谱客的博主精明衬衫，最近开发中收集的这篇文章主要介绍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