- 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, .., field5, field6)
.values(valueA1, valueA2, valueA3, .., valueA5, valueA6)
.values(valueB1, valueB2, valueB3, .., valueB5, valueB6)
.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) 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.Add a single row of values to the insert statement.valuesOfRecords
(Collection<? extends Record6<T1, T2, T3, T4, T5, T6>> values) Add multiple rows of values to the insert statement.Add multiple rows of values to the insert statement.valuesOfRows
(Collection<? extends Row6<T1, T2, T3, T4, T5, T6>> values) 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 InsertValuesStep6<R,T1, valuesT2, T3, T4, T5, T6> (T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep6<R,T1, valuesT2, T3, T4, T5, T6> (Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep6<R,T1, valuesT2, T3, T4, T5, T6> (Collection<?> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep6<R,T1, valuesT2, T3, T4, T5, T6> (Row6<T1, T2, T3, T4, T5, T6> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep6<R,T1, valuesT2, T3, T4, T5, T6> (Record6<T1, T2, T3, T4, T5, T6> values) Add a single row of values to the insert statement. -
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep6<R,T1, valuesOfRowsT2, T3, T4, T5, T6> (Row6<T1, T2, T3, T4, T5, T6>... 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 InsertValuesStep6<R,T1, valuesOfRowsT2, T3, T4, T5, T6> (Collection<? extends Row6<T1, T2, T3, T4, T5, T6>> 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 InsertValuesStep6<R,T1, valuesOfRecordsT2, T3, T4, T5, T6> (Record6<T1, T2, T3, T4, T5, T6>... 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. -
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep6<R,T1, valuesOfRecordsT2, T3, T4, T5, T6> (Collection<? extends Record6<T1, T2, T3, T4, T5, T6>> 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. -
select
@NotNull @CheckReturnValue @Support @NotNull InsertOnDuplicateStep<R> select(Select<? extends Record6<T1, T2, T3, T4, T5, T6>> 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)
-