Updating records

An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition. [1]

The Update object executes declarative UPDATE statement in SQL databases, and conditions for subsets are defined by using Update::where().

Synopsis
interface Update implements ConditionalQuery
Sets the table(s) which are updated
public table(string $table):static
Sets the updating data
public setColumns(array $data):static
public createStatement(PDO $pdo):DataManipulationStatement
Sets the WHERE clause
public resetWhere(?Where $where = null):static
Adds rules to the WHERE conditions component and returns the WHERE clause
public where(Predicate|string ... $rules):Where
Returns the parameter handler
public getParams():ParameterHandler
Returns the generated SQL language string
public __toString():string
Checks the basic validity of the SQL language generated
public isValid():bool