Class TableUpdateStatement
Represents a chaining table update statement.
Inheritance
System.Object
TableUpdateStatement
Namespace: MySqlX.XDevAPI.Relational
Assembly: MySql.Data.dll
Version: 9.1.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. |