mysql删除重复记录且只保留1个
delete from 表名 where 字段 in (
SELECT a.字段 from( select 字段 from 表名 group by 字段 having count(1) > 1 ) a ) and 自增主键 not in (
SELECT b.id from( select max(自增主键) as id from 表名 group by 字段 having count(1)>1 ) b )
数据去重,表中重复的数据只保留1个
delete from 表名 where 字段 in (
SELECT a.字段 from( select 字段 from 表名 group by 字段 having count(1) > 1 ) a ) and 自增主键 not in (
SELECT b.id from( select max(自增主键) as id from 表名 group by 字段 having count(1)>1 ) b )
数据去重,表中重复的数据只保留1个