Top Description Methods
org.jooq

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

Known Direct Subinterfaces
org.jooq.MergeKeyStepN
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.YUGABYTEDB
This type is used for the H2-specific variant of the Merge's DSL API.

Example: 


DSLContext create = DSL.using(configuration);

create.mergeInto(table, field1, field2)
      .key(id)
      .values(value1, value2)
      .execute();
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull Merge<R>
select(Select<?> select)

Use a SELECT statement as the source of values for the MERGE statement

This variant of the MERGE … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#mergeInto(Table, Field...) or DSLContext#mergeInto(Table, Collection)

public @NotNull Merge<R>
values(Object... values)

Specify a VALUES clause

public @NotNull Merge<R>
values(Field<?>... values)

Deprecated as a consequence of Field being deprecated.
Specify a VALUES clause
public @NotNull Merge<R>
values(Collection<?> values)

Specify a VALUES clause

Method Detail

selectback to summary
public @NotNull Merge<R> select(Select<?> select)

Use a SELECT statement as the source of values for the MERGE statement

This variant of the MERGE … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#mergeInto(Table, Field...) or DSLContext#mergeInto(Table, Collection)

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, FIREBIRD, H2, HSQLDB, POSTGRES
valuesback to summary
public @NotNull Merge<R> values(Object... values)

Specify a VALUES clause

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
valuesback to summary
public @NotNull Merge<R> values(Field<?>... values)

Deprecated

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

Specify a VALUES clause

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
valuesback to summary
public @NotNull Merge<R> values(Collection<?> values)

Specify a VALUES clause

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