mysql 多字段更新
用以下语句执行错误:
update table1 set
table1.f1=table2.f1,table1.f2=table2.f2
from table1,table2 where table1.ID=table2.ID
用内连接才成功:
UPDATE table1 INNER JOIN table2 ON table.ID=table2.ID
SET table1.f1=table2.f1 , table1.f2=table2.f2
常见内连接: select table1.name from table1,table2 where table1.ID=table2.ID;
等同于 select table1.name from table1 inner join table2 on table1.ID=table2.ID;