Top Description Methods
org.jooq

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

extends UpdateReturningStep<R extends Record>
Known Direct Subinterfaces
org.jooq.UpdateOrderByStep
Imports
org.jetbrains.annotations.*

Deprecated

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

This type is used for the Update's DSL API.

Example:


DSLContext create = DSL.using(configuration);

create.update(table)
      .set(field1, value1)
      .set(field2, value2)
      .where(field1.greaterThan(100))
      .execute();

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull UpdateReturningStep<R>
limit(Number numberOfRows)

Deprecated as a consequence of UpdateReturningStep being deprecated.
Add a LIMIT clause to the query.
public @NotNull UpdateReturningStep<R>
limit(Field<? extends Number> numberOfRows)

Deprecated as a consequence of Field and UpdateReturningStep being deprecated.
Add a LIMIT clause to the query.
Inherited from org.jooq.UpdateReturningStep:
returningreturningreturningreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResultreturningResult

Method Detail

limitback to summary
public @NotNull UpdateReturningStep<R> limit(Number numberOfRows)

Deprecated

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

Add a LIMIT clause to the query.

Annotations
@NotNull
@CheckReturnValue
@Support
limitback to summary
public @NotNull UpdateReturningStep<R> limit(Field<? extends Number> numberOfRows)

Deprecated

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

Add a LIMIT clause to the query.

Annotations
@NotNull
@CheckReturnValue
@Support