摘要:
删除软件表中多余的重复记录,重复记录是根据单个字段(s_downloadurl)来判断,只留有sid最小的记录create table `temp` select s_downloadurl,min(sid) as sid from `software` group by 's_downloadurl' having count('s_downloadurl') > 1;delete from `software` where 's_downloadurl' in (select 's_downloadurl' from ` 阅读全文