【MySQL】You can‘t specify target table ‘‘ for update in FROM clause解决办法

直奔主题

• ❌ 错误Demo

UPDATE table1 SET field = '222' WHERE id IN (
	select id from table1 WHERE field = '111'
)

• ✅ 正确示范 （加个中间表了事）

UPDATE table1 SET field = '222' WHERE id IN (
	select mid.id from (
	select id from table1 WHERE field = '111'
	)mid
)