17,377
社区成员
发帖
与我相关
我的任务
分享
select * from A
1 z 1
2 y 2
3 x 3
create table B as select * from A
select * from b for update
update A a1 set A.b= B.b where A.C=B.C
create table B as select * from A;
merge into a
using b
on(a.b=b.b)
when matched then
update set a.c=b.b;