public interface InsertReturningStep<R extends Record> extends InsertFinalStep<R>
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.Modifier and Type | Method and Description |
---|---|
InsertResultStep<R> |
returning()
Configure the
INSERT statement to return all fields in
R . |
InsertResultStep<R> |
returning(Collection<? extends Field<?>> fields)
Configure the
INSERT statement to return a list of fields in
R . |
InsertResultStep<R> |
returning(Field<?>... fields)
Configure the
INSERT statement to return a list of fields in
R . |
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, detach
@Support InsertResultStep<R> returning()
INSERT
statement to return all fields in
R
.InsertResultStep
@Support InsertResultStep<R> returning(Field<?>... fields)
INSERT
statement to return a list of fields in
R
.fields
- Fields to be returnedInsertResultStep
@Support InsertResultStep<R> returning(Collection<? extends Field<?>> fields)
INSERT
statement to return a list of fields in
R
.fields
- Fields to be returnedInsertResultStep
Copyright © 2017. All Rights Reserved.