/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 vote274 views1 answer
Include navbar or part in layout in laravel blade template
PHP Laravel
1 vote237 views1 answer
Causes of class not found in laravel
PHP Laravel
2 votes251 views2 answers
Echo query in laravel
PHP Laravel
6 votes261 views3 answers
Previous url laravel
PHP Laravel
3 votes271 views2 answers
Laravel required if it meet some value from another field
PHP Laravel
2 votes259 views3 answers
Laravel model particular column
PHP Laravel
-3 votes252 views8 answers
@foreac laravel
PHP Laravel
0 vote213 views5 answers
Laravel authentication in laravel 8
PHP Laravel
10 votes260 views4 answers
Laravel create
PHP Laravel
1 vote259 views1 answer
Integer nullable laravel
PHP Laravel