jOOQ 3.18.7 · org.jooq.DeleteUsingStep

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

Example:


DSLContext create = DSL.using(configuration);

create.delete(table)
      .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 DeleteWhereStep<R>	using(TableLike<?> table) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.
public @NotNull DeleteWhereStep<R>	using(TableLike<?>... tables) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.
public @NotNull DeleteWhereStep<R>	using(Collection<? extends TableLike<?>> tables) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.
public @NotNull DeleteWhereStep<R>	using(SQL sql) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.
public @NotNull DeleteWhereStep<R>	using(String sql) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.
public @NotNull DeleteWhereStep<R>	using(String sql, Object... bindings) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.
public @NotNull DeleteWhereStep<R>	using(String sql, QueryPart... parts) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.
public @NotNull DeleteWhereStep<R>	using(Name name) Deprecated as a consequence of `DeleteWhereStep` being deprecated. Add a `USING` clause to the query.

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

Method Detail

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(TableLike<?> table) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` clause to the query. Annotations @NotNull @CheckReturnValue @Support:MARIADB, MYSQL, POSTGRES

public @NotNull DeleteWhereStep<R> using(TableLike<?> table)

Deprecated

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

Add a USING clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:MARIADB, MYSQL, POSTGRES

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(TableLike<?>... tables) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` clause to the query. Annotations @NotNull @CheckReturnValue @Support:MARIADB, MYSQL, POSTGRES

public @NotNull DeleteWhereStep<R> using(TableLike<?>... tables)

Deprecated

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

Add a USING clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:MARIADB, MYSQL, POSTGRES

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(Collection<? extends TableLike<?>> tables) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` clause to the query. Annotations @NotNull @CheckReturnValue @Support:MARIADB, MYSQL, POSTGRES

public @NotNull DeleteWhereStep<R> using(Collection<? extends TableLike<?>> tables)

Deprecated

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

Add a USING clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:MARIADB, MYSQL, POSTGRES

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(SQL sql) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` 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:MARIADB, MYSQL, POSTGRES @PlainSQL See Also `DSL#table(SQL)`, `SQL`

public @NotNull DeleteWhereStep<R> using(SQL sql)

Deprecated

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

Add a USING 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:MARIADB, MYSQL, POSTGRES
@PlainSQL

See Also

DSL#table(SQL), SQL

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(String sql) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` 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:MARIADB, MYSQL, POSTGRES @PlainSQL See Also `DSL#table(String)`, `SQL`

public @NotNull DeleteWhereStep<R> using(String sql)

Deprecated

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

Add a USING clause to the query.

Note

Annotations

@NotNull
@CheckReturnValue
@Support:MARIADB, MYSQL, POSTGRES
@PlainSQL

See Also

DSL#table(String), SQL

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(String sql, Object... bindings) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` 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:MARIADB, MYSQL, POSTGRES @PlainSQL See Also `DSL#table(String, Object...)`, `DSL#sql(String, Object...)`, `SQL`

public @NotNull DeleteWhereStep<R> using(String sql, Object... bindings)

Deprecated

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

Add a USING clause to the query.

Note

Annotations

@NotNull
@CheckReturnValue
@Support:MARIADB, MYSQL, POSTGRES
@PlainSQL

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(String sql, QueryPart... parts) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` 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:MARIADB, MYSQL, POSTGRES @PlainSQL See Also `DSL#table(String, QueryPart...)`, `DSL#sql(String, QueryPart...)`, `SQL`

public @NotNull DeleteWhereStep<R> using(String sql, QueryPart... parts)

Deprecated

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

Add a USING clause to the query.

Note

Annotations

@NotNull
@CheckReturnValue
@Support:MARIADB, MYSQL, POSTGRES
@PlainSQL

using back to summary

using	back to summary
public @NotNull DeleteWhereStep<R> using(Name name) Deprecated as a consequence of `DeleteWhereStep` being deprecated. See corresponding docs for further information. Add a `USING` clause to the query. Annotations @NotNull @CheckReturnValue @Support:MARIADB, MYSQL, POSTGRES See Also `DSL#table(Name)`

public @NotNull DeleteWhereStep<R> using(Name name)

Deprecated

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

Add a USING clause to the query.

Annotations

@NotNull
@CheckReturnValue
@Support:MARIADB, MYSQL, POSTGRES

See Also

DSL#table(Name)

public Interface DeleteUsingStep<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