/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 vote122 views1 answer
Laravel sendgrid using 2 possible authenticators. Authenticator LOGIN returned Expected response code 250
PHP Laravel
0 vote146 views1 answer
How to migrate new column without empty the table in laravel
PHP Laravel
6 votes202 views1 answer
Laravel get client public ip
PHP Laravel
4 votes141 views2 answers
Laravel session forget
PHP Laravel
3 votes123 views2 answers
Laravel migration on delete set null
PHP Laravel
10 votes139 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel
1 vote135 views3 answers
Print query statement in laravel
PHP Laravel
0 vote155 views1 answer
Artisan laravel require bootstrap
PHP Laravel
0 vote152 views5 answers
Laravel Scheduler
PHP Laravel
7 votes153 views4 answers
UUIDs LARAVEL
PHP Laravel