[Err] 1093 - You can't specify target table '表名' for update in FROM clause 解决办法

DELETE FROM jingpintuji  WHERE  id IN ( select id from(SELECT	id	FROM	jingpintuji	WHERE
	if_download = 0	GROUP BY	url	HAVING	count(id) > 1)  its )

删除jingpintuji里 if_download = 0的url重复记录
通常我们这样写

DELETE FROM jingpintuji  WHERE  id IN (
SELECT	id	FROM	jingpintuji	WHERE
	if_download = 0	GROUP BY	url	HAVING	count(id) > 1 )

但是发现mysql会报错，[Err] 1093 - You can’t specify target table ‘jingpintuji’ for update in FROM clause

这个时候需要借助于中间表处理。