Top Description Methods
org.jooq

public Interface UpdateQuery<R extends org.jooq.Record>

extends StoreQuery<R extends Record>, ConditionProvider, Update<R extends Record>
Known Direct Implementers
org.jooq.impl.UpdateQueryImpl
Type Parameters
<R>
The record type of the table being updated
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

Deprecated

as a consequence of ConditionProvider being deprecated. See corresponding docs for further information.

An UPDATE statement (model API).

This type is the model API representation of a Update statement, which can be mutated after creation. The advantage of this API compared to the DSL API is a more simple approach to writing dynamic SQL.

Instances can be created using DSLContext#updateQuery(Table) and overloads.

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public void
addConditions(Condition
The condition
condition)

Redeclares org.jooq.ConditionProvider.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds a new condition to the query, connecting them to existing conditions with Operator#AND.
public void
addConditions(Condition...
The condition
conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds new conditions to the query, connecting them to existing conditions with Operator#AND.
public void
addConditions(Collection<? extends Condition>
The condition
conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Adds new conditions to the query, connecting them to existing conditions with Operator#AND.
public void
addConditions(Operator operator, Condition
The condition
condition)

Redeclares org.jooq.ConditionProvider.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds a new condition to the query, connecting them to existing conditions with the provided operator.
public void
addConditions(Operator operator, Condition...
The condition
conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds new conditions to the query, connecting them to existing conditions with the provided operator.
public void
addConditions(Operator operator, Collection<? extends Condition>
The condition
conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.
public void
addFrom(TableLike<?>
The added tables
from)

Add tables to the table product.

public void
addFrom(TableLike<?>...
The added tables
from)

Add tables to the table product.

public void
addFrom(Collection<? extends TableLike<?>>
The added tables
from)

Add tables to the table product.

public void
addLimit(Number
The number of rows to return
numberOfRows)

Limit the results of this select.

public void
addLimit(Field<? extends Number>
The number of rows to return
numberOfRows)

Deprecated as a consequence of Field being deprecated.
Limit the results of this select.
public void
addOrderBy(OrderField<?>...
The ordering fields
fields)

Adds ordering fields.

public void
addOrderBy(Collection<? extends OrderField<?>>
The ordering fields
fields)

Adds ordering fields.

public void
addValues(RowN row, RowN value)

Specify a multi-column set clause for the UPDATE statement.

public <T1> void
addValues(Row1<T1> row, Row1<T1> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2> void
addValues(Row2<T1, T2> row, Row2<T1, T2> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3> void
addValues(Row3<T1, T2, T3> row, Row3<T1, T2, T3> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4> void
addValues(Row4<T1, T2, T3, T4> row, Row4<T1, T2, T3, T4> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5> void
addValues(Row5<T1, T2, T3, T4, T5> row, Row5<T1, T2, T3, T4, T5> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6> void
addValues(Row6<T1, T2, T3, T4, T5, T6> row, Row6<T1, T2, T3, T4, T5, T6> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7> void
addValues(Row7<T1, T2, T3, T4, T5, T6, T7> row, Row7<T1, T2, T3, T4, T5, T6, T7> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8> void
addValues(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Row8<T1, T2, T3, T4, T5, T6, T7, T8> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9> void
addValues(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void
addValues(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void
addValues(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void
addValues(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void
addValues(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void
addValues(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void
addValues(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void
addValues(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void
addValues(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void
addValues(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void
addValues(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void
addValues(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void
addValues(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> value)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> void
addValues(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> value)

Specify a multi-column set clause for the UPDATE statement.

public void
addValues(RowN row, Select<? extends Record> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1> void
addValues(Row1<T1> row, Select<? extends Record1<T1>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2> void
addValues(Row2<T1, T2> row, Select<? extends Record2<T1, T2>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3> void
addValues(Row3<T1, T2, T3> row, Select<? extends Record3<T1, T2, T3>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4> void
addValues(Row4<T1, T2, T3, T4> row, Select<? extends Record4<T1, T2, T3, T4>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5> void
addValues(Row5<T1, T2, T3, T4, T5> row, Select<? extends Record5<T1, T2, T3, T4, T5>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6> void
addValues(Row6<T1, T2, T3, T4, T5, T6> row, Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7> void
addValues(Row7<T1, T2, T3, T4, T5, T6, T7> row, Select<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8> void
addValues(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Select<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9> void
addValues(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Select<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void
addValues(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void
addValues(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Select<? extends Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void
addValues(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void
addValues(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void
addValues(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void
addValues(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void
addValues(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void
addValues(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void
addValues(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void
addValues(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void
addValues(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void
addValues(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select)

Specify a multi-column set clause for the UPDATE statement.

public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> void
addValues(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select)

Specify a multi-column set clause for the UPDATE statement.

public R
getReturnedRecord()

Redeclares org.jooq.StoreQuery.getReturnedRecord.

The record holding returned values as specified by any of the setReturning() methods.
public @NotNull Result<R>
getReturnedRecords()

Redeclares org.jooq.StoreQuery.getReturnedRecords.

The records holding returned values as specified by any of the setReturning() methods.
public void
setReturning()

Redeclares org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return all fields in R.
public void
setReturning(Identity<R, ?>
The table's identity
identity)

Redeclares org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return the generated identity value.
public void
setReturning(SelectFieldOrAsterisk...
Fields to be returned
fields)

Redeclares org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return a list of fields in R.
public void
setReturning(Collection<? extends SelectFieldOrAsterisk>
Fields to be returned
fields)

Redeclares org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return a list of fields in R.
Inherited from org.jooq.StoreQuery:
addValueaddValueaddValuesgetResultsetRecord

Method Detail

addConditionsback to summary
public void addConditions(Condition condition)

Redeclares org.jooq.ConditionProvider.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Adds a new condition to the query, connecting them to existing conditions with Operator#AND.

Parameters
condition:Condition

The condition

Annotations
@Override
@Support
addConditionsback to summary
public void addConditions(Condition... conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Adds new conditions to the query, connecting them to existing conditions with Operator#AND.

Parameters
conditions:Condition[]

The condition

Annotations
@Override
@Support
addConditionsback to summary
public void addConditions(Collection<? extends Condition> conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Adds new conditions to the query, connecting them to existing conditions with Operator#AND.

Parameters
conditions:Collection<? extends Condition>

The condition

Annotations
@Override
@Support
addConditionsback to summary
public void addConditions(Operator operator, Condition condition)

Redeclares org.jooq.ConditionProvider.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Adds a new condition to the query, connecting them to existing conditions with the provided operator.

Parameters
condition:Condition

The condition

Annotations
@Override
@Support
addConditionsback to summary
public void addConditions(Operator operator, Condition... conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

Parameters
conditions:Condition[]

The condition

Annotations
@Override
@Support
addConditionsback to summary
public void addConditions(Operator operator, Collection<? extends Condition> conditions)

Redeclares org.jooq.ConditionProvider.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

Parameters
conditions:Collection<? extends Condition>

The condition

Annotations
@Override
@Support
addFromback to summary
public void addFrom(TableLike<?> from)

Add tables to the table product.

Parameters
from:TableLike<?>

The added tables

Annotations
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE
addFromback to summary
public void addFrom(TableLike<?>... from)

Add tables to the table product.

Parameters
from:TableLike<?>[]

The added tables

Annotations
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE
addFromback to summary
public void addFrom(Collection<? extends TableLike<?>> from)

Add tables to the table product.

Parameters
from:Collection<? extends TableLike<?>>

The added tables

Annotations
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE
addLimitback to summary
public void addLimit(Number numberOfRows)

Limit the results of this select.

Parameters
numberOfRows:Number

The number of rows to return

Annotations
@Support
addLimitback to summary
public void addLimit(Field<? extends Number> numberOfRows)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Limit the results of this select.

Parameters
numberOfRows:Field<? extends Number>

The number of rows to return

Annotations
@Support
addOrderByback to summary
public void addOrderBy(OrderField<?>... fields)

Adds ordering fields.

Parameters
fields:OrderField<?>[]

The ordering fields

Annotations
@Support
addOrderByback to summary
public void addOrderBy(Collection<? extends OrderField<?>> fields)

Adds ordering fields.

Parameters
fields:Collection<? extends OrderField<?>>

The ordering fields

Annotations
@Support
addValuesback to summary
public void addValues(RowN row, RowN value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1> void addValues(Row1<T1> row, Row1<T1> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2> void addValues(Row2<T1, T2> row, Row2<T1, T2> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3> void addValues(Row3<T1, T2, T3> row, Row3<T1, T2, T3> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4> void addValues(Row4<T1, T2, T3, T4> row, Row4<T1, T2, T3, T4> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5> void addValues(Row5<T1, T2, T3, T4, T5> row, Row5<T1, T2, T3, T4, T5> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6> void addValues(Row6<T1, T2, T3, T4, T5, T6> row, Row6<T1, T2, T3, T4, T5, T6> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7> void addValues(Row7<T1, T2, T3, T4, T5, T6, T7> row, Row7<T1, T2, T3, T4, T5, T6, T7> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8> void addValues(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Row8<T1, T2, T3, T4, T5, T6, T7, T8> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> void addValues(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void addValues(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void addValues(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void addValues(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void addValues(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void addValues(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void addValues(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void addValues(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void addValues(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void addValues(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void addValues(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void addValues(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void addValues(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback 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> void addValues(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> value)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public void addValues(RowN row, Select<? extends Record> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1> void addValues(Row1<T1> row, Select<? extends Record1<T1>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2> void addValues(Row2<T1, T2> row, Select<? extends Record2<T1, T2>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3> void addValues(Row3<T1, T2, T3> row, Select<? extends Record3<T1, T2, T3>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4> void addValues(Row4<T1, T2, T3, T4> row, Select<? extends Record4<T1, T2, T3, T4>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5> void addValues(Row5<T1, T2, T3, T4, T5> row, Select<? extends Record5<T1, T2, T3, T4, T5>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6> void addValues(Row6<T1, T2, T3, T4, T5, T6> row, Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7> void addValues(Row7<T1, T2, T3, T4, T5, T6, T7> row, Select<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8> void addValues(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Select<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> void addValues(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Select<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void addValues(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void addValues(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Select<? extends Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void addValues(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void addValues(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void addValues(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void addValues(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void addValues(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void addValues(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void addValues(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void addValues(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void addValues(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback to summary
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void addValues(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
addValuesback 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> void addValues(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select)

Specify a multi-column set clause for the UPDATE statement.

Annotations
@Support
getReturnedRecordback to summary
public R getReturnedRecord()

Redeclares org.jooq.StoreQuery.getReturnedRecord.

Doc from org.jooq.StoreQuery.getReturnedRecord.

The record holding returned values as specified by any of the setReturning() methods.

If the insert statement returns several records, this is the same as calling getReturnedRecords().get(0)

This implemented differently for every dialect:

  • Firebird and Postgres have native support for INSERT … RETURNING and UPDATE … RETURNING clauses
  • HSQLDB, Oracle, and DB2 JDBC drivers allow for retrieving any table column as "generated key" in one statement
  • Derby, H2, Ingres, MySQL, SQL Server only allow for retrieving IDENTITY column values as "generated key". If other fields are requested, a second statement is issued. Client code must assure transactional integrity between the two statements.
  • Sybase and SQLite allow for retrieving IDENTITY values as @@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.

This feature works with UPDATE statements for a subset of SQL dialects

Returns:R

The returned value as specified by any of the setReturning() methods. This may return null in case jOOQ could not retrieve any generated keys from the JDBC driver.

Annotations
@Override
@Nullable
@Support:FIREBIRD, H2, POSTGRES, YUGABYTEDB
getReturnedRecordsback to summary
public @NotNull Result<R> getReturnedRecords()

Redeclares org.jooq.StoreQuery.getReturnedRecords.

Doc from org.jooq.StoreQuery.getReturnedRecords.

The records holding returned values as specified by any of the setReturning() methods.

This implemented differently for every dialect:

  • Firebird and Postgres have native support for INSERT … RETURNING and UPDATE … RETURNING clauses
  • HSQLDB, Oracle, and DB2 JDBC drivers allow for retrieving any table column as "generated key" in one statement
  • Derby, H2, Ingres, MySQL, SQL Server only allow for retrieving IDENTITY column values as "generated key". If other fields are requested, a second statement is issued. Client code must assure transactional integrity between the two statements.
  • Sybase and SQLite allow for retrieving IDENTITY values as @@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.

[#5070] Due to an early API design flaw, this method historically returns the type R, not a more generic type Record. This means that only actual columns in R can be returned. For a more generic set of column expressions, use getResult() instead.

This feature works with UPDATE statements for a subset of SQL dialects

Returns:@NotNull Result<R>

The returned values as specified by any of the setReturning() methods. Note:

  • Not all databases / JDBC drivers support returning several values on multi-row inserts!
  • This may return an empty Result in case jOOQ could not retrieve any generated keys from the JDBC driver.
Annotations
@Override
@NotNull
@Support:FIREBIRD, H2, POSTGRES, YUGABYTEDB
setReturningback to summary
public void setReturning()

Redeclares org.jooq.StoreQuery.setReturning.

Doc from org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return all fields in R.

This feature works with UPDATE statements for a subset of SQL dialects

Annotations
@Override
@Support:FIREBIRD, H2, POSTGRES, YUGABYTEDB
setReturningback to summary
public void setReturning(Identity<R, ?> identity)

Redeclares org.jooq.StoreQuery.setReturning.

Doc from org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return the generated identity value.

This feature works with UPDATE statements for a subset of SQL dialects

Parameters
identity:Identity<R, ?>

The table's identity

Annotations
@Override
@Support:FIREBIRD, H2, POSTGRES, YUGABYTEDB
setReturningback to summary
public void setReturning(SelectFieldOrAsterisk... fields)

Redeclares org.jooq.StoreQuery.setReturning.

Doc from org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return a list of fields in R.

This feature works with UPDATE statements for a subset of SQL dialects

Parameters
fields:SelectFieldOrAsterisk[]

Fields to be returned

Annotations
@Override
@Support:FIREBIRD, H2, POSTGRES, YUGABYTEDB
setReturningback to summary
public void setReturning(Collection<? extends SelectFieldOrAsterisk> fields)

Redeclares org.jooq.StoreQuery.setReturning.

Doc from org.jooq.StoreQuery.setReturning.

Configure the INSERT or UPDATE statement to return a list of fields in R.

This feature works with UPDATE statements for a subset of SQL dialects

Parameters
fields:Collection<? extends SelectFieldOrAsterisk>

Fields to be returned

Annotations
@Override
@Support:FIREBIRD, H2, POSTGRES, YUGABYTEDB