How to delete all the rows in a table using Eloquent

Question

My guess was to use the following syntax   MyModel  all  - gt delete      But that did not work  I m sure it s super simple  but I ve searched for documentation on the subject and can t find it

User · Answer

Can do a foreachloop too     collection   Model  get     foreach  collection as  c      c- gt delete

User · Answer

You can use Model  truncate   if you disable foreign key checks  I assume you use MySQL    DB  statement  SET foreign key checks 0    Model  truncate    DB  statement  SET foreign key checks 1

User · Answer

The best way for accomplishing this operation in Laravel 3 seems to be the use of the Fluent interface to truncate the table as shown below  DB  query  TRUNCATE TABLE mytable

User · Answer

I ve seen both methods been used in seed files      Uncomment the below to wipe the table clean before populating  DB  table  table name  - gt truncate       or  DB  table  table name  - gt delete      Even though you can not use the first one if you want to set foreign keys      Cannot truncate a table referenced in a foreign key constraint   So it might be a good idea to use the second one

User · Answer

Solution who works with Lumen 5 5 with foreign keys constraints     categories   MusicCategory  all    foreach  categories as  category     category- gt delete       return response  - gt json   error    gt  false

User · Answer

In my case laravel 4 2  delete all rows  but not truncate table  DB  table  your table  - gt delete

User · Answer

The reason MyModel  all  - gt delete   doesn t work is because all   actually fires off the query and returns a collection of Eloquent objects    You can make use of the truncate method  this works for Laravel 4 and 5   MyModel  truncate      That drops all rows from the table without logging individual row deletions

User · Answer

Laravel 5 2  solution   Model  getQuery  - gt delete      Just grab underlying builder with table name and do whatever  Couldn t be any tidier than that   Laravel 5 6 solution   App Model  query  - gt delete

User · Answer

I wanted to add another option for those getting to this thread via Google  I needed to accomplish this  but wanted to retain my auto-increment value which truncate   resets  I also didn t want to use DB   anything because I wanted to operate directly off of the model object  So  I went with this   Model  whereNotNull  id  - gt delete      Obviously the column will have to actually exists  but in a standard  out-of-the-box Eloquent model  the id column exists and is never null  I don t know if this is the best choice  but it works for my purposes

User · Answer

You can try this one-liner which preserves soft-deletes also   Model  whereRaw  1 1  - gt delete

User · Answer

simple solution    Mymodel  query  - gt delete

User · Answer

I wasn t able to use Model  truncate   as it would error      SQLSTATE 42000   Syntax error or access violation  1701 Cannot truncate a table referenced in a foreign key constraint   And unfortunately Model  delete   doesn t work  at least in Laravel 5 0       Non-static method Illuminate Database Eloquent Model  delete   should not be called statically  assuming  this from incompatible context   But this does work    new Model - gt newQuery  - gt delete     That will soft-delete all rows  if you have soft-delete set up  To fully delete all rows including soft-deleted ones you can change to this    new Model - gt newQueryWithoutScopes  - gt forceDelete

User · Answer

There is an indirect way   myModel where  anyColumnName    like        - gt delete      Example   User where  id    like       - gt delete      Laravel query builder information  https   laravel com docs 5 4 queries

User · Answer

In a similar vein to Travis vignon s answer  I required data from the eloquent model  and if conditions were correct  I needed to either delete or update the model  I wound up getting the minimum and maximum I d field returned by my query  in case another field was added to the table that would meet my selection criteria  along with the original selection criteria to update the fields via one raw SQL query  as opposed to one eloquent query per object in the collection    I know the use of raw SQL violates laravels beautiful code philosophy  but itd be hard to stomach possibly hundreds of queries in place of one

[laravel] How to delete all the rows in a table using Eloquent?

Examples related to laravel

Examples related to laravel-4

Examples related to eloquent