@Generated(value="This class was generated using jOOQ-tools") public interface InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> extends InsertOnDuplicateStep<R>
Insert
's DSL API.
Example:
using(configuration)
.insertInto(table, field1, field2, field3, .., field9, field10)
.values(valueA1, valueA2, valueA3, .., valueA9, valueA10)
.values(valueB1, valueB2, valueB3, .., valueB9, valueB10)
.onDuplicateKeyUpdate()
.set(field1, value1)
.set(field2, value2)
.execute();
Modifier and Type | Method and Description |
---|---|
InsertOnDuplicateStep<R> |
select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
values(Collection<?> values)
Add values to the insert statement.
|
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
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)
Add values to the insert statement.
|
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
values(T1 value1,
T2 value2,
T3 value3,
T4 value4,
T5 value5,
T6 value6,
T7 value7,
T8 value8,
T9 value9,
T10 value10)
Add values to the insert statement.
|
onConflict, onConflict, onConflictDoNothing, onConflictOnConstraint, onConflictOnConstraint, onConflictOnConstraint, onDuplicateKeyIgnore, onDuplicateKeyUpdate
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
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, configuration, detach
@Support InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10)
@Support InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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)
@Support InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> values(Collection<?> values)
@Support InsertOnDuplicateStep<R> select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> 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)
Copyright © 2019. All rights reserved.