MERGE INTO 表名 T1 USING (SELECT ? AS a ,? AS b,? AS c FROM dual) T2 ON ( T1.字段1=T2.a AND T1.字段2=T2.b AND T1.字段3=T2.c ) WHEN MATCHED THEN UPDATE SET T1.字段4 = ' ' WHEN NOT MATCHED THEN INSERT (字段1,字段2,字段3,字段4) VALUES(?,?,?,'')
并且今天完成了存储过程的bug修改 ,记录下
MERGE INTO 表名 T1 USING (SELECT ? AS a ,? AS b,? AS c FROM dual) T2 ON ( T1.字段1=T2.a AND T1.字段2=T2.b AND T1.字段3=T2.c ) WHEN MATCHED THEN UPDATE SET T1.字段4 = ' ' WHEN NOT MATCHED THEN INSERT (字段1,字段2,字段3,字段4) VALUES(?,?,?,'')
并且今天完成了存储过程的bug修改 ,记录下