With CakePHP, you can remove multiple records from a database table using the deleteAll() model method.
$this -> Model -> deleteAll($conditions, $cascade = true);
Lets say that you wanted to remove all the records for a specific user from the Item model. Below is a quick example.
$this -> Item -> deleteAll(array('Item.user_id' => 13));
…where 13 would be the ID of the specific user.
Off course…you can completely truncate a table with the same method, this time removing all conditions. Below is an example of how to truncate a database table using CakePHP.
deleteAll() table truncate
$this -> Model -> deleteAll();