org.jooq
Interface DeleteWhereStep<R extends Record>

All Superinterfaces:

Adapter, Attachable, Delete<R>, DeleteFinalStep<R>, Query, QueryPart, Serializable

public interface DeleteWhereStep<R extends Record>
extends DeleteFinalStep<R>

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

Example:

 Factory create = new Factory();

 create.delete(table)
       .where(field1.greaterThan(100))
       .execute();
 

Author:

Lukas Eder

Method Summary

DeleteConditionStep<R>	where(Collection<Condition> conditions) Add conditions to the query
DeleteConditionStep<R>	where(Condition... conditions) Add conditions to the query
DeleteConditionStep<R>	where(String sql) Add conditions to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
DeleteConditionStep<R>	where(String sql, Object... bindings) Add conditions to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
DeleteConditionStep<R>	whereExists(Select<?> select) Add an EXISTS clause to the query
DeleteConditionStep<R>	whereNotExists(Select<?> select) Add a NOT EXISTS clause to the query

Methods inherited from interface org.jooq.Query

bind, bind, execute, getBindValues, getParam, getParams, getSQL, getSQL

Methods inherited from interface org.jooq.Attachable

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Method Detail

where

DeleteConditionStep<R> where(Condition... conditions)

Add conditions to the query

where

DeleteConditionStep<R> where(Collection<Condition> conditions)

Add conditions to the query

where

DeleteConditionStep<R> where(String sql)

Add conditions 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!

See Also:

Factory.condition(String)

where

DeleteConditionStep<R> where(String sql,
                             Object... bindings)

Add conditions 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!

See Also:

Factory.condition(String, Object...)

whereExists

DeleteConditionStep<R> whereExists(Select<?> select)

Add an EXISTS clause to the query

whereNotExists

DeleteConditionStep<R> whereNotExists(Select<?> select)

Add a NOT EXISTS clause to the query