摘要: 删除软件表中多余的重复记录,重复记录是根据单个字段(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 ` 阅读全文
posted @ 2013-09-22 15:44 飞鱼flyfish 阅读(200) 评论(0) 推荐(1) 编辑