Top Description Methods
org.jooq

public Interface InsertOnDuplicateSetMoreStep<R extends org.jooq.Record>

extends InsertOnDuplicateSetStep<R extends Record>, InsertOnConflictWhereStep<R extends Record>
Known Direct Implementers
org.jooq.impl.InsertImpl

Deprecated

as a consequence of InsertOnConflictWhereStep being deprecated. See corresponding docs for further information.

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

Example:


DSLContext create = DSL.using(configuration);

create.insertInto(table, field1, field2)
      .values(value1, value2)
      .values(value3, value4)
      .onDuplicateKeyUpdate()
      .set(field1, value1)
      .set(field2, value2)
      .execute();

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Author
Lukas Eder

Method Summary

Inherited from org.jooq.InsertOnConflictWhereStep:
wherewherewherewherewherewherewherewherewhereExistswhereNotExists
Inherited from org.jooq.InsertOnDuplicateSetStep:
setsetsetsetsetsetAllToExcludedsetNull