Deprecated
as a consequence of InsertFinalStep being deprecated. See corresponding docs for further information.
Insert's DSL API.
Example:
DSLContext create = DSL.using(configuration);
TableRecord<?> record =
create.insertInto(table, field1, field2)
.values(value1, value2)
.returning(field1)
.fetchOne();
This implemented differently for every dialect:
INSERT … RETURNING clausesSELECT … FROM FINAL TABLE (INSERT …)@@identity or last_inserted_rowid() values. Those
values are fetched in a separate SELECT statement. If other
fields are requested, a second statement is issued. Client code must assure
transactional integrity between the two statements.
XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. When writing
dynamic SQL, creating a statement's components dynamically, and passing them
to the DSL API statically is usually a better choice. See the manual's
section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
Drawbacks of referencing the XYZ*Step types directly:
| Modifier and Type | Method and Description |
|---|---|
| public @NotNull InsertResultStep | |
| public @NotNull InsertResultStep | returning(SelectFieldOrAsterisk...
Fields to be returned fields)Configure the |
| public @NotNull InsertResultStep | returning(Collection<? extends SelectFieldOrAsterisk>
Fields to be returned fields)Configure the |
| public @NotNull InsertResultStep | returningResult(SelectFieldOrAsterisk...
Fields to be returned fields)Configure the |
| public @NotNull InsertResultStep | returningResult(Collection<? extends SelectFieldOrAsterisk>
Fields to be returned fields)Configure the |
| public <T1> @NotNull InsertResultStep | returningResult(SelectField<T1> field1)
Configure the |
| public <T1, T2> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2)
Configure the |
| public <T1, T2, T3> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)
Configure the |
| public <T1, T2, T3, T4> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)
Configure the |
| public <T1, T2, T3, T4, T5> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
Configure the |
| public <T1, T2, T3, T4, T5, T6> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)
Configure the |
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull InsertResultStep | returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)
Configure the |
| returning | back to summary |
|---|---|
| public @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returning | back to summary |
|---|---|
| public @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
[#5070] Due to an early API design flaw, this method historically returns
the type
| |
| returning | back to summary |
|---|---|
| public @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
[#5070] Due to an early API design flaw, this method historically returns
the type
| |
| returningResult | back to summary |
|---|---|
| public @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |
| returningResult | back to summary |
|---|---|
| public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull InsertResultStep Configure the This will return the data after insertion and generation of default values and generation of any values produced by triggers.
| |