Mysql下SELECT的结果集作为UPDATE的WHERE条件时的SQL语法

 

这样是不行的

UPDATE `table_name` 
SET `column_1` = value 
WHERE `column_2` IN 
(SELECT * FROM `table_name` 
    WHERE `column` = value
) 

必须得这样：

UPDATE `table_name` AS alias_1
 INNER JOIN
 (SELECT * FROM `table_name` WHERE `column` = value) AS alias_2 
SET alias_1.column_1 = value 
WHERE alias_1.id = alias_2.id

转载在Mysic，博客园

地址：https://www.cnblogs.com/mysic/p/5312216.html