MySQL UPDATE INNER JOIN 用法

UPDATE tableA
  INNER JOIN tableB ON tableA.column1 = tableB.column2 
SET 
  tableA.column2 = tableB.column2
  # WHERE 条件，可有可无 根据业务场景来即可
WHERE 
  1 = 1