Module org.jooq
Package org.jooq

Interface MergeNotMatchedValuesStep3<R extends Record,​T1,​T2,​T3>


  • public interface MergeNotMatchedValuesStep3<R extends Record,​T1,​T2,​T3>
    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