mysqlでupdateを使用してselectクエリーを含む複数のフィールドを同時に更新

試行錯誤:

update    set(  1,  2,  3,...) = (select   1,  2,  3,...) where    

正しい方法:

#    select  

UPDATE OldData o, NewData n 
SET o.name = n.name, o.address = n.address 
where n.nid=234 and o.id=123;

#   select  

UPDATE OldData o, (select name, address from NewData where id = 123) n 
SET o.name = n.name, o.address = n.address 
where n.nid=234;