RT 表中ID 唯一, name存在重复 如何删除name重复的记录 保留一条数据
解决方案 »
- 问一个关于UPDATE的语法问题
- MYSQL、InnoDB及NoSQL的一些问题
- 求mysql一个数字对比的查询sql写法
- mysql数据导出和编码转换
- 8G单表如何处理
- 数据库设计问题,如何实现内容国际化...
- window2003下安装postgres: Install as aservice: 登陆失败!未知用户名或密码
- HttpLink='stop'+HttpLink对应的MySQL应该怎么写? 谢谢~~~
- 安装方维公开课系统的时候,文件上传完打开后报错
- 怎么将name的值格式化更新到name2字段中去?
- 请教一个问题,期待过来人给带你建议……
- 高分请教如何终止mysql正在执行的任务
delete from tt a where not exists(select 1 from tt where a.name=name and a.id>id)
delete tt from tt inner join (select name,min(id) as mi from tt) b
on tt.name=b.tt and tt.id>b.mi
delete tt from tt inner join (select name,min(id) as mi from tt group by name) b
on tt.name=b.name and tt.id>b.mi
delete a from table1 a left join (select min(id) from table1 group by name) b on a.id=b.id where b.id is null
select id from t a where exists(select 1 from t where a.name=name and a.id >id)delete t from t,asd1
where t.id =asd1.id