查询出表中重复数据
select word,max(id) mid from test group by word having count(*) > 1
删除重复数据中的一条,保留重复数据中id大的数据
delete i from test i, (select word,max(id) mid from test group by word having count(*) > 1) d
where i.id
查询出表中重复数据
select word,max(id) mid from test group by word having count(*) > 1
删除重复数据中的一条,保留重复数据中id大的数据
delete i from test i, (select word,max(id) mid from test group by word having count(*) > 1) d
where i.id