[MySQL] update inner join
UPDATE [table1_name] AS t1 INNER JOIN [table2_name] AS t2 ON t1.[column1_name] = t2.[column1_name] SET t1.[column2_name] = t2.[column2_name]; 更新t1.column2_name = tb.column2_name的用法 參考連結 http://www.voidtricks.com/mysql-inner-join-update/