ClanCats Logo


SQL Delete

The delete query builder also extends the select base. This gives you access to all where and limit methods. Besides that, the delete query builder has no special methods.

So take a look at the select documentation.

 Deleting data

Delete the user with the id 1.

// SQL: delete from `users` where `id` = 1
$h->table('users')->delete()->where('id', 1)->execute();

Delete 10 inactive users.

// SQL: delete from `users` where `active` = 0 limit 10
$h->table('users')->delete()->where('active', 0)->limit(10)->execute();