- Type Parameters:
R
- The record type of the table being deleted from
- All Superinterfaces:
Attachable
,AttachableQueryPart
,ConditionProvider
,Delete<R>
,DMLQuery<R>
,Flow.Publisher<Integer>
,Publisher<Integer>
,org.reactivestreams.Publisher<Integer>
,Query
,QueryPart
,RowCountQuery
,Serializable
,Statement
A
DELETE
statement (model API).
This type is the model API representation of a Delete
statement,
which can be mutated after creation. The advantage of this API compared to
the DSL API is a more simple approach to writing dynamic SQL.
Instances can be created using DSLContext.deleteQuery(Table)
.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescriptionvoid
addConditions
(Collection<? extends Condition> conditions) Adds new conditions to the query, connecting them to existing conditions withOperator.AND
.void
addConditions
(Condition condition) Adds a new condition to the query, connecting them to existing conditions withOperator.AND
.void
addConditions
(Condition... conditions) Adds new conditions to the query, connecting them to existing conditions withOperator.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
Limit the results of this select.void
Limit the results of this select.void
addOrderBy
(Collection<? extends OrderField<?>> fields) Adds ordering fields.void
addOrderBy
(OrderField<?>... fields) Adds ordering fields.void
addUsing
(Collection<? extends TableLike<?>> tables) Add tables to theUSING
clause.void
Add tables to theUSING
clause.void
Add tables to theUSING
clause.The record holding returned values as specified by any of thesetReturning()
methods.The records holding returned values as specified by any of thesetReturning()
methods.void
Configure theDELETE
statement to return all fields inR
.void
setReturning
(Collection<? extends SelectFieldOrAsterisk> fields) Configure theDELETE
statement to return a list of fields inR
.void
setReturning
(SelectFieldOrAsterisk... fields) Configure theDELETE
statement to return a list of fields inR
.Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
Methods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQL
Methods inherited from interface org.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
bind, bind, cancel, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout
-
Method Details
-
addUsing
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB_23,MARIADB,MYSQL,ORACLE23C,POSTGRES,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA}) void addUsing(TableLike<?> table) Add tables to theUSING
clause. -
addUsing
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB_23,MARIADB,MYSQL,ORACLE23C,POSTGRES,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA}) void addUsing(TableLike<?>... tables) Add tables to theUSING
clause. -
addUsing
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB_23,MARIADB,MYSQL,ORACLE23C,POSTGRES,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA}) void addUsing(Collection<? extends TableLike<?>> tables) Add tables to theUSING
clause. -
addConditions
Description copied from interface:ConditionProvider
Adds a new condition to the query, connecting them to existing conditions withOperator.AND
.- Specified by:
addConditions
in interfaceConditionProvider
- Parameters:
condition
- The condition
-
addConditions
Description copied from interface:ConditionProvider
Adds new conditions to the query, connecting them to existing conditions withOperator.AND
.- Specified by:
addConditions
in interfaceConditionProvider
- Parameters:
conditions
- The condition
-
addConditions
Description copied from interface:ConditionProvider
Adds new conditions to the query, connecting them to existing conditions withOperator.AND
.- Specified by:
addConditions
in interfaceConditionProvider
- Parameters:
conditions
- The condition
-
addConditions
Description copied from interface:ConditionProvider
Adds a new condition to the query, connecting them to existing conditions with the provided operator.- Specified by:
addConditions
in interfaceConditionProvider
- Parameters:
condition
- The condition
-
addConditions
Description copied from interface:ConditionProvider
Adds new conditions to the query, connecting them to existing conditions with the provided operator.- Specified by:
addConditions
in interfaceConditionProvider
- Parameters:
conditions
- The condition
-
addConditions
Description copied from interface:ConditionProvider
Adds new conditions to the query, connecting them to existing conditions with the provided operator.- Specified by:
addConditions
in interfaceConditionProvider
- Parameters:
conditions
- The condition
-
addOrderBy
Adds ordering fields.- Parameters:
fields
- The ordering fields
-
addOrderBy
Adds ordering fields.- Parameters:
fields
- The ordering fields
-
addLimit
Limit the results of this select.- Parameters:
numberOfRows
- The number of rows to return
-
addLimit
Limit the results of this select.- Parameters:
numberOfRows
- The number of rows to return
-
setReturning
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_1,ORACLE,POSTGRES,SQLITE_3_30,SQLSERVER,YUGABYTEDB}) void setReturning()Configure theDELETE
statement to return all fields inR
.- See Also:
-
setReturning
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_1,ORACLE,POSTGRES,SQLITE_3_30,SQLSERVER,YUGABYTEDB}) void setReturning(SelectFieldOrAsterisk... fields) Configure theDELETE
statement to return a list of fields inR
.- Parameters:
fields
- Fields to be returned- See Also:
-
setReturning
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_1,ORACLE,POSTGRES,SQLITE_3_30,SQLSERVER,YUGABYTEDB}) void setReturning(Collection<? extends SelectFieldOrAsterisk> fields) Configure theDELETE
statement to return a list of fields inR
.- Parameters:
fields
- Fields to be returned- See Also:
-
getReturnedRecord
@Nullable @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_1,ORACLE,POSTGRES,SQLITE_3_30,SQLSERVER,YUGABYTEDB}) R getReturnedRecord()The record holding returned values as specified by any of thesetReturning()
methods.If the
DELETE
statement returns several records, this is the same as callinggetReturnedRecords().get(0)
This implemented differently for every dialect:
- Firebird and Postgres have native support for
DELETE … RETURNING
clauses
- Returns:
- The returned value as specified by any of the
setReturning()
methods. This may returnnull
in case jOOQ could not retrieve any generated keys from the JDBC driver. - See Also:
- Firebird and Postgres have native support for
-
getReturnedRecords
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2_2_0_202,MARIADB_10_1,ORACLE,POSTGRES,SQLITE_3_30,SQLSERVER,YUGABYTEDB}) @NotNull Result<R> getReturnedRecords()The records holding returned values as specified by any of thesetReturning()
methods.If the
DELETE
statement returns several records, this is the same as callinggetReturnedRecords().get(0)
This implemented differently for every dialect:
- Firebird and Postgres have native support for
DELETE … RETURNING
clauses
- Returns:
- The returned values as specified by any of the
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.
- Firebird and Postgres have native support for
-