MySQL Connector/J 9.2.0 · com.mysql.cj.xdevapi.DeleteStatement

public Interface DeleteStatement

A statement to delete rows from a table.

Method Summary

Modifier and Type	Method and Description
public DeleteStatement	Returns: `DeleteStatement` limit(long limit numberOfRows) Add/replace the row limit for the deletion.
public DeleteStatement	Returns: `DeleteStatement` orderBy(String... sort expression sortFields) Add/replace the order by specification for the deletion.
public DeleteStatement	Returns: `DeleteStatement` where(String condition expression searchCondition) Add/replace the filter for the deletion.

Inherited from com.mysql.cj.xdevapi.Statement:: bind bind bind bind clearBindings execute executeAsync

limit back to summary

limit	back to summary
public DeleteStatement limit(long numberOfRows) Add/replace the row limit for the deletion. Parameters numberOfRows:long limit Returns:DeleteStatement `DeleteStatement`

public DeleteStatement limit(long numberOfRows)

Add/replace the row limit for the deletion.

Parameters

orderBy back to summary

orderBy	back to summary
public DeleteStatement orderBy(String... sortFields) Add/replace the order by specification for the deletion. Parameters sortFields:String[] sort expression Returns:DeleteStatement `DeleteStatement`

public DeleteStatement orderBy(String... sortFields)

Add/replace the order by specification for the deletion.

Parameters

where back to summary

where	back to summary
public DeleteStatement where(String searchCondition) Add/replace the filter for the deletion. Parameters searchCondition:String condition expression Returns:DeleteStatement `DeleteStatement`

public DeleteStatement where(String searchCondition)

Add/replace the filter for the deletion.

Parameters