Top Description Methods
org.jooq

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

extends InsertOnDuplicateStep<R extends Record>
Known Direct Implementers
org.jooq.impl.InsertImpl
Imports
java.util.Collection, java.util.function.Function, org.jetbrains.annotations.NotNull

Deprecated

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

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

Example: 


using(configuration)
      .insertInto(table, fields)
      .values(fields)
      .values(fields)
      .onDuplicateKeyUpdate()
      .set(field1, value1)
      .set(field2, value2)
      .execute();
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull InsertOnDuplicateStep<R>
select(Select<? extends Record> select)

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
Use a SELECT statement as the source of values for the INSERT statement

This variant of the INSERT … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#insertInto(Table)

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

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStepN<R>
values(Field<?>... values)

Deprecated as a consequence of Field and InsertValuesStepN being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStepN<R>
values(Collection<?> values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStepN<R>
values(RowN values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStepN<R>
values(Record values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStepN<R>
valuesOfRecords(Record... values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStepN<R>
valuesOfRecords(Collection<? extends Record> values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStepN<R>
valuesOfRows(RowN... values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStepN<R>
valuesOfRows(Collection<? extends RowN> values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add multiple rows of values to the insert statement.
Inherited from org.jooq.InsertOnDuplicateStep:
onConflictonConflictonConflictDoNothingonConflictOnConstraintonConflictOnConstraintonConflictOnConstraintonDuplicateKeyIgnoreonDuplicateKeyUpdate

Method Detail

selectback to summary
public @NotNull InsertOnDuplicateStep<R> select(Select<? extends Record> select)

Deprecated

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

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

This variant of the INSERT … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#insertInto(Table)

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStepN<R> values(Object... values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStepN<R> values(Field<?>... values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStepN<R> values(Collection<?> values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStepN<R> values(RowN values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStepN<R> values(Record values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesOfRecordsback to summary
public @NotNull InsertValuesStepN<R> valuesOfRecords(Record... values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Note

Irrespective of individual Record#changed() flag values, all record values are copied to the VALUES clause using Record#intoArray(), to match insert columns by position, not by name.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesOfRecordsback to summary
public @NotNull InsertValuesStepN<R> valuesOfRecords(Collection<? extends Record> values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Note

Irrespective of individual Record#changed() flag values, all record values are copied to the VALUES clause using Record#intoArray(), to match insert columns by position, not by name.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesOfRowsback to summary
public @NotNull InsertValuesStepN<R> valuesOfRows(RowN... values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Annotations
@NotNull
@CheckReturnValue
@Support
See Also
Rows#toRowArray(Function, Function)
valuesOfRowsback to summary
public @NotNull InsertValuesStepN<R> valuesOfRows(Collection<? extends RowN> values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Annotations
@NotNull
@CheckReturnValue
@Support
See Also
Rows#toRowList(Function, Function)