Top Description Methods
org.jooq

public Interface InsertValuesStep12<R extends org.jooq.Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

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, .., field11, field12)
      .values(valueA1, valueA2, valueA3, .., valueA11, valueA12)
      .values(valueB1, valueB2, valueB3, .., valueB11, valueB12)
      .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 Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> 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)

public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
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)

Deprecated as a consequence of InsertValuesStep12 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
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)

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

Deprecated as a consequence of InsertValuesStep12 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
values(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> values)

Deprecated as a consequence of InsertValuesStep12 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
values(Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> values)

Deprecated as a consequence of InsertValuesStep12 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
valuesOfRecords(Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>... values)

Deprecated as a consequence of InsertValuesStep12 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
valuesOfRecords(Collection<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> values)

Deprecated as a consequence of InsertValuesStep12 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
valuesOfRows(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>... values)

Deprecated as a consequence of InsertValuesStep12 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
valuesOfRows(Collection<? extends Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> values)

Deprecated as a consequence of InsertValuesStep12 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 Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> 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)

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> 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)

Deprecated

as a consequence of InsertValuesStep12 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 InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> 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)

Deprecated

as a consequence of Field and InsertValuesStep12 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 InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> values(Collection<?> values)

Deprecated

as a consequence of InsertValuesStep12 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 InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> values(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> values)

Deprecated

as a consequence of InsertValuesStep12 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 InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> values(Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> values)

Deprecated

as a consequence of InsertValuesStep12 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 InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> valuesOfRecords(Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>... values)

Deprecated

as a consequence of InsertValuesStep12 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 InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> valuesOfRecords(Collection<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> values)

Deprecated

as a consequence of InsertValuesStep12 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 InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> valuesOfRows(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>... values)

Deprecated

as a consequence of InsertValuesStep12 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)
valuesOfRowsback to summary
public @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> valuesOfRows(Collection<? extends Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> values)

Deprecated

as a consequence of InsertValuesStep12 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)