删除重复记录，只保留一条delete from `tieba` where id in (select id from (SELECT *,count(`name`) as n
删除重复记录，只保留一条
delete from `tieba` where id in (select id from (SELECT *,count(`name`) as num FROM `tieba`group by `name`) as b where num>1)
删除重复记录，只保留一条
delete from `tieba` where id in (select id from (SELECT *,count(`name`) as num FROM `tieba`group by `name`) as b where num>1)