mysql去除重复数据删除重复数据只保留一条数据

delete from new_content where id not in ( select min_id from ( select min(id) as min_id from new_content group by content ) as tmp );