UPDATE & JOIN 的妙用

UPDATE table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.id SET t1.val = t2.val

sigh, 手册还是要多看亚。