- 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
Insert
's DSL API.
Example:
using(configuration)
.insertInto(table, field1, field2, field3)
.values(field1, field2, field3)
.values(field1, field2, field3)
.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
statement@NotNull InsertValuesStep3<R,
T1, T2, T3> values
(Collection<?> values) Add a single row of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> Add a single row of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> Add a single row of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> Add a single row of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> Add a single row of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> valuesOfRecords
(Collection<? extends Record3<T1, T2, T3>> values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> valuesOfRecords
(Record3<T1, T2, T3>... values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> valuesOfRows
(Collection<? extends Row3<T1, T2, T3>> values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep3<R,
T1, T2, T3> valuesOfRows
(Row3<T1, T2, T3>... 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.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
bind, bind, cancel, close, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout
-
Method Details
-
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep3<R,T1, valuesT2, T3> (T1 value1, T2 value2, T3 value3) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep3<R,T1, valuesT2, T3> (Field<T1> value1, Field<T2> value2, Field<T3> value3) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep3<R,T1, valuesT2, T3> (Collection<?> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep3<R,T1, valuesT2, T3> (Row3<T1, T2, T3> values) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep3<R,T1, valuesT2, T3> (Record3<T1, T2, T3> values) Add a single row of values to the insert statement. -
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep3<R,T1, valuesOfRowsT2, T3> (Row3<T1, T2, T3>... 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 InsertValuesStep3<R,T1, valuesOfRowsT2, T3> (Collection<? extends Row3<T1, T2, T3>> 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 InsertValuesStep3<R,T1, valuesOfRecordsT2, T3> (Record3<T1, T2, T3>... 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 InsertValuesStep3<R,T1, valuesOfRecordsT2, T3> (Collection<? extends Record3<T1, T2, T3>> 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 Record3<T1, T2, T3>> 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)
-