public interface MergeNotMatchedStep<R extends Record> extends MergeFinalStep<R>
Merge
's DSL API.
Example:
Factory create = new Factory();
create.mergeInto(table)
.using(select)
.on(condition)
.whenMatchedThenUpdate()
.set(field1, value1)
.set(field2, value2)
.whenNotMatchedThenInsert(field1, field2)
.values(value1, value2)
.execute();
Modifier and Type | Method and Description |
---|---|
MergeNotMatchedSetStep<R> |
whenNotMatchedThenInsert()
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement. |
MergeNotMatchedValuesStep<R> |
whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)
Add the
WHEN MATCHED THEN UPDATE clause to the
MERGE statement |
MergeNotMatchedValuesStep<R> |
whenNotMatchedThenInsert(Field<?>... fields)
Add the
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement |
bind, bind, cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
internalAPI
@Support(value={DB2,HSQLDB,ORACLE,SQLSERVER,SYBASE}) MergeNotMatchedSetStep<R> whenNotMatchedThenInsert()
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement.
Unlike the whenNotMatchedThenInsert(Field...)
and
whenNotMatchedThenInsert(Collection)
methods, this will give
access to a MySQL-like API allowing for
INSERT SET a = x, b = y
syntax.
@Support(value={DB2,HSQLDB,ORACLE,SQLSERVER,SYBASE}) MergeNotMatchedValuesStep<R> whenNotMatchedThenInsert(Field<?>... fields)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statementCopyright © 2013. All Rights Reserved.