mysql的update select语法与oracle有所不同:
update A inner join(select id,name from B) c on A.id = c.id set A.name = c.name;
mysql的update select语法
最新推荐文章于 2022-03-11 16:07:18 发布
mysql的update select语法与oracle有所不同:
update A inner join(select id,name from B) c on A.id = c.id set A.name = c.name;