摘要： UPDATE AS alias_1 INNER JOIN (SELECT FROM WHERE = value) AS alias_2 SET alias_1.column_1 = value WHERE alias_1.id = alias_2.id 其中inner join后面的内容可以是任何的 阅读全文