sql批量插入，遇到重复更新

@Insert("<script>" +
            "insert into `test_table` "
            +" (`biz_type`, `region_id`, `az_id`, `ecs_category_3`, `ecs_category_3_en`, "
            +" `is_close_limit`,`cycle_available_count`,`cycle_sale_rate`,`cycle_turnaround_days`,`status`,"
            +" `gmt_create`,`gmt_modified`) "
            + "values ("
            +"<foreach collection=\"opsResourceDumpings\" item=\"item\" separator=\",\" >"
            +" #{item.bizType}, #{item.regionId}, #{item.azId}, #{item.ecsCategory3},#{item.ecsCategory3en},"
            +" #{item.isCloseLimit},#{item.cycleAvailableCount},#{item.cycleSaleRate},#{item.cycleTurnaroundDays},#{item.status},"
            +" now(), now()"
            +"</foreach>"
            +")"
            +"on duplicate key update is_close_limit=values(is_close_limit),cycle_sale_rate=values(cycle_sale_rate),"
            +"cycle_turnaround_days=values(cycle_turnaround_days),cycle_available_count=values(cycle_available_count),status=values(status),gmt_modified=now()"
            +"</script>")
    Integer batchAdd(@Param("opsResourceDumpings")List<OpsResourceDumpingDO> opsResourceDumpings);

注：不可设置主键自增