/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

4 votes256 views2 answers
Laravel collection count
PHP Laravel
2 votes279 views1 answer
Multiple logical condition in laravel query
PHP Laravel
0 vote261 views2 answers
Laravel pagination vuetify
PHP Laravel
37 votes289 views4 answers
Foreign key in laravel migration
PHP Laravel
18 votes269 views1 answer
Schema::default string laravel
PHP Laravel
0 vote260 views1 answer
Laravel mcq questions
PHP Laravel
0 vote267 views1 answer
Laravel share on whatsapp link
PHP Laravel
0 vote295 views2 answers
Reload page laravel
PHP Laravel
63 votes324 views6 answers
Laravel artisan clear cache
PHP Laravel
7 votes266 views6 answers
Laravel url
PHP Laravel