Table ‘xxx‘ is specified twice, both as a target for ‘UPDATE‘ and as a separate source for data

本文主要是介绍Table ‘xxx‘ is specified twice, both as a target for ‘UPDATE‘ and as a separate source for data，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

一、MySQL异常

在UPDATE或DELETE时可能出现的SQL异常，根据本表查询对表进行操作或修改。

二、解决

在关于本表查询的条件中，嵌套一层临时表。

UPDATE `xxx` SET `sort_no` = 1 WHERE `parent_id` IN(SELECT id FROM (SELECT id FROM `xxx`)a) ;

这篇关于Table ‘xxx‘ is specified twice, both as a target for ‘UPDATE‘ and as a separate source for data的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---