mysql表的更新

1、根据两个表的id，将A表的name设置为B的name
update A inner join B on A.name=B.name set A.id=B.id;
update A as A,B set A.name=B,name wehere A.id=B.id;