jOOQ 3.18.7 · org.jooq.UpdateFromStep

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:

They're operating on mutable implementations (as of jOOQ 3.x)
They're less composable and not easy to get right when dynamic SQL gets complex
They're less readable
They might have binary incompatible changes between minor releases

Method Summary

Modifier and Type	Method and Description
public @NotNull UpdateWhereStep<R>	from(TableLike<?> table) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.
public @NotNull UpdateWhereStep<R>	from(TableLike<?>... table) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.
public @NotNull UpdateWhereStep<R>	from(Collection<? extends TableLike<?>> tables) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.
public @NotNull UpdateWhereStep<R>	from(SQL sql) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.
public @NotNull UpdateWhereStep<R>	from(String sql) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.
public @NotNull UpdateWhereStep<R>	from(String sql, Object... bindings) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.
public @NotNull UpdateWhereStep<R>	from(String sql, QueryPart... parts) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.
public @NotNull UpdateWhereStep<R>	from(Name name) Deprecated as a consequence of `UpdateWhereStep` being deprecated. Add a `FROM` clause to the query.

Inherited from org.jooq.UpdateWhereStep:: where where where where where where where where whereExists whereNotExists

Method Detail

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(TableLike<?> table) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE

public @NotNull UpdateWhereStep<R> from(TableLike<?> table)

Deprecated

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

Add a FROM clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(TableLike<?>... table) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE

public @NotNull UpdateWhereStep<R> from(TableLike<?>... table)

Deprecated

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

Add a FROM clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(Collection<? extends TableLike<?>> tables) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE

public @NotNull UpdateWhereStep<R> from(Collection<? extends TableLike<?>> tables)

Deprecated

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

Add a FROM clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(SQL sql) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE @PlainSQL See Also `DSL#table(SQL)`, `SQL`

public @NotNull UpdateWhereStep<R> from(SQL sql)

Deprecated

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

Add a FROM clause to the query.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE
@PlainSQL

See Also

DSL#table(SQL), SQL

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(String sql) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE @PlainSQL See Also `DSL#table(String)`, `SQL`

public @NotNull UpdateWhereStep<R> from(String sql)

Deprecated

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

Add a FROM clause to the query.

Note

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE
@PlainSQL

See Also

DSL#table(String), SQL

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(String sql, Object... bindings) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE @PlainSQL See Also `DSL#table(String, Object...)`, `DSL#sql(String, Object...)`, `SQL`

public @NotNull UpdateWhereStep<R> from(String sql, Object... bindings)

Deprecated

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

Add a FROM clause to the query.

Note

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE
@PlainSQL

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(String sql, QueryPart... parts) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE @PlainSQL See Also `DSL#table(String, QueryPart...)`, `DSL#sql(String, QueryPart...)`, `SQL`

public @NotNull UpdateWhereStep<R> from(String sql, QueryPart... parts)

Deprecated

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

Add a FROM clause to the query.

Note

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE
@PlainSQL

from back to summary

from	back to summary
public @NotNull UpdateWhereStep<R> from(Name name) Deprecated as a consequence of `UpdateWhereStep` being deprecated. See corresponding docs for further information. Add a `FROM` clause to the query. Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE See Also `DSL#table(Name)`

public @NotNull UpdateWhereStep<R> from(Name name)

Deprecated

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

Add a FROM clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, SQLITE

See Also

DSL#table(Name)

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

Referencing XYZ*Step types directly from client code

Method Summary

Method Detail

Referencing `XYZ*Step` types directly from client code