/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 vote304 views1 answer
Appserviceprovider laravel share common settings for all controllers
PHP Laravel
28 votes343 views6 answers
Laravel drop foreign key
PHP Laravel
2 votes317 views2 answers
Laravel 5.8 cors
PHP Laravel
6 votes358 views3 answers
Laravel passport login with username
PHP Laravel
0 vote360 views2 answers
How change default value for enum colun in laravel
PHP Laravel
2 votes370 views3 answers
Spartie all user with role get laravel
PHP Laravel
4 votes343 views3 answers
Laravel 7 eloquent on delete set null schema
PHP Laravel
0 vote359 views3 answers
Laravel has many deep
PHP Laravel
15 votes357 views4 answers
Laravel session flash 2020
PHP Laravel
0 vote379 views1 answer
Can i do a relation between 2 coulnm in mongodb laravel
PHP Laravel