Interface InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
-
- All Superinterfaces:
Attachable
,AttachableQueryPart
,AutoCloseable
,Flow.Publisher<Integer>
,Insert<R>
,InsertFinalStep<R>
,InsertOnDuplicateStep<R>
,InsertReturningStep<R>
,Publisher<Integer>
,org.reactivestreams.Publisher<Integer>
,Query
,QueryPart
,RowCountQuery
,Serializable
,Statement
public interface InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> extends InsertOnDuplicateStep<R>
This type is used for theInsert
's DSL API.Example:
using(configuration) .insertInto(table, field1, field2, field3, .., field10, field11) .values(valueA1, valueA2, valueA3, .., valueA10, valueA11) .values(valueB1, valueB2, valueB3, .., valueB10, valueB11) .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 Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
values(Collection<?> values)
Add a single row of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
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)
Add a single row of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
values(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values)
Add a single row of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
values(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values)
Add a single row of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11)
Add a single row of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
valuesOfRecords(Collection<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> values)
Add multiple rows of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
valuesOfRecords(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... values)
Add multiple rows of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
valuesOfRows(Collection<? extends Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> values)
Add multiple rows of values to the insert statement.@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
valuesOfRows(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... 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 InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11)
Add a single row of values to the insert statement.
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> 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)
Add a single row of values to the insert statement.
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values(Collection<?> values)
Add a single row of values to the insert statement.
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values)
Add a single row of values to the insert statement.
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> values)
Add a single row of values to the insert statement.
-
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> valuesOfRows(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... 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 InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> valuesOfRows(Collection<? extends Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> 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 InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> valuesOfRecords(Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... 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 InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> valuesOfRecords(Collection<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> 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 Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> 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)
-
-