SQL 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