@Generated(value="This class was generated using jOOQ-tools") public interface InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> extends InsertOnDuplicateStep<R>
Insert
's DSL API.
Example:
using(configuration)
.insertInto(table, field1, field2, field3, .., field21, field22)
.values(valueA1, valueA2, valueA3, .., valueA21, valueA22)
.values(valueB1, valueB2, valueB3, .., valueB21, valueB22)
.onDuplicateKeyUpdate()
.set(field1, value1)
.set(field2, value2)
.execute();
Modifier and Type | Method and Description |
---|---|
InsertOnDuplicateStep<R> |
select(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
values(Collection<?> values)
Add values to the insert statement.
|
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
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,
Field<T22> value22)
Add values to the insert statement.
|
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
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,
T22 value22)
Add values to the insert statement.
|
onConflict, onConflict, onConflictDoNothing, onDuplicateKeyIgnore, onDuplicateKeyUpdate
returning, returning, returning
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, detach
@Support InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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, T22 value22)
@Support InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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, Field<T22> value22)
@Support InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> values(Collection<?> values)
@Support InsertOnDuplicateStep<R> select(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
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, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)
Copyright © 2017. All Rights Reserved.