Level 6
I am looking for the solution, have you found it?
Aug 28, 2016
6
Level 2
DB->insert ignore Batch records
I know there is
DB::table('users')->insert([ ['email' => '[email protected]', 'votes' => 0], ['email' => '[email protected]', 'votes' => 0] ]);
But I need insert ignore... Is there a way to batch insert ignore?
Level 2
As I'm insering data only for the user, I'm making precleaning - getting all the records (in my case with filter by user_id), then remove from array I'm going to batch insert that already in base.
If you are not using any filter and have lots of records try to find more about transactions. If I've got the docs you can start transaction make 1k insert ignore queries and the process transaction maybe it will go in a single request. But not sure if it works.
Level 5
This trait adds both REPLACE and INSERT IGNORE to the model:
https://github.com/jdavidbakr/replaceable-model/blob/master/src/ReplaceableModel.php
Level 11
What if I don't have a model for the table I'm trying to accomplish this with?
Level 1
Has anyone had any luck with figuring this out? Has Laravel built-in support for it yet?
Level 1
Laravel's Query Builder now has insertOrIgnore in version v5.8.33 and up.
<?php
DB::table('users')->insertOrIgnore([
['id' => 1, 'email' => '[email protected]'],
['id' => 2, 'email' => '[email protected]']
]);
2 likes
Please or to participate in this conversation.