根据redit_url 去重,删除uid较小的字段
delete from spider where uid in (select uid from (select min(uid),count(*) as c from spider group by redit_url having c>1)as t)
根据redit_url 去重,删除uid较小的字段
delete from spider where uid in (select uid from (select min(uid),count(*) as c from spider group by redit_url having c>1)as t)