/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

1 vote341 views1 answer
How to use bootstrap in laravel 8 remove tailwind
PHP Laravel
0 vote373 views1 answer
Check the existing image in s3 laravel
PHP Laravel
1 vote365 views1 answer
Get all errors view laravel
PHP Laravel
0 vote280 views1 answer
Laravel wordpress reset password
PHP Laravel
2 votes361 views1 answer
Laravel artisan create criteria
PHP Laravel
4 votes366 views5 answers
Laravel route multiple middleware
PHP Laravel
-1 vote360 views3 answers
Grouping route in laravel
PHP Laravel
3 votes346 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP Laravel
3 votes358 views1 answer
Date time laravel
PHP Laravel
53 votes438 views6 answers
Check laravel version
PHP Laravel