/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 vote88 views1 answer
Sometimes validation in laravel
PHP Laravel
18 votes89 views6 answers
Laravel rename table
PHP Laravel
0 vote104 views1 answer
Laravel subtract date
PHP Laravel
1 vote78 views1 answer
Laravel realation with has
PHP Laravel
0 vote81 views1 answer
Auto reload for laravel
PHP Laravel
1 vote98 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
2 votes90 views2 answers
Laravel validation if data exists
PHP Laravel
2 votes99 views2 answers
Laravel get default locale
PHP Laravel
-2 votes92 views1 answer
Laravel model bind with route in model
PHP Laravel
1 vote97 views1 answer
Stack once laravel
PHP Laravel