/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 vote123 views1 answer
Getting key from env returns null laravel
PHP Laravel
16 votes111 views6 answers
Laravel group routes
PHP Laravel
0 vote106 views1 answer
Create new controller laravel with model binding
PHP Laravel
4 votes114 views2 answers
Laravel kill current session
PHP Laravel
2 votes136 views1 answer
Laravel middleware
PHP Laravel
19 votes106 views6 answers
Laravel 8 make model with migration and controller
PHP Laravel
0 vote110 views1 answer
Check the existing image in s3 laravel
PHP Laravel
3 votes117 views2 answers
Create .env file in laravel with cmd
PHP Laravel
0 vote119 views1 answer
Laravel convert eloquent collection to collection
PHP Laravel
0 vote103 views1 answer
Handling deadlocks laravel
PHP Laravel