Module org.jooq

Package org.jooq

Interface UpdateQuery<R extends Record>

Type Parameters:

R - The record type of the table being updated

All Superinterfaces:

Attachable, AttachableQueryPart, ConditionProvider, DMLQuery<R>, Flow.Publisher<Integer>, Publisher<Integer>, org.reactivestreams.Publisher<Integer>, Query, QueryPart, RowCountQuery, Serializable, Statement, StoreQuery<R>, Update<R>

public interface UpdateQuery<R extends Record>
extends StoreQuery<R>, ConditionProvider, Update<R>

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 Type	Method	Description
void	addConditions(Collection<? extends Condition> conditions)	Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
void	addConditions(Condition condition)	Adds a new condition to the query, connecting them to existing conditions with Operator.AND.
void	addConditions(Condition... conditions)	Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
void	addConditions(Operator operator, Collection<? extends Condition> conditions)	Adds new conditions to the query, connecting them to existing conditions with the provided operator.
void	addConditions(Operator operator, Condition condition)	Adds a new condition to the query, connecting them to existing conditions with the provided operator.
void	addConditions(Operator operator, Condition... conditions)	Adds new conditions to the query, connecting them to existing conditions with the provided operator.
void	addFrom(Collection<? extends TableLike<?>> from)	Add tables to the table product.
void	addFrom(TableLike<?> from)	Add tables to the table product.
void	addFrom(TableLike<?>... from)	Add tables to the table product.
void	addLimit(Number numberOfRows)	Limit the results of this select.
void	addLimit(Field<? extends Number> numberOfRows)	Limit the results of this select.
void	addOrderBy(Collection<? extends OrderField<?>> fields)	Adds ordering fields.
void	addOrderBy(OrderField<?>... fields)	Adds ordering fields.
<T1> void	addValues(Row1<T1> row, Row1<T1> value)	Specify a multi-column set clause for the UPDATE statement.
<T1> void	addValues(Row1<T1> row, Select<? extends Record1<T1>> select)	Specify a multi-column set clause for the UPDATE statement.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<T1, T2> void	addValues(Row2<T1,T2> row, Row2<T1,T2> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2> void	addValues(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select)	Specify a multi-column set clause for the UPDATE statement.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
<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.
void	addValues(RowN row, RowN value)	Specify a multi-column set clause for the UPDATE statement.
void	addValues(RowN row, Select<? extends Record> select)	Specify a multi-column set clause for the UPDATE statement.
R	getReturnedRecord()	The record holding returned values as specified by any of the StoreQuery.setReturning() methods.
@NotNull Result<R>	getReturnedRecords()	The records holding returned values as specified by any of the StoreQuery.setReturning() methods.
void	setReturning()	Configure the INSERT or UPDATE statement to return all fields in R.
void	setReturning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.
void	setReturning(Identity<R,?> identity)	Configure the INSERT or UPDATE statement to return the generated identity value.
void	setReturning(SelectFieldOrAsterisk... fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.

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.Publisher

subscribe

Methods inherited from interface org.reactivestreams.Publisher

subscribe

Methods inherited from interface org.jooq.Query

bind, bind, cancel, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Methods inherited from interface org.jooq.StoreQuery

addValue, addValue, addValues, getResult, setRecord

Method Details

addValues

@Support
void addValues(RowN row,
 RowN value)

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

addValues

@Support
<T1> void addValues(Row1<T1> row,
 Row1<T1> value)

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

addValues

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

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

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

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

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

addValues

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

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

addValues

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

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

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addValues

@Support
<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.

addFrom

@Support({ASE,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,VERTICA})
void addFrom(TableLike<?> from)

Add tables to the table product.

Parameters:

from - The added tables

addFrom

@Support({ASE,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,VERTICA})
void addFrom(TableLike<?>... from)

Add tables to the table product.

Parameters:

from - The added tables

addFrom

@Support({ASE,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,VERTICA})
void addFrom(Collection<? extends TableLike<?>> from)

Add tables to the table product.

Parameters:

from - The added tables

addConditions

@Support
void addConditions(Condition condition)

Description copied from interface: ConditionProvider

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

condition - The condition

addConditions

@Support
void addConditions(Condition... conditions)

Description copied from interface: ConditionProvider

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

conditions - The condition

addConditions

@Support
void addConditions(Collection<? extends Condition> conditions)

Description copied from interface: ConditionProvider

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

conditions - The condition

addConditions

@Support
void addConditions(Operator operator,
 Condition condition)

Description copied from interface: ConditionProvider

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

condition - The condition

addConditions

@Support
void addConditions(Operator operator,
 Condition... conditions)

Description copied from interface: ConditionProvider

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

conditions - The condition

addConditions

@Support
void addConditions(Operator operator,
 Collection<? extends Condition> conditions)

Description copied from interface: ConditionProvider

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

conditions - The condition

addOrderBy

@Support
void addOrderBy(OrderField<?>... fields)

Adds ordering fields.

Parameters:

fields - The ordering fields

addOrderBy

@Support
void addOrderBy(Collection<? extends OrderField<?>> fields)

Adds ordering fields.

Parameters:

fields - The ordering fields

addLimit

@Support
void addLimit(Number numberOfRows)

Limit the results of this select.

Parameters:

numberOfRows - The number of rows to return

addLimit

@Support
void addLimit(Field<? extends Number> numberOfRows)

Limit the results of this select.

Parameters:

numberOfRows - The number of rows to return

setReturning

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB})
void 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

Specified by:

setReturning in interface StoreQuery<R extends Record>

See Also:

• StoreQuery.getReturnedRecords()

setReturning

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB})
void setReturning(Identity<R,?> identity)

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

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

Specified by:

setReturning in interface StoreQuery<R extends Record>

Parameters:

identity - The table's identity

See Also:

• StoreQuery.getReturnedRecords()

setReturning

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB})
void setReturning(SelectFieldOrAsterisk... fields)

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

Specified by:

setReturning in interface StoreQuery<R extends Record>

Parameters:

fields - Fields to be returned

See Also:

• StoreQuery.getReturnedRecords()

setReturning

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB})
void setReturning(Collection<? extends SelectFieldOrAsterisk> fields)

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

Specified by:

setReturning in interface StoreQuery<R extends Record>

Parameters:

fields - Fields to be returned

See Also:

• StoreQuery.getReturnedRecords()

getReturnedRecord

@Nullable
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB})
R getReturnedRecord()

The record holding returned values as specified by any of the StoreQuery.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

Specified by:

getReturnedRecord in interface StoreQuery<R extends Record>

Returns:

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

See Also:

• StoreQuery.getReturnedRecords()

getReturnedRecords

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB})
@NotNull Result<R> getReturnedRecords()

The records holding returned values as specified by any of the StoreQuery.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 StoreQuery.getResult() instead.

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

Specified by:

getReturnedRecords in interface StoreQuery<R extends Record>

Returns:

The returned values as specified by any of the StoreQuery.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.