执行sql create table tmp as select min(id) as col1 from fanwe_task group by title; delete from fanwe_task where id not in (select col1 from tmp); drop table tmp; MySql报错: You can't specify target table 'table name' for update in FROM clause 这样报错也可以有这种 方法 转载请注明:谷谷点程序 » mysql删除重复的数据