比如你要删除 aa 记录 (假设字段名称为 field)插入 aa 记录(注意, 只是一条)至临时表 temp 中 insert into temp Select distinct * from tbl where field = aa从tbl表中删除所有 aa的记录 delete from tbl where field = aa再复制回去 insert into tbl select * from temp where field = aa
TO huwei001982(編程浪子) ( 你的意思是便利数据库,先删除当前记录,再插入尾部??如此循环吗?
晕, 你到底是要删除全部重复的, 还是删除指定内容重复如果是删除全部重复的, 你将我的代码后面的 where field = aa去掉就行另: 并不是遍历数据库, 是用 Sql 语句, 就上面三行就行
我要删除所有重复的,但留下一个,比如原来数据是 aa bb cc aa 删除后成了 aa bb cc
insert into temp Select distinct * from tbldelete from tblinsert into tbl select * from tempOK
同意楼上。insert into temp Select distinct * from tbldelete * from tblinsert into tbl select * from tempOK
SELECT DISTINCT表临时表
DELETE
将临时表的数据再反过来插入这个表。
insert into temp Select distinct * from tbl where field = aa从tbl表中删除所有 aa的记录
delete from tbl where field = aa再复制回去
insert into tbl select * from temp where field = aa
aa
bb
cc
aa
删除后成了
aa
bb
cc
哈哈~!