如何实现类似Postgresql的insert on conflict的功能，或者类似oracle的INSERT … ON DUPLICATE KEY
回答 0
暂无回答
XGQ
merge into emp
using (select * from emp01) a
on emp.empno=a.empno
when matched then
update set emp.ename=a.ename
when not matched then
insert values(a.empno,a.ename,a.sal,a.job);
merge into emp
using (select * from emp01) a
on emp.empno=a.empno
when matched then
update set emp.ename=a.ename
when not matched then
insert values(a.empno,a.ename,a.sal,a.job);