DELETE Query Builder

The simplest DELETE statement example:

$delete = new Delete();
$delete->from('user');
$delete->where('id', 5);
$delete->exec();

Or:

Db::delete('user')->where('id', 5)->exec();

Beware that if you forget WHERE statement(s), you'll delete entire table.

You can use WHERE statements on delete query builder so you can build complex where conditions.

To get how many rows was deleted from table, use:

$rowsDeleted = $delete->rowCount();