|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface MergeNotMatchedStep<R extends Record>
This type is used for the 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();
Method Summary | |
---|---|
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 |
Methods inherited from interface org.jooq.Query |
---|
bind, bind, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable |
Methods inherited from interface org.jooq.QueryPart |
---|
attach |
Methods inherited from interface org.jooq.Adapter |
---|
internalAPI |
Method Detail |
---|
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.
MergeNotMatchedValuesStep<R> whenNotMatchedThenInsert(Field<?>... fields)
WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
MergeNotMatchedValuesStep<R> whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)
WHEN MATCHED THEN UPDATE
clause to the
MERGE
statement
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |