原语句
delete from news where id in(select max(id) from news group by title having count(title)>1)
出错
更改后语句
delete from long_news where id in(select a.id from (select max(id) id from long_news group by title having count(title)>1) a)
正确!
update link set web_nav='' where id in(select * from (select id from news_type web_nav='' and fid<>0) as t)
感谢夜yi深 提供思路
http://blog.sina.com.cn/s/blog_631b01470100gn6k.html