/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

3 votes227 views2 answers
Laravel where condition on relationship
PHP Laravel
0 vote219 views1 answer
How to wirte laravel dd function in php
PHP Laravel
3 votes228 views2 answers
Set image asset path in laravel
PHP Laravel
0 vote242 views1 answer
How to clear artisan in laravel
PHP Laravel
0 vote228 views1 answer
Laravel convert eloquent collection to collection
PHP Laravel
14 votes221 views6 answers
Laravel Password Validation
PHP Laravel
0 vote221 views1 answer
Make() laravel
PHP Laravel
0 vote229 views1 answer
Laravel migration folder
PHP Laravel
0 vote222 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP Laravel
10 votes230 views4 answers
Print last query laravel
PHP Laravel