Package com.mysql.cj.xdevapi
Interface DeleteStatement
- All Superinterfaces:
Statement<DeleteStatement,Result>
- All Known Implementing Classes:
DeleteStatementImpl
public interface DeleteStatement extends Statement<DeleteStatement,Result>
A statement to delete rows from a table.
-
Nested Class Summary
Nested classes/interfaces inherited from interface com.mysql.cj.xdevapi.Statement
Statement.LockContention
-
Method Summary
Modifier and Type Method Description DeleteStatement
limit(long numberOfRows)
Add/replace the row limit for the deletion.DeleteStatement
orderBy(java.lang.String... sortFields)
Add/replace the order by specification for the deletion.DeleteStatement
where(java.lang.String searchCondition)
Add/replace the filter for the deletion.Methods inherited from interface com.mysql.cj.xdevapi.Statement
bind, bind, bind, bind, clearBindings, execute, executeAsync
-
Method Details
-
where
Add/replace the filter for the deletion.- Parameters:
searchCondition
- condition expression- Returns:
DeleteStatement
-
orderBy
Add/replace the order by specification for the deletion.- Parameters:
sortFields
- sort expression- Returns:
DeleteStatement
-
limit
Add/replace the row limit for the deletion.- Parameters:
numberOfRows
- limit- Returns:
DeleteStatement
-