MySQL删除重复记录的方案？ 400 请求报错 

这么久了，话说第一次提问。
怎么样才能更快的删除重复数据，以下我是已经采取过的方案。

5W多条记录  删除重复记录，保留ID最小的行。

delete from table
	where peopleId in 
		(select peopleId from table group by peopleId having count(peopleId) > 1)   
	and id not in 
		(select min(id) from table group by peopleId having count(peopleId)>1)

MariaDB>1093 - You can't specify target table 'table' for update in FROM clause

delete from table
	where peopleId in 
		(select peopleId from (select tmp.* from table tmp) a group by peopleId having count(a.peopleId) > 1)   
	and id not in 
		(select min(id) from (select tmp.* from table tmp) b group by peopleId having count(b.peopleId)>1)

delete from table
	where peopleId in 
		(select peopleId from (select tmp.id, from table tmp) a group by peopleId having count(a.peopleId) > 1)   
	and id not in 
		(select min(id) from (select tmp.id,tmp.peopleId from table tmp) b group by peopleId having count(b.peopleId)>1)

总结：  第一种方法历史22分钟，系统负载5左右； 第二种方法效率非常低下，把未知索引文件破坏，终止执行 第三种方法历时17分钟，其中 insertinto tmp_ids selectmin(id),name from test groupby name havingcount(*)>1orderbynull 历时15分钟，删除动作历时2分钟，系统负载3左右 第四种方法，执行过程中，把它test的索引文件都破坏了，可见“威力”之大；