- All Known Subinterfaces:
InsertOnConflictWhereIndexPredicateStep<R>
public interface InsertOnConflictDoUpdateStep<R extends Record>
This type is used for the
Insert
's DSL API.
Example:
DSLContext create = DSL.using(configuration);
create.insertInto(table, field1, field2)
.values(value1, value2)
.onConflict(field1)
.doUpdate()
.set(field2, value2)
.execute();
- Author:
- Lukas Eder, Fabrice Le Roy
-
Method Summary
Modifier and TypeMethodDescription@NotNull InsertReturningStep<R>
Add theDO NOTHING
clause.@NotNull InsertOnDuplicateSetStep<R>
doUpdate()
Add theDO UPDATE
clause.
-
Method Details
-
doUpdate
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_9_5,SQLITE,SQLSERVER,SYBASE,TERADATA,YUGABYTEDB}) @NotNull InsertOnDuplicateSetStep<R> doUpdate()Add theDO UPDATE
clause. -
doNothing
Add theDO NOTHING
clause.
-