手机浏览 RSS 2.0 订阅 膘叔的简单人生 , 腾讯云RDS购买 | 超便宜的Vultr , 注册 | 登陆

mysql子查询删除

首页 > DataBase >

Submitted by gouki on 2011, October 15, 6:06 PM. DataBase

这是我试了很多的代码之后才。。。。
#select id,count(1) as cnt from feeds_datas group by link HAVING count(1) > 7 order by cnt DESC
#delete from feeds_datas where link = (select link from feeds_datas WHERE id in ()
#delete from feeds_datas where id in (6697,7127,6798,4557,4558,6086,6087,6088,6089)
#select id from feeds_datas group by link HAVING count(link) > 1

#delete from feeds_datas as a WHERE a.in in (select b.id from feeds_datas as b group by b.link HAVING count(b.link) > 1 )
#delete from feeds_datas t1,(select link from feeds_datas group by link HAVING count(1) > 1) t2 where t1.link = t2.link

#and id not in (select min(id) from  feeds_datas  group by link  having count(link )>1)

delete feeds_datas as a from feeds_datas as a,
(
select *,min(id) from feeds_datas group by link having count(1) > 1
) as b
 where a.link = b.link and a.id > b.id;

加#的都是失败的，其中最后一条SQL我很纳闷，如果把delete 后面的 feeds_datas as a去掉，那么sql就报错，说是不许right syntax之类的。加上就OK。
记录一下。。
网上有很多资料，可以参考：
1、http://yueliangdao0608.blog.51cto.com/397025/81390
2、http://zhidao.baidu.com/question/85817899



本站采用创作共享版权协议, 要求署名、非商业和保持一致. 本站欢迎任何非商业应用的转载, 但须注明出自"易栈网-膘叔", 保留原始链接, 此外还必须标注原文标题和链接.

Tags: mysql, 子查询, 删除

« 上一篇 | 下一篇 »

只显示10条记录相关文章

慎用mysql的enum字段 (浏览: 57683, 评论: 1)
mysql:Lost connection to MySQL server at 'reading initial communication packet', system error: 0 (浏览: 43529, 评论: 2)
超详细：在Mac OS X中配置Apache ＋ PHP ＋ MySQL (浏览: 41866, 评论: 1)
联合索引的经典例子 (浏览: 37856, 评论: 1)
在mysql 里实现查询汉字的拼音首字母[摘] (浏览: 37059, 评论: 4)
MySQL各存储引擎(INNODB,MyISAM等)的区别及其启动方法 (浏览: 35527, 评论: 0)
Mysql分区表局限性总结 (浏览: 34792, 评论: 0)
MYSQL索引之小小分析 (浏览: 34277, 评论: 3)
MySQL 5 中 blob 类型字段的插入[转] (浏览: 34148, 评论: 0)
用TIMESTAMP类型取代INT和DATETIME[转] (浏览: 33077, 评论: 1)

1条记录访客评论

delete feeds_datas as a from feeds_datas as a  
费解

Post by wang on 2011, October 15, 10:34 PM 引用此文发表评论 #1


发表评论

评论内容 (必填):