Interface InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
-
- All Superinterfaces:
Attachable
,AttachableQueryPart
,AutoCloseable
,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 InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> extends InsertOnDuplicateStep<R>
This type is used for theInsert
'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
All Methods Instance Methods Abstract Methods Modifier and Type Method Description @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
statement@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
values(Collection<?> values)
Add a single row of values to the insert statement.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
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.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
values(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.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
values(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.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
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.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
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.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
valuesOfRecords(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.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
valuesOfRows(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.@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
valuesOfRows(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.-
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.jooq.Query
bind, bind, cancel, close, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout
-
-
-
-
Method Detail
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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.
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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.
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> values(Collection<?> values)
Add a single row of values to the insert statement.
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> values(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,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> values(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,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> valuesOfRows(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.
-
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> valuesOfRows(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.
-
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> valuesOfRecords(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.
-
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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.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 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)
-
-