1、执行 SQL 如下
SQL
UPDATE `xx_themes` SET `is_original` = (SELECT `is_original` FROM `xx_themes` WHERE `id` = '237') WHERE `id` = 248
2、报错：1093 – You can’t specify target table ‘xx_themes’ for update in FROM clause。如图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、参考：https://dev.mysql.com/doc/refman/5.7/en/update.html ，在 MySQL 中，您不能修改在 SELECT 部分中使用的同一个表。可以将表连接到自身，这将导致 MySQL 将表视为两个不同的事物，从而允许进行破坏性更改。如图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