Class TableUpdateStatement

Represents a chaining table update statement.

Inheritance

System.Object

BaseStatement<Result, System.String>

TargetedBaseStatement<Table, Result, System.String>

FilterableStatement<TableUpdateStatement, Table, Result, System.String>

TableUpdateStatement

Namespace: MySqlX.XDevAPI.Relational

Assembly: MySql.Data.dll

Version: 9.2.0

Syntax

public class TableUpdateStatement : FilterableStatement<TableUpdateStatement, Table, Result, string>

Methods

Execute()

Executes the update statement.

Declaration

public override Result Execute()

Returns

Type	Description
Result	A Result object ocntaining the results of the update statement execution.

Overrides

MySqlX.XDevAPI.Common.BaseStatement<MySqlX.XDevAPI.Common.Result, System.String>.Execute()

OrderBy(String[])

Sets user-defined sorting criteria for the operation. The strings use normal SQL syntax like "order ASC" or "pages DESC, age ASC".

Declaration

public TableUpdateStatement OrderBy(params string[] order)

Parameters

Type	Name	Description
System.String[]	order	The order criteria.

Returns

Type	Description
TableUpdateStatement	A generic object that represents the implementing statement type.

Set(String, Object)

Column and value to be updated.

Declaration

public TableUpdateStatement Set(string tableField, object value)

Parameters

Type	Name	Description
System.String	tableField	Column name.
System.Object	value	Value to be updated.

Returns

Type	Description
TableUpdateStatement	This same TableUpdateStatement object.