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

这样是不行的

UPDATE &＃96;table_name&＃96;
SET &＃96;column_1&＃96; &＃61; value
WHERE &＃96;column_2&＃96; IN (SELECT * FROM &＃96;table_name&＃96; WHERE &＃96;column&＃96; &＃61; value)


必须得这样&＃xff1a;

UPDATE &＃96;table_name&＃96; AS alias_1
INNER JOIN (SELECT * FROM &＃96;table_name&＃96; WHERE &＃96;column&＃96; &＃61; value) AS alias_2
SET alias_1.column_1 &＃61; value
WHERE alias_1.id &＃61; alias_2.id