org.jooq
Interface InsertOnDuplicateStep<R extends Record>

All Superinterfaces:

Adapter, Attachable, Insert<R>, InsertFinalStep<R>, InsertReturningStep<R>, Query, QueryPart, Serializable

All Known Subinterfaces:

InsertSetMoreStep<R>, InsertValuesStep<R>

public interface InsertOnDuplicateStep<R extends Record>
extends InsertFinalStep<R>, InsertReturningStep<R>

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

Example:

 Factory create = new Factory();

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

Author:

Lukas Eder

Method Summary

InsertOnDuplicateSetStep<R>

onDuplicateKeyUpdate() Add an ON DUPLICATE KEY UPDATE clause to this insert query.

Methods inherited from interface org.jooq.Query

bind, bind, execute, getBindValues, getParam, getParams, getSQL, getSQL

Methods inherited from interface org.jooq.Attachable

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Methods inherited from interface org.jooq.InsertReturningStep

returning, returning, returning

Method Detail

onDuplicateKeyUpdate

InsertOnDuplicateSetStep<R> onDuplicateKeyUpdate()

Add an ON DUPLICATE KEY UPDATE clause to this insert query.

This will try to INSERT a record. If there is a primary key or unique key in this INSERT statement's affected table that matches the value being inserted, then the UPDATE clause is executed instead.

MySQL and CUBRID natively implements this type of clause. jOOQ can simulate this clause using a MERGE statement on some other databases. The conditions for a RDBMS to simulate this clause are:

• The INSERT statement's table is an UpdatableTable
• The RDBMS supports the MERGE clause (see Factory.mergeInto(Table)).

These are the dialects that fulfill the above requirements: