本文展示了一个使用SQL语句进行数据合并、更新及插入的例子。通过一条复杂的SQL语句，实现了对现有记录的更新与不存在记录的新增操作。此案例有助于理解如何高效地管理和同步数据库中的商品信息。
MERGE INTO tvsms.vsms_goods_t a
USING ( select '44467890' goods_id,'10' goods_suttle,'assadf' goods_pname from dual) c
ON (c.goods_id=a.goods_id)
WHEN MATCHED THEN
update set GOODS_SUTTLE=c.goods_suttle,goods_time=sysdate,GOODS_PNAME=c.goods_pname
where a.goods_id=c.goods_id
WHEN NOT MATCHED THEN
insert (goods_id,goods_suttle,goods_pname,goods_uid,goods_time)
values(c.goods_id,c.goods_suttle,c.goods_pname,'',sysdate);
USING ( select '44467890' goods_id,'10' goods_suttle,'assadf' goods_pname from dual) c
ON (c.goods_id=a.goods_id)
WHEN MATCHED THEN
update set GOODS_SUTTLE=c.goods_suttle,goods_time=sysdate,GOODS_PNAME=c.goods_pname
where a.goods_id=c.goods_id
WHEN NOT MATCHED THEN
insert (goods_id,goods_suttle,goods_pname,goods_uid,goods_time)
values(c.goods_id,c.goods_suttle,c.goods_pname,'',sysdate);
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
