Module org.jooq
Package org.jooq

Interface UpdateQuery<R extends Record>

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      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​(Param<? extends Number> numberOfRows)
      Limit the results of this select using named parameters.
      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<?> 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.reactivestreams.Publisher

        subscribe
    • Method Detail

      • 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,
                       RowN value)
        Specify a multi-column set clause for the UPDATE statement.
      • addValues

        @Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES_9_5})
        <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.
      • 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​(Param<? extends Number> numberOfRows)
        Limit the results of this select using named parameters.
        Parameters:
        numberOfRows - The number of rows to return
      • getReturnedRecord

        @Nullable
        @Support({AURORA_POSTGRES,DB2,FIREBIRD,ORACLE,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

        @NotNull
        @Support({AURORA_POSTGRES,DB2,FIREBIRD,ORACLE,POSTGRES})
        @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.