/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

5 votes190 views4 answers
Laravel model wherein
PHP Laravel
1 vote175 views1 answer
Laravel add crf token form
PHP Laravel
2 votes177 views3 answers
Laravel many to many relationship with pivot table
PHP Laravel
0 vote177 views1 answer
Href in laravel view
PHP Laravel
0 vote166 views1 answer
Laravel8 can't read env
PHP Laravel
7 votes185 views3 answers
Laravel get latest
PHP Laravel
2 votes149 views1 answer
Laravel slug route
PHP Laravel
0 vote246 views1 answer
Failed to open stream permission denied laravel
PHP Laravel
12 votes186 views6 answers
Return redirect with message laravel
PHP Laravel
10 votes213 views2 answers
Convert collection to array laravel
PHP Laravel