你的位置:首页 > 数据库

[数据库]MERGE INTO USING用法


MERGE INTO [your table-name] [rename your table here]   USING ( [write your query here] )[rename your query-sql and using just like a table] ON ([conditional expression here] AND [...]...)   WHEN MATHED THEN [here you can execute some update sql or something else ]WHEN NOT MATHED THEN [execute something else here ! ] 

例如:

MERGE INTO table1 a USING ( select id,name from table2) b ON (a.id=b.id)   WHEN MATHED THEN update set a.name=b.nameWHEN NOT MATHED THEN insert (id,name) values('id','name');

解析:

匹配table1 a,用b这个查询结果,用on建立联系,当匹配上用update,匹配不上用insert。