Top Description Methods
org.jooq

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

Known Direct Subinterfaces
org.jooq.InsertOnDuplicateSetMoreStep
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB
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

Modifier and TypeMethod and Description
public <T> @NotNull InsertOnDuplicateSetMoreStep<R>
set(Field<T> field, T value)

Deprecated as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated.
Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.
public <T> @NotNull InsertOnDuplicateSetMoreStep<R>
set(Field<T> field, Field<T> value)

Deprecated as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated.
Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.
public <T> @NotNull InsertOnDuplicateSetMoreStep<R>
set(Field<T> field, Select<? extends Record1<T>> value)

Deprecated as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated.
Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.
public @NotNull InsertOnDuplicateSetMoreStep<R>
set(Map<?, ?> map)

Deprecated as a consequence of InsertOnDuplicateSetMoreStep being deprecated.
Set multiple values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.
public @NotNull InsertOnDuplicateSetMoreStep<R>
set(Record record)

Deprecated as a consequence of InsertOnDuplicateSetMoreStep being deprecated.
Set multiple values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.
public @NotNull InsertOnDuplicateSetMoreStep<R>
setAllToExcluded()

Deprecated as a consequence of InsertOnDuplicateSetMoreStep being deprecated.
Sets all columns from the insert column list to DSL#excluded(Field).
public <T> @NotNull InsertOnDuplicateSetMoreStep<R>
setNull(Field<T> field)

Deprecated as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated.
Set a null value for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.

Method Detail

setback to summary
public <T> @NotNull InsertOnDuplicateSetMoreStep<R> set(Field<T> field, T value)

Deprecated

as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated. See corresponding docs for further information.

Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
setback to summary
public <T> @NotNull InsertOnDuplicateSetMoreStep<R> set(Field<T> field, Field<T> value)

Deprecated

as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated. See corresponding docs for further information.

Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
setback to summary
public <T> @NotNull InsertOnDuplicateSetMoreStep<R> set(Field<T> field, Select<? extends Record1<T>> value)

Deprecated

as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated. See corresponding docs for further information.

Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
setback to summary
public @NotNull InsertOnDuplicateSetMoreStep<R> set(Map<?, ?> map)

Deprecated

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

Set multiple values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.

Keys can either be of type String, Name, or Field.

Values can either be of type <T> or Field<T>. jOOQ will attempt to convert values to their corresponding field's type.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
setback to summary
public @NotNull InsertOnDuplicateSetMoreStep<R> set(Record record)

Deprecated

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

Set multiple values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.

This is the same as calling set(Map) with the argument record treated as a Map<Field<?>, Object>.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
See Also
set(Map)
setAllToExcludedback to summary
public @NotNull InsertOnDuplicateSetMoreStep<R> setAllToExcluded()

Deprecated

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

Sets all columns from the insert column list to DSL#excluded(Field).

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
setNullback to summary
public <T> @NotNull InsertOnDuplicateSetMoreStep<R> setNull(Field<T> field)

Deprecated

as a consequence of Field and InsertOnDuplicateSetMoreStep being deprecated. See corresponding docs for further information.

Set a null value for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.

This method is convenience for calling set(Field, Object), without the necessity of casting the Java null literal to (T).

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB