这样是不行的
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,博客园