解决——》[Err] 1093 - You can't specify target table 'fcf' for update in FROM clause

版权声明：本文为博主原创文章，无需授权即可转载，甚至无需保留以上版权声明，转载时请务必注明作者。
https://blog.csdn.net/weixin_43453386/article/details/89154811

table ‘fcf’ for update in FROM clause)

1、操作

数据库更新

2、现象（错误信息）

UPDATE house_hub_fence.tb_fence_community_fence fcf
SET fcf.deleted = 1
WHERE
	fcf.community_id IN (
		SELECT
			f.community_id