org.jooq

Interface MergeNotMatchedSetMoreStep<R extends Record>

All Superinterfaces:

Attachable, AutoCloseable, Merge<R>, MergeFinalStep<R>, MergeNotMatchedSetStep<R>, MergeNotMatchedWhereStep<R>, Query, QueryPart, Serializable

public interface MergeNotMatchedSetMoreStep<R extends Record>
extends MergeNotMatchedSetStep<R>, MergeNotMatchedWhereStep<R>

This type is used for the Merge's DSL API.

Example:

 DSLContext create = DSL.using(configuration);

 create.mergeInto(table)
       .using(select)
       .on(condition)
       .whenMatchedThenUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .whenNotMatchedThenInsert(field1, field2)
       .values(value1, value2)
       .execute();
 

Author:

Lukas Eder

Method Summary

Methods inherited from interface org.jooq.MergeNotMatchedSetStep

set, set, set, set, set

Methods inherited from interface org.jooq.MergeNotMatchedWhereStep

where, where, where

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach, detach