/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 vote289 views1 answer
Laravel model isdirty
PHP Laravel
2 votes317 views2 answers
Public_path laravel
PHP Laravel
1 vote291 views1 answer
Pass model in function laravel
PHP Laravel
1 vote260 views1 answer
Laravel http retry
PHP Laravel
13 votes280 views6 answers
Prefix laravel route
PHP Laravel
0 vote337 views1 answer
How to create module in laravel
PHP Laravel
4 votes299 views5 answers
Add csrf token laravel
PHP Laravel
5 votes323 views5 answers
Laravel where creation is today carbon
PHP Laravel
11 votes319 views6 answers
Laravel route
PHP Laravel
5 votes257 views5 answers
Group by laravel
PHP Laravel