insert multiple records at once in laravel eloquent

Question

I have multidimensional array and I want to insert all the data in one query with my model, I know I can do it with DB query builder class, like

 DB::table('table')->insert([ 
     ['name' => 'foo'],
     ['name' => 'bar'],
     ['name' => 'baz']
 ]);

but how can I do it with model? Model::create() doesn't insert multiple records, also I don't want to insert items with loop. is it possible to do this with eloquent?

Possible duplicate of [How to insert multiple rows from a single query using eloquent/fluent](https://stackoverflow.com/questions/29723865/how-to-insert-multiple-rows-from-a-single-query-using-eloquent-fluent) — Bhaumik Pandhi, Dec 22 '17 at 14:49
@Webinion that answer says there is an Eloquent way to do that. You can use `Model::` syntax, but still, QB method will be used. — Alexey Mezenin, Dec 22 '17 at 14:51
@AlexeyMezenin, its correct way to insert multiple data, there is not problem with that. — Bhaumik Pandhi, Dec 22 '17 at 14:53
@AlexeyMezenin, yes, it is an Eloquent solution, here `Model::` shows Eloquent in that answer — Bhaumik Pandhi, Dec 22 '17 at 14:59
@Webinion Eloquent is not about using `Model::` syntax, but about events, accessors, mutators, relationships, casting etc. — Alexey Mezenin, Dec 22 '17 at 15:01

score 9 · Accepted Answer · answered Dec 22 '17 at 14:49

9

You can do this with model:

Model::insert([ 
   ['name' => 'foo'],
   ['name' => 'bar'],
   ['name' => 'baz']
]);

But here insert is the same QB method.

answered Dec 22 '17 at 14:49

Alexey Mezenin

158,981
26
290
279

Thanks. For anyone else coming here, make sure you use a multi-dimensional array of arrays. I was a dummy and trying to just do `Model::insert(array(), array())` instead of `Model::insert(array(array(),array()));`... just one of those moments... – Casper Wilkes Jun 01 '18 at 03:25
1

@daisura99 You have to fill those manually since it's using the query builder and not Eloquent. So each line you're inserting needs to have something like: `'created_at' => Carbon::now(), 'updated_at' => Carbon::now(),` – Jamie T Apr 17 '19 at 19:14
but it will fail if one of the column didn't exist in db, while `create` will "filter" it so it won't throw error column not found. how to prevent this? – Fahmi Jan 26 '22 at 17:56

insert multiple records at once in laravel eloquent

1 Answers1