Module org.jooq
Package org.jooq
Interface InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
- All Superinterfaces:
Attachable,AttachableQueryPart,DMLQuery<R>,Flow.Publisher<Integer>,Insert<R>,InsertFinalStep<R>,InsertOnDuplicateStep<R>,InsertReturningStep<R>,Publisher<Integer>,org.reactivestreams.Publisher<Integer>,Query,QueryPart,RowCountQuery,Serializable,Statement
public interface InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
extends InsertOnDuplicateStep<R>
This type is used for the
Insert's DSL API.
Example:
using(configuration)
.insertInto(table, field1, field2, field3, .., field20, field21)
.values(valueA1, valueA2, valueA3, .., valueA20, valueA21)
.values(valueB1, valueB2, valueB3, .., valueB20, valueB21)
.onDuplicateKeyUpdate()
.set(field1, value1)
.set(field2, value2)
.execute();
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull InsertOnDuplicateStep<R>select(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> values(Collection<?> values) Add a single row of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> 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, Field<T21> value21) Add a single row of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> Add a single row of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> Add a single row of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> 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, T21 value21) Add a single row of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> valuesOfRecords(Collection<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> valuesOfRecords(Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>... values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> valuesOfRows(Collection<? extends Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> valuesOfRows(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>... values) Add multiple rows of values to the insert statement.Methods inherited from interface org.jooq.Attachable
attach, configuration, detachMethods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQLMethods inherited from interface org.jooq.InsertOnDuplicateStep
onConflict, onConflict, onConflictDoNothing, onConflictOnConstraint, onConflictOnConstraint, onConflictOnConstraint, onDuplicateKeyIgnore, onDuplicateKeyUpdateMethods inherited from interface org.jooq.InsertReturningStep
returning, returning, returning, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResultMethods inherited from interface org.reactivestreams.Publisher
subscribeMethods inherited from interface org.jooq.Query
bind, bind, cancel, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout
-
Method Details
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (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, T21 value21) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (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, Field<T21> value21) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (Collection<?> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> values) Add a single row of values to the insert statement. -
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesOfRowsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>... values) 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.
-
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesOfRowsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (Collection<? extends Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> values) 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.
-
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesOfRecordsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>... values) 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.
-
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep21<R,T1, valuesOfRecordsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> (Collection<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> values) 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.
-
select
@NotNull @CheckReturnValue @Support @NotNull InsertOnDuplicateStep<R> select(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Use aSELECTstatement as the source of values for theINSERTstatementThis variant of the
INSERT … SELECTstatement expects a select returning exactly as many fields as specified previously in theINTOclause:DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)
-