Merge (jOOQ 3.12.1 API)

All Superinterfaces:

Attachable, java.lang.AutoCloseable, java.util.concurrent.Flow.Publisher<java.lang.Integer>, org.reactivestreams.Publisher<java.lang.Integer>, Query, QueryPart, RowCountQuery, java.io.Serializable, Statement

All Known Subinterfaces:

MergeFinalStep<R>, MergeMatchedDeleteStep<R>, MergeMatchedSetMoreStep<R>, MergeMatchedStep<R>, MergeMatchedWhereStep<R>, MergeNotMatchedSetMoreStep<R>, MergeNotMatchedStep<R>, MergeNotMatchedWhereStep<R>, MergeOnConditionStep<R>
```
public interface Merge<R extends Record>
extends RowCountQuery
```
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 java.util.concurrent.Flow.Publisher
    subscribe
  - Methods inherited from interface org.reactivestreams.Publisher
    subscribe
  - Methods inherited from interface org.jooq.Query
    bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, poolable, queryTimeout
  - Methods inherited from interface org.jooq.QueryPart
    equals, hashCode, toString