DELETE m FROM test.`tb1` m
JOIN
(SELECT id,val FROM test.`tb1` GROUP BY id,val HAVING COUNT(*)>1 ) n
ON m.`id` = n.id AND m.`val`= n.val;
JOIN
(SELECT id,val FROM test.`tb1` GROUP BY id,val HAVING COUNT(*)>1 ) n
ON m.`id` = n.id AND m.`val`= n.val;
解决方案 »
- 怎么用sql语句根据ID逐条替换内容?
- mysql 建表 关联外键时 error 1005
- mysql中因文本太长,无法插入数据如何解决?求高手指点
- 高分请教:怀疑数据库问题造成的网站打开过慢!
- 三表组合查询问题。
- mysql客户端使用中 source 命令无效,是什么原因??
- 在linux安装mysql怎么一点反映也没有。
- apache php mysql 的安装和配置
- 求问数据库中where语句是怎么实现的
- 请各位大侠,帮忙看一下下面触发器Before Insert 语句是否会引起死锁问题?
- 关于存储过程的数据类型问题
- mysql的start transaction能否 自动设置autocommit=0
select *
from tbname A
where not exists (select 1 from tbname where A.username=username and A.contentText=contentText A.id>id);drop table tbname;
alter table tbname1 rename tbname;
这些字段,求详细呀你那段语句我不知道怎么修改
2 2
3 4
3 4
把 第二行和第三行 都删掉
你的需求是这样?
JOIN
(SELECT id,val FROM test.`tb1` GROUP BY id,val HAVING COUNT(*)>1 ) n
ON m.`id` = n.id AND m.`val`= n.val ;不是临时表,内存表。。
JOIN
(SELECT id,val FROM test.`tb1` GROUP BY id,val HAVING COUNT(*)>1 ) as n
ON m.`id` = n.id AND m.`val`= n.val ;
JOIN
(SELECT id,val FROM bigdata_comment GROUP BY UserName ,ContentText HAVING COUNT(*)>1 ) as n
ON m.UserName = n.UserName AND m.ContentText=n.ContentText;
JOIN
(SELECT UserName ,ContentText FROM bigdata_comment GROUP BY UserName ,ContentText HAVING COUNT(*)>1 ) as n
ON m.UserName = n.UserName AND m.ContentText=n.ContentText; 你对SQL 完全空白啊
这样的话,用你那个语句的话会把重复的一块删除了只会留下一个dd ff 我要的是删除之后留下的是
dd ff
aa bb
能不能这样啊???
JOIN
(SELECT ID, UserName ,ContentText FROM bigdata_comment GROUP BY UserName ,ContentText HAVING COUNT(*)>1 ) as n
ON m.UserName = n.UserName AND m.ContentText=n.ContentText
where m.ID != n.ID; id 是唯一主键吧,是的话就这个