This is simplified version of update query
| Name | Type | Description | Required |
|---|---|---|---|
| table | string | Table name | yes |
| modify | array | Your changes, Set as key => value pair, see examples | yes |
| where | array | null | Your conditions, Set as key => value pair, see examples | no |
| count | int | Count of the query, Same as limit 5 in sql query | no |
| offset | int | Offset of query, Same as offset 5 in sql qeury | no |
Output : bool
Static or normal : Static
/** Change user step */
mysql::update('users', ['step' => 'panel'], ['id' => 123456789], 1);/** Add 5 coin to all users */
mysql::update('users', ['coin' => '+=5']);/** Decrease user coin */
mysql::update('users', ['coin' => '-=5'], ['id' => 123456789], 1);/** Change user phone and give him coins */
mysql::update('users', ['phone_number' => '+123456789', 'coin' => '+=6'], ['id' => 123456789], 1);