26 lines
720 B
Plaintext
26 lines
720 B
Plaintext
|
||
merge into 用法：（在插入或更新，或者批量更新时，使用 merge into 写法，效率更高）
|
||
|
||
Merge into的基本语法：
|
||
|
||
语法如下：
|
||
MERGE [INTO [schema .] table [t_alias]
|
||
USING [schema .] { table | view | subquery } [t_alias]
|
||
ON ( condition )
|
||
WHEN MATCHED THEN [merge_update_clause ]
|
||
WHEN NOT MATCHED THEN [merge_insert_clause];
|
||
|
||
通俗点就是如下的语法：
|
||
MERGE INTO [表名] [表别名]
|
||
USING ( [查询内容] )[或者像表查询一样的语句]
|
||
ON ([条件表达式] AND [...]...)
|
||
WHEN MATCHED THEN [匹配的update操作]
|
||
WHEN NOT MATCHED THEN [不匹配的insert操作]
|
||
|
||
|
||
参考：
|
||
|
||
https://www.cnblogs.com/onlookers/p/4270418.html
|
||
|
||
http://t.zoukankan.com/yhoralce-p-7482614.html
|