/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 vote340 views1 answer
How login with phone in laravel
PHP Laravel
0 vote300 views1 answer
Laravel 8 template favicon
PHP Laravel
0 vote278 views5 answers
Date format change in laravel
PHP Laravel
0 vote292 views1 answer
Laravel delete controller still cached
PHP Laravel
0 vote283 views1 answer
Morph relation laravel
PHP Laravel
0 vote285 views1 answer
Appserviceprovider laravel auth user
PHP Laravel
0 vote274 views1 answer
Migrate only one table laravel
PHP Laravel
0 vote294 views1 answer
Laravel change error page to open in vscode
PHP Laravel
-1 vote270 views3 answers
Delete rows by migration laravel
PHP Laravel
0 vote280 views3 answers
Laravel validation alphanumeric with spaces
PHP Laravel