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

Method Summary

Modifier and Type	Method and Description
public UpdateStatement	Returns: `UpdateStatement` limit(long limit numberOfRows) Add/replace the row limit for this statement.
public UpdateStatement	Returns: `UpdateStatement` orderBy(String... sort expression sortFields) Add/replace the order specification for this statement.
public UpdateStatement	Returns: `UpdateStatement` set(Map<String, Object> table name-value pairs fieldsAndValues) Add the given set of updates to the statement.
public UpdateStatement	Returns: `UpdateStatement` set(String field name field, Object value to set value) Add the given update to the statement setting field to value for all rows matching the search criteria.
public UpdateStatement	Returns: `UpdateStatement` where(String search condition expression searchCondition) Add/replace the search criteria for this statement.

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

limit back to summary

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

public UpdateStatement limit(long numberOfRows)

Add/replace the row limit for this statement.

Parameters

orderBy back to summary

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

public UpdateStatement orderBy(String... sortFields)

Add/replace the order specification for this statement.

Parameters

set back to summary

set	back to summary
public UpdateStatement set(Map<String, Object> fieldsAndValues) Add the given set of updates to the statement. Parameters fieldsAndValues:Map<String, Object> table name-value pairs Returns:UpdateStatement `UpdateStatement`

public UpdateStatement set(Map<String, Object> fieldsAndValues)

Add the given set of updates to the statement.

Parameters

set back to summary

set	back to summary
public UpdateStatement set(String field, Object value) Add the given update to the statement setting field to value for all rows matching the search criteria. Parameters field:String field name value:Object value to set Returns:UpdateStatement `UpdateStatement`

public UpdateStatement set(String field, Object value)

Add the given update to the statement setting field to value for all rows matching the search criteria.

Parameters

where back to summary

where	back to summary
public UpdateStatement where(String searchCondition) Add/replace the search criteria for this statement. Parameters searchCondition:String search condition expression Returns:UpdateStatement `UpdateStatement`

public UpdateStatement where(String searchCondition)

Add/replace the search criteria for this statement.

Parameters