Module org.jooq
Package org.jooq

Interface MergeNotMatchedValuesStep20<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>


  • public interface MergeNotMatchedValuesStep20<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>
    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