Top Description Methods
org.jooq

public Interface InsertValuesStep20<R extends org.jooq.Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

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, field1, field2, field3, .., field19, field20)
      .values(valueA1, valueA2, valueA3, .., valueA19, valueA20)
      .values(valueB1, valueB2, valueB3, .., valueB19, valueB20)
      .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 Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> 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, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20)

Deprecated as a consequence of InsertValuesStep20 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20)

Deprecated as a consequence of Field and InsertValuesStep20 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
values(Collection<?> values)

Deprecated as a consequence of InsertValuesStep20 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
values(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values)

Deprecated as a consequence of InsertValuesStep20 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
values(Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values)

Deprecated as a consequence of InsertValuesStep20 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
valuesOfRecords(Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>... values)

Deprecated as a consequence of InsertValuesStep20 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
valuesOfRecords(Collection<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> values)

Deprecated as a consequence of InsertValuesStep20 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
valuesOfRows(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>... values)

Deprecated as a consequence of InsertValuesStep20 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
valuesOfRows(Collection<? extends Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> values)

Deprecated as a consequence of InsertValuesStep20 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 Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> 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, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20)

Deprecated

as a consequence of InsertValuesStep20 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 InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20)

Deprecated

as a consequence of Field and InsertValuesStep20 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 InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values(Collection<?> values)

Deprecated

as a consequence of InsertValuesStep20 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 InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values)

Deprecated

as a consequence of InsertValuesStep20 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 InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values(Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> values)

Deprecated

as a consequence of InsertValuesStep20 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 InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> valuesOfRecords(Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>... values)

Deprecated

as a consequence of InsertValuesStep20 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
@SuppressWarnings:unchecked
valuesOfRecordsback to summary
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> valuesOfRecords(Collection<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> values)

Deprecated

as a consequence of InsertValuesStep20 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 InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> valuesOfRows(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>... values)

Deprecated

as a consequence of InsertValuesStep20 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
@SuppressWarnings:unchecked
See Also
Rows#toRowArray(Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)
valuesOfRowsback to summary
public @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> valuesOfRows(Collection<? extends Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> values)

Deprecated

as a consequence of InsertValuesStep20 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, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)