凡是过去,皆是序幕。Read the fucking manual and source code.
UPDATE table_a INNER JOIN table_b b ON a.id=b.idSET a.column_x=b.clumn_x WHERE xxx