DELIMITER
    CREATE TRIGGER TR_JST_TRADE_INSERT AFTER INSERT ON TB_JUSHITA_TRADE FOR EACH ROW
    BEGIN
    DELETE FROM TB_JUSHITA_TRADE_TODAY WHERE DATE(import_date)INSERT INTO TB_JUSHITA_TRADE_TODAY SELECT FROM TB_JUSHITA_TRADE WHERE id=new.id;
    UPDATE TB_JUSHITA_TRADE_TODAY SET edb_json=(SELECT edb_json FROM jdp_tb1_trade WHERE tid=new.out_tid) WHERE id=new.id;
    UPDATE TB_JUSHITA_TRADE_TODAY SET IS_IMPORTED=(SELECT COUNT(    ) FROM vw_jushita_trade_pre WHERE out_tid=new.out_tid ) WHERE id=new.id;
    END