mysql处理重复数据

--mysql处理重复数据

创建临时表记录数据Id

create temporary table tempstudent(
cardid varchar(20),
count int
)

--cardid作为唯一判断查出重复数据记录到临时表

insert into tempstudent 
select cardid,count(*)
 from student group by cardid HAVING count(*)>1

select cardid,count(*)
 from student group by cardid HAVING count(*)>1
 

--再创建一个新临时表，用于记录要删除的记录
 create temporary table tempid(
id bigint
)
insert into tempid
 select max(id) from student where cardid in (select cardid from tempstudent)
 group by CardId
 select * from tempid
 
delete from student where id in(select id from tempid)