/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 vote347 views2 answers
Laravel return new tab
PHP Laravel
0 vote324 views1 answer
Laravel nginx permissions
PHP Laravel
5 votes327 views2 answers
Throwexception laravel
PHP Laravel
7 votes364 views4 answers
UUIDs LARAVEL
PHP Laravel
1 vote374 views1 answer
Image dimension when uploading in laravel validation
PHP Laravel
0 vote363 views1 answer
Response()->make laravel pdf
PHP Laravel
2 votes383 views4 answers
How to create controller inside folder in laravel
PHP Laravel
0 vote362 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
2 votes393 views1 answer
Laravel wherin softdelete
PHP Laravel
1 vote364 views1 answer
Laravel map array
PHP Laravel