擅长:python、mysql、java
<p>在python中比较新旧协作者列表对我来说有点困难</p>
<pre><code> original_list = ["C1","C2","C3","C4"] // result from query
updated_list= ["C1","C6","C7"] // list obtained from request
# compute the differences
to_be_added = set(updated_list).difference(set(original_list) )
to_be_deleted = set(original_list).difference(set(updated_list) )
</code></pre>
<p>然后我在事务中使用insert和delete语句,使用上面两个列表进行更新</p>