Click or drag to resize

TableUpdateStatement Class

Represents a chaining table update statement.
Inheritance Hierarchy
SystemObject
  MySqlX.XDevAPI.CommonBaseStatementResult
    MySqlX.XDevAPI.CommonTargetedBaseStatementTable, Result
      MySqlX.XDevAPI.CommonFilterableStatementTableUpdateStatement, Table, Result
        MySqlX.XDevAPI.RelationalTableUpdateStatement

Namespace:  MySqlX.XDevAPI.Relational
Assembly:  MySql.Data (in MySql.Data.dll) Version: 8.0.22
Syntax
public class TableUpdateStatement : FilterableStatement<TableUpdateStatement, Table, Result>

The TableUpdateStatement type exposes the following members.

Properties
Methods
  NameDescription
Public methodBind(Object)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodBind(String)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodBind(DbDoc)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodBind(String, Object)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodClone
Clones the filterable data but Session and Target remain the same.
(Inherited from FilterableStatementT, TTarget, TResult.)
Protected methodConvertToPreparedStatementT
Converts a statement to prepared statement for a second execution without any change but Bind, Limit, or Offset.
(Inherited from BaseStatementTResult.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodExecute
Executes the update statement.
(Overrides BaseStatementTResultExecute.)
Protected methodExecute(FuncT, TResult, T)
Executes the statement.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodExecuteAsync
Executes a statement asynchronously.
(Inherited from BaseStatementTResult.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodLimit
Sets the number of items to be returned by the operation.
(Inherited from FilterableStatementT, TTarget, TResult.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodOffset
Sets the number of items to be skipped before including them into the result.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodOrderBy
Sets user-defined sorting criteria for the operation. The strings use normal SQL syntax like "order ASC" or "pages DESC, age ASC".
Public methodSet
Column and value to be updated.
Protected methodSetChanged
Sets the status as Changed for prepared statement validation.
(Inherited from BaseStatementTResult.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Protected methodValidateOpenSession
Validates if the session is open and valid.
(Inherited from BaseStatementTResult.)
Public methodWhere
Enables the setting of Where condition for this operation.
(Inherited from FilterableStatementT, TTarget, TResult.)
Top
Fields
See Also