How to insert multiple rows from a single query using eloquent/fluent

by

It is really easy to do a bulk insert in Laravel using Eloquent or the query builder.

You can use the following approach. 

$data = [
    ['user_id'=>'Coder 1', 'subject_id'=> 4096],
    ['user_id'=>'Coder 2', 'subject_id'=> 2048],
    //...
];

Model::insert($data); // Eloquent approach
DB::table('table')->insert($data); // Query Builder approach

In your case you already have the data within the $query variable.

More Related Contents:

  1. How do I get the query builder to output its raw SQL query as a string?
  2. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  3. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  4. Get the Last Inserted Id Using Laravel Eloquent
  5. How to do this in Laravel, subquery where in
  6. Laravel Eloquent Query Using WHERE with OR AND OR?
  7. Laravel – Eloquent or Fluent random row
  8. Laravel update model with unique validation rule for attribute
  9. How can I convert many statement mysql to laravel eloquent?
  10. Add a custom attribute to a Laravel / Eloquent model on load?
  11. Eloquent ORM Code Hinting in PhpStorm
  12. Creating and Update Laravel Eloquent
  13. How to sort a Laravel query builder result by multiple columns?
  14. Laravel Eloquent Sum of relation’s column
  15. Get the Query Executed in Laravel 3/4
  16. What does “Mass Assignment” mean in Laravel?
  17. Laravel Checking If a Record Exists
  18. SQLSTATE[42S22]: Column not found: 1054 Unknown column – Laravel
  19. How to exclude certains columns while using eloquent
  20. Laravel Eloquent, group by month/year
  21. Laravel 5 hasMany relationship on two columns
  22. Laravel Recursive Relationships
  23. Laravel Eloquent – Attach vs Sync
  24. How to create a subquery using Laravel Eloquent?
  25. Eloquent model mass update
  26. Difference between Eloquent\Model::get() and all()
  27. Natural ORDER in Laravel Eloquent ORM
  28. Eloquent many-to-many-to-many – how to load distant relation easily
  29. Find or Create with Eloquent
  30. Laravel Eloquent update just if changes have been made

Leave a Comment