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 void addFrom(TableLike<?> from)
      Add tables to the table product.
      Parameters:
      from - The added tables

    • addFrom

      @Support void addFrom(TableLike<?>... from)
      Add tables to the table product.
      Parameters:
      from - The added tables

    • addFrom

      @Support 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,MARIADB_10_5,ORACLE,POSTGRES,SQLITE_3_30,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:

    • setReturning

      @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_5,ORACLE,POSTGRES,SQLITE_3_30,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:

    • setReturning

      @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_5,ORACLE,POSTGRES,SQLITE_3_30,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:

    • setReturning

      @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_5,ORACLE,POSTGRES,SQLITE_3_30,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:

    • getReturnedRecord

      @Nullable @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_5,ORACLE,POSTGRES,SQLITE_3_30,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:

    • getReturnedRecords

      @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_5,ORACLE,POSTGRES,SQLITE_3_30,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.