/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

3 votes80 views2 answers
Clear cache via route laravel
PHP Laravel
4 votes29 views2 answers
Laravel get current route in app.js
PHP Laravel
1 vote66 views1 answer
Searchable dropdown laravel blade
PHP Laravel
24 votes95 views4 answers
Clear cache command in laravel controller
PHP Laravel
1 vote88 views2 answers
How console log laravel
PHP Laravel
-1 vote94 views1 answer
Create user with tinker php laravel
PHP Laravel
0 vote75 views1 answer
How to add a clock in laravel
PHP Laravel
0 vote66 views1 answer
Laravel import xml to database
PHP Laravel
0 vote82 views1 answer
Laravel db query log string replacements
PHP Laravel
1 vote86 views1 answer
Laravel form action with parameter
PHP Laravel