mysql修改重复数据You can‘t specify target table ‘‘ for update in FROM clause

You can’t specify target table ‘’ for update in FROM clause

得修改成下边的写法

update 景区与景区表 set 距离='',驾车时间='' where 距离 in (
	select a.距离 from (
		select 距离 from 景区与景区表 group by 距离 HAVING count(距离) >2
	)as a
) ;