MERGE INTO test1 c USING test e ON(e.ID=c.ID) WHEN MATCHED THEN UPDATE SET c.NAME=e.NAME WHEN NOT MATCHED THEN INSERT VALUES(e.ID,e.NAME,e.locid)
MERGE 的用法
最新推荐文章于 2021-03-15 18:53:43 发布
MERGE INTO test1 c USING test e ON(e.ID=c.ID) WHEN MATCHED THEN UPDATE SET c.NAME=e.NAME WHEN NOT MATCHED THEN INSERT VALUES(e.ID,e.NAME,e.locid)