delete Tabel where
id not in (
select id=min(id)
from Tabel
group by name,value,valu2
)
id not in (
select id=min(id)
from Tabel
group by name,value,valu2
)
解决方案 »
- Mysql 插入临时表is full 怎么动态设置临时表大小
- ?my.cnf有关binlog 和innodb 设置的参数
- mysql 启动不了。救命呀。。
- 我想在64位的ubuntu系统上安装一个带federated引擎的5.1.46版本的Mysql,该下载哪个版本?怎么安装?
- 在PostgreSQL中如何用SQL语句得到当前连接的进程ID?
- pear报insufficient data supplied错,怎么回事
- 如何对mysql5.0中的boolean字段附值?
- 小弟只有10分了,怎么样能把.sql文件导入mysql服务器中?
- PostgreSQL user defined function 错误排出,谢谢
- 怎样把一个select 语句的查询结果写到一个文件中.
- 求一 mysql 查询语句!
- 请问这个sql语句哪里有问题???
you can't specify target table 'fd_item' for update in from clause.thanks
truncate yourtable;
insert into yourtable select * from tmp order by id;
drop table tmp;
select ..,min(id) group by where having count(*)>1
union
select .. group by where having count(*)=1到一个表中,再删除解决了.