MERGE INTO USING ON WHEN matched / not matched then update / insert 用法——匹配上用update，匹配不上用insert

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.name
WHEN NOT MATHED THEN insert (id,name) values('id','name');

解析：

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