-- 查询两个表差集
SELECT actual_get_no,polno
FROM (
    SELECT t.actual_get_no,t.polno FROM tmp t
    UNION ALL
    SELECT tr.actual_get_no,tr.polno FROM tmp_right tr
) tbl
GROUP BY actual_get_no, polno
HAVING count(*) = 1;

-- 通过索引可以强制删除重复数据
alter IGNORE table supplier_protocol_risk_fee_rate
    add unique index uk_sup_risk_fee_rate (protocol_no, risk_code, pay_way, lower_policy_year, upper_policy_year,
                                           lower_pay_year,
                                           upper_pay_year);