/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

2 votes229 views2 answers
Update laravel 7 to 8
PHP Laravel
0 vote331 views1 answer
Laravel get old url
PHP Laravel
4 votes202 views2 answers
Laravel pass variables to view
PHP Laravel
0 vote213 views1 answer
Show selected value in dropdown laravel
PHP Laravel
1 vote206 views3 answers
Make model factory and controller laravel
PHP Laravel
2 votes205 views3 answers
Spartie all user with role get laravel
PHP Laravel
0 vote267 views1 answer
Env clear cache laravel
PHP Laravel
0 vote170 views1 answer
Redirect to attempting url after login laravel
PHP Laravel
13 votes191 views4 answers
Laravel migration remove column
PHP Laravel
0 vote285 views5 answers
Laravel create multiple models at once
PHP Laravel