/PHP/Laravel/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.

Source: grepper.com

Similar codes

0 vote320 views1 answer
Group by not working - Laravel
PHP Laravel
0 vote311 views1 answer
Chart trong laravel
PHP Laravel
0 vote347 views1 answer
How to loop array in laravel
PHP Laravel
2 votes341 views1 answer
Laravel upload image to public folder
PHP Laravel
1 vote340 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel
0 vote386 views2 answers
Declare variable in view for loop laravel
PHP Laravel
1 vote372 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
14 votes378 views4 answers
Laravel set timezone dynamically
PHP Laravel
0 vote335 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP Laravel
11 votes317 views4 answers
Laravel 8 password confirmation validation
PHP Laravel