mysql日常sql

最新推荐文章于 2020-09-02 18:50:53 发布

转载最新推荐文章于 2020-09-02 18:50:53 发布 · 49 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/qq917937712/p/7649622.html

文章标签：

#数据库

重置表

truncate table david_account;

触发器

/* 商户资料更新时更新终端 */
DELIMITER |
CREATE TRIGGER
    bankChange
AFTER UPDATE
    ON david_bank
FOR EACH ROW
    BEGIN
        /*
        declare termC int;
        set termC = (select count(*) as nums from david_terminal where mer_id=new.mer_id);
        if termC<=1 then
            update david_terminal set
                main_tel = new.main_tel,
                sale_type_id = new.sale_type_id
            where mer_id=new.mer_id;
        end if;
        */
        update david_account set
            bank_name = new.name
        where bank_id=new.cut_no;

        if(new.channel_no = '016') then
            insert into rpt_charge set `month`=new.`month`,channel_no = new.channel_no,term_no=new.term_no;
        elseif(new.channel_no = '018') then
            insert into rpt_charge set channel_no = new.channel_no,term_no=new.term_no;
        end if;

    END
|
DELIMITER ;