Interface InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
- 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
Insert
's DSL API.
Example:
using(configuration)
.insertInto(table, field1, field2, field3, .., field13, field14)
.values(valueA1, valueA2, valueA3, .., valueA13, valueA14)
.values(valueB1, valueB2, valueB3, .., valueB13, valueB14)
.onDuplicateKeyUpdate()
.set(field1, value1)
.set(field2, value2)
.execute();
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull InsertOnDuplicateStep<R>
Use aSELECT
statement as the source of values for theINSERT
statementvalues
(Collection<?> values) Add a single row of values to the insert statement.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) Add a single row of values to the insert statement.Add a single row of values to the insert statement.Add a single row of values to the insert statement.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) Add a single row of values to the insert statement.valuesOfRecords
(Collection<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> values) Add multiple rows of values to the insert statement.Add multiple rows of values to the insert statement.Add multiple rows of values to the insert statement.Add multiple rows of values to the insert statement.Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
Methods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQL
Methods inherited from interface org.jooq.InsertOnDuplicateStep
onConflict, onConflict, onConflictDoNothing, onConflictOnConstraint, onConflictOnConstraint, onConflictOnConstraint, onDuplicateKeyIgnore, onDuplicateKeyUpdate
Methods 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, returningResult
Methods inherited from interface org.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
bind, bind, cancel, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout
-
Method Details
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (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) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (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) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (Collection<?> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> values) Add a single row of values to the insert statement. -
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesOfRowsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>... 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.
- See Also:
-
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesOfRowsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (Collection<? extends Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> 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.
- See Also:
-
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesOfRecordsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>... 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.
Note: Irrespective of individual
Record.changed()
flag values, all record values are copied to theVALUES
clause usingRecord.intoArray()
, to match insert columns by position, not by name. If you prefer omitting unchanged values and adding values by field name rather than by index, useInsertSetStep.set(Record...)
instead. That syntax is available only if you omit the explicit insert columns list. -
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1, valuesOfRecordsT2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> (Collection<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> 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.
Note: Irrespective of individual
Record.changed()
flag values, all record values are copied to theVALUES
clause usingRecord.intoArray()
, to match insert columns by position, not by name. If you prefer omitting unchanged values and adding values by field name rather than by index, useInsertSetStep.set(Record...)
instead. That syntax is available only if you omit the explicit insert columns list. -
select
@NotNull @CheckReturnValue @Support @NotNull InsertOnDuplicateStep<R> select(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Use aSELECT
statement as the source of values for theINSERT
statementThis variant of the
INSERT … SELECT
statement expects a select returning exactly as many fields as specified previously in theINTO
clause:DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)
-