Update from one mysql table to another

Something I did a lot of today. Updating from one table in mysql to another:


UPDATE table2 t2, table1 t1
SET t1.t2name = t2.name
WHERE
t1.id = t2.id