sql server
update a set name=b.name, remark=b.remark from mytable a inner join mytableB b on a.id = b.id
也可
update a set name=b.name, remark=b.remark from mytable a, mytableB b where a.id = b.id
oracle
update a set name=b.name, remark=b.remark from mytable a inner join mytableB b on a.id = b.id
mysql
mysql关联多表进行update更新操作
update major m
inner join fields f
on f.name=m.des
SET m.f_id=f.id
where id<9
update major m
inner join fields f
on f.name=m.des
SET m.f_id=f.id
where id<9
等同于
SET m.f_id=f.id
WHERE f.name=m.des
- update `my` set `content`=replace(`content`,' ','');//清除my表中content字段中的空格