org.jooq

Interface UpdateQuery<R extends Record>

Type Parameters:

R - The record type of the table being updated

All Superinterfaces:

Attachable, ConditionProvider, Query, QueryPart, Serializable, StoreQuery<R>, Update<R>

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

A query for data updating

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
void	addConditions(Collection<? extends Condition> conditions) Adds new conditions 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... 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.
<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.
R	getReturnedRecord() The record holding returned values as specified by any of the StoreQuery.setReturning() methods.
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 Field<?>> fields) Configure the INSERT or UPDATE statement to return a list of fields in R.
void	setReturning(Field<?>... fields) Configure the INSERT or UPDATE statement to return a list of fields in R.
void	setReturning(Identity<R,? extends Number> identity) Configure the INSERT or UPDATE statement to return the generated identity value.

Methods inherited from interface org.jooq.StoreQuery

addValue, addValue, addValues, setRecord

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach, detach

Method Detail

addValues

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<T1> void addValues(Row1<T1> row,
                                                                                                                                             Row1<T1> value)

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

addValues

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<T1,T2> void addValues(Row2<T1,T2> row,
                                                                                                                                                Row2<T1,T2> value)

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

addValues

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE,POSTGRES})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<T1> void addValues(Row1<T1> row,
                                                                                                                                    Select<? extends Record1<T1>> select)

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

addValues

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={DB2,H2,HSQLDB,INGRES,ORACLE})
<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(value={INGRES,POSTGRES,SQLSERVER,SYBASE})
void addFrom(TableLike<?>... from)

Add tables to the table product.

Parameters:

from - The added tables

addFrom

@Support(value={INGRES,POSTGRES,SQLSERVER,SYBASE})
void addFrom(Collection<? extends TableLike<?>> from)

Add tables to the table product.

Parameters:

from - The added tables

addConditions

@Support
void addConditions(Condition... conditions)

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)

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... conditions)

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

Specified by:

addConditions in interface ConditionProvider

conditions - The condition

addConditions

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

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

Specified by:

addConditions in interface ConditionProvider

conditions - The condition

setReturning

@Support(value={FIREBIRD,POSTGRES})
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(value={FIREBIRD,POSTGRES})
void setReturning(Identity<R,? extends Number> 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(value={FIREBIRD,POSTGRES})
void setReturning(Field<?>... 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(value={FIREBIRD,POSTGRES})
void setReturning(Collection<? extends Field<?>> 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

@Support(value={FIREBIRD,POSTGRES})
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

@Support(value={FIREBIRD,POSTGRES})
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.

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.