/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

1 vote307 views2 answers
Laravel return response view
PHP Laravel
10 votes371 views2 answers
Array to string conversion in laravel controller
PHP Laravel
0 vote326 views1 answer
Laravel phpdoc collection of model
PHP Laravel
0 vote343 views1 answer
Laravel keep old input
PHP Laravel
8 votes375 views1 answer
How to migrate single table in laravel
PHP Laravel
1 vote359 views1 answer
How to pass data to controller in laravel
PHP Laravel
0 vote331 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
20 votes360 views6 answers
Laravel 8 make:auth
PHP Laravel
0 vote366 views2 answers
Php artisan app:name in laravel 6
PHP Laravel
0 vote342 views2 answers
Laravel event listener
PHP Laravel