mysql删除重复数据，保留一条

mysql删除重复数据，保留一条

delete from data where id not in (select minid from (select min(id) as minid from data group by word) b);