/PHP/Updateorinsert laravel for large data

Updateorinsert laravel for large data

DB::table('flights')->upsert([
    ['departure' => 'Oakland', 'destination' => 'San Diego', 'price' => 99],
    ['departure' => 'Chicago', 'destination' => 'New York', 'price' => 150]
], ['departure', 'destination'], ['price']);


The upsert method will insert records that do not exist and update the records
  that already exist with new values that you may specify. The method's first 
  argument consists of the values to insert or update, while the second argument
  lists the column(s) that uniquely identify records within the associated 
  table. The method's third and final argument is an array of columns that 
  should be updated if a matching record already exists in the database.

Similar codes

0 vote171 views1 answer
Symfony 5 - Customize Twig error templates
PHP
1 vote149 views1 answer
Sort relation model count yii2
PHP
0 vote130 views1 answer
Ternary operator for three conditions in php
PHP
7 votes155 views1 answer
Eloquent run seeder
PHP
-1 vote122 views2 answers
Apache 2
PHP
0 vote161 views1 answer
Livewire call another component
PHP
0 vote197 views1 answer
Symfony request post
PHP
37 votes145 views4 answers
Laravel migration add column first
PHP
0 vote143 views1 answer
Php add 1 day hours to unix timestamp
PHP
0 vote152 views1 answer
Laravel lang with parameter
PHP Laravel