錯誤嘗試:
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;