This is simplified version of delete query
| Name | Type | Description | Required |
|---|---|---|---|
| table | string | Table name | 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
mysql::delete('users', ['id' => 123456789], 1);/** delete users with last activity less then 7 day */
mysql::delete('users', ['last_activity' => '< ' . time() - 7*24*3600]);/** delete all data from table */
mysql::delete('example_table');mysql::delete('example_table', ['column1' => '1', 'column2' => 2, 'column3' => '> 1000']);