mysql删除重复语句问题
以前用sql server 现在改用mysql数据库，发现同一句语句在sql server里能使用，到了mysql里就报这种错误了[Err] 1093 - You can't specify target table 'KSOthers' for update in FROM clause
sql server 语句如下
DELETE FROM KSOthers
WHERE (id NOT IN
(SELECT MIN(id) AS Expr1
FROM KSOthers AS KS_1
GROUP BY Kid)) or (Kvicinity not like '%昆山市%')
哪位大侠能帮我改成mysql里面的删除重复语句啊
[解决办法]
delete from KSOthers where kid in
(select kid from KSOthers group by kid having count(kid) > 1)
[解决办法]
先查 看能不能查到你要的结果
[解决办法]
4、删除表中多余的重复记录（多个字段），只留有rowid最小的记录
delete from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
http://unix-cd.com/vc/www/26/2007-07/6099.html
