- 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)
.values(field1, field2)
.values(field1, field2)
.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 InsertValuesStep2<R,
T1, T2> values
(Collection<?> values) Add a single row of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> Add a single row of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> Add a single row of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> Add a single row of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> Add a single row of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> valuesOfRecords
(Collection<? extends Record2<T1, T2>> values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> valuesOfRecords
(Record2<T1, T2>... values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> valuesOfRows
(Collection<? extends Row2<T1, T2>> values) Add multiple rows of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> valuesOfRows
(Row2<T1, T2>... 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 InsertValuesStep2<R,T1, valuesT2> (T1 value1, T2 value2) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep2<R,T1, valuesT2> (Field<T1> value1, Field<T2> value2) Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep2<R,T1, valuesT2> (Collection<?> values) Add a single row of values to the insert statement. -
values
Add a single row of values to the insert statement. -
values
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep2<R,T1, valuesT2> (Record2<T1, T2> values) Add a single row of values to the insert statement. -
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep2<R,T1, valuesOfRowsT2> (Row2<T1, T2>... 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.
- See Also:
-
valuesOfRows
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep2<R,T1, valuesOfRowsT2> (Collection<? extends Row2<T1, T2>> 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.
- See Also:
-
valuesOfRecords
@NotNull @CheckReturnValue @Support @NotNull InsertValuesStep2<R,T1, valuesOfRecordsT2> (Record2<T1, T2>... 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 InsertValuesStep2<R,T1, valuesOfRecordsT2> (Collection<? extends Record2<T1, T2>> 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 Record2<T1, T2>> 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)
-