/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 votes318 views2 answers
Laravel show table columns
PHP Laravel
0 vote270 views1 answer
Laravel create project with auth 2021
PHP Laravel
2 votes279 views1 answer
Laravel blade file naming conventine
PHP Laravel
0 vote327 views1 answer
How to create module in laravel
PHP Laravel
13 votes258 views6 answers
Laravel migration change column type
PHP Laravel
2 votes246 views1 answer
Laravel slug route
PHP Laravel
0 vote306 views1 answer
Laravel app service provider why eloquent model error
PHP Laravel
0 vote276 views1 answer
Str not found laravel
PHP Laravel
7 votes302 views3 answers
How to remove public from url in laravel 8
PHP Laravel
0 vote275 views1 answer
Laravel automatically generate unique username
PHP Laravel