org.jooq

Interface InsertOnConflictDoUpdateStep<R extends Record>

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)
       .values(value3, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Author:

Lukas Eder, Fabrice Le Roy

Method Summary

Modifier and Type	Method and Description
InsertReturningStep<R>	doNothing() Add the DO IGNORE clause.
InsertOnDuplicateSetStep<R>	doUpdate() Add the DO UPDATE clause.

Method Detail

doUpdate

@Support(value={AURORA_POSTGRES,CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE,TERADATA})
InsertOnDuplicateSetStep<R> doUpdate()

Add the DO UPDATE clause.

doNothing

@Support
InsertReturningStep<R> doNothing()

Add the DO IGNORE clause.