Merge into
判断一个表中
如果存在该字段, 则更新该字段内容;
如果不存在该字段,则新增一条数据.
红色重点标注的地方注意:
MERGE INTO storecloudnodegrouprelation t
USING (SELECT count(*) co FROM storecloudnodegrouprelation tt WHERE tt.groupid = #groupId#) twON (tw.co>0)
WHEN MATCHED THEN
UPDATE SET t.nodeid = #nodeId# where t.groupid = #groupId#
WHEN NOT MATCHED THEN
INSERT VALUES (#nodeId#, #groupId#)