Mysql删除重复数据

//查出所有的content唯一的最小idcreate table tmp as select min(id) as col1 from test group by content;//删除重复数据delete from test where id not in (select col1 from ...