Oracle数据库中update set select from 关联更新

update goods set code2 = 
(select code2 from init_goods where init_goods.code = goods.code)
where exists (select 1 from init_goods where init_goods.code = goods.code)
 

Logo

技术共进,成长同行——讯飞AI开发者社区

更多推荐