【唐诗】《喜外弟盧綸見宿》 司空曙：靜夜四無鄰，荒居舊業貧。雨中黃葉樹，燈下白頭人。以我獨沈久，愧君相見頻。平生自有分，況是蔡家親。

永夜

没有不值得去解决的问题，也没有不值得去学习的技术！

You Cannot Specify Target Table ‘xx_themes’ for Update in a FROM Clause

1093 - You can't specify target table 'xx_themes' for update in FROM clause

作者：

永夜

在

, , , ,
Views: 38

1. Execute the SQL as follows:

SQL

UPDATE `xx_themes` SET `is_original` = (SELECT `is_original` FROM `xx_themes` WHERE `id` = '237') WHERE `id` = 248

2. Error: 1093 – You can’t specify target table ‘xx_themes’ for update in FROM clause. See Figure 1.

1093 - You can't specify target table 'xx_themes' for update in FROM clause
Figure 1
SQL

UPDATE `xx_themes` SET `is_original` = (SELECT `is_original` FROM `xx_themes` WHERE `id` = '237') WHERE `id` = 248
> 1093 - You can't specify target table 'xx_themes' for update in FROM clause
> 时间: 0s

3. Reference: https://dev.mysql.com/doc/refman/5.7/en/update.html . In MySQL, you cannot modify the same table used in the SELECT part. You can join the table to itself, which causes MySQL to treat the table as two different things, thereby allowing destructive changes. See Figure 2.

In MySQL, you cannot modify the same table used in the SELECT part. You can join the table to itself, which causes MySQL to treat the table as two different things, thereby allowing destructive changes.
Figure 2
SQL

UPDATE `xx_themes` AS t
INNER JOIN `xx_themes` AS f ON t.id=248 and f.id=237
SET t.is_original = f.is_original

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者，自 2013 年起持续运营个人技术博客，记录工作与个人项目中遇到的真实问题，以及解决问题过程中的探索、实践和思考。

除了技术写作，我也在持续开发和维护自己的独立项目，探索新技术和新工具在实际场景中的应用。我始终相信，没有不值得去解决的问题，也没有不值得去学习的技术。

如果这篇文章对你有所帮助，欢迎浏览博客中的其他文章，也欢迎交流技术经验与想法。

关于我  ·  GitHub  ·  邮件联系

更多文章