DB2合并不匹配INSERTwhen不匹配
DB2合并不匹配INSERTwhen不匹配
提问于 2016-12-28 03:19:22
我的声明：
MERGE INTO tblshoppingcart AS target USING
(SELECT * FROM tblshoppingcart
WHERE session_id = 'f7f2eb03-5ca5-4a85-b83e-70f197c087ae ' AND primlink = '19830625000054' AND store = 17 AND catalog = 'SS3' AND quantity = 35 AND item_type = 0) AS source
ON target.primlink = source.primlink AND
target.session_id = source.session_id AND target.item_type = source.item_type
WHEN NOT MATCHED THEN
INSERT VALUES ( 'f7f2eb03-5ca5-4a85-b83e-70f197c087ae', '19830625000054', 17, 'SS3', 'PAS', 35, 5, '', 0 )
WHEN MATCHED THEN
UPDATE SET quantity = 15当匹配时，更新可以正常工作
当不匹配时，插入不会抛出错误，但也不会插入任何内容。
Stack Overflow用户
发布于 2016-12-28 06:13:56
尝试将不匹配时更改为：
WHEN NOT MATCHED BY TARGET THEN页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/41350965
复制相关文章
相似问题
腾讯云开发者
