表中存在的时候更新,
    不存在的时候 插入

    INSERT INTO t_member (id, NAME, email) VALUES
    (1, ‘nick’, ‘nick@126.com’),
    (4, ‘angel’,’angel@163.com’),
    (7, ‘brank’,’ba198@126.com’)
    ON DUPLICATE KEY UPDATE NAME=VALUES(NAME), email=VALUES(email);

    案例
    CREATE TRIGGER TR_INSERT_TB_TRADE AFTER INSERT ON jdp_tb_trade FOR EACH ROW

    INSERT INTO jdp_tb1_trade (tid,STATUS,TYPE,seller_nick,buyer_nick,created,modified,jdp_hashcode,jdp_response,jdp_created,jdp_modified,id,edb_json)
    SELECT tid,STATUS,TYPE,seller_nick,buyer_nick,created,modified,jdp_hashcode,jdp_response,jdp_created,jdp_modified,id,edb_json FROM jdp_tb_trade WHERE id=NEW.id
    ON DUPLICATE KEY
    UPDATE
    STATUS=VALUES(STATUS),
    TYPE=VALUES(TYPE),
    seller_nick=VALUES(seller_nick),
    buyer_nick=VALUES(buyer_nick),
    created=VALUES(created),
    modified=VALUES(modified),
    jdp_hashcode=VALUES(jdp_hashcode),
    jdp_response=VALUES(jdp_response),
    jdp_created=VALUES(jdp_created),
    jdp_modified=VALUES(jdp_modified),
    id=VALUES(id),
    edb_json=VALUES(edb_json);