- All Superinterfaces:
Attachable
,AttachableQueryPart
,AutoCloseable
,DMLQuery<R>
,Flow.Publisher<Integer>
,Publisher<Integer>
,org.reactivestreams.Publisher<Integer>
,Query
,QueryPart
,RowCountQuery
,Serializable
,Statement
- All Known Subinterfaces:
MergeFinalStep<R>
,MergeMatchedDeleteStep<R>
,MergeMatchedSetMoreStep<R>
,MergeMatchedStep<R>
,MergeMatchedWhereStep<R>
,MergeNotMatchedSetMoreStep<R>
,MergeNotMatchedStep<R>
,MergeNotMatchedWhereStep<R>
,MergeOnConditionStep<R>
A
MERGE
statement.
Example:
// Assuming import static org.jooq.impl.DSL.*;
using(configuration)
.mergeInto(CUSTOMER)
.using(selectFrom(CUSTOMER_IMPORT))
.on(CUSTOMER.ID.eq(CUSTOMER_IMPORT.ID))
.whenMatchedThenUpdate()
.set(CUSTOMER.FIRST_NAME, CUSTOMER_IMPORT.FIRST_NAME)
.set(CUSTOMER.LAST_NAME, CUSTOMER_IMPORT.LAST_NAME)
.whenNotMatchedThenInsert(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME)
.values(CUSTOMER_IMPORT.FIRST_NAME, CUSTOMER_IMPORT.LAST_NAME)
.execute();
Instances can be created using DSL.mergeInto(Table)
and overloads.
- Author:
- Lukas Eder
-
Method Summary
Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
Methods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQL
Methods inherited from interface org.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
bind, bind, cancel, close, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout