297 月 2016 by Bryce No Comments 有2張TABLE：A、B 要由B表的資料更新至A表，MYSQL的寫法為： MySQL UPDATE A INNER JOIN A ON A.id = B.id SET A.column = B.column 123 UPDATE AINNER JOIN A ON A.id = B.idSET A.column = B.column 參考： mysql update column with value from another table