/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 vote172 views1 answer
Many to many relationship in laravel example stackoverflow
PHP Laravel
5 votes177 views2 answers
Laravel blade upper case
PHP Laravel
0 vote177 views1 answer
How to excluse csrf in a route laravel
PHP Laravel
0 vote185 views1 answer
Sort by number of views descending laravel
PHP Laravel
1 vote197 views1 answer
How refresh the record of data in laravel
PHP Laravel
6 votes162 views3 answers
How to get parameter from url in laravel blade
PHP Laravel
8 votes167 views6 answers
Laravel eloquent with
PHP Laravel
0 vote188 views1 answer
Laravel permission spatie cache clear
PHP Laravel
0 vote182 views1 answer
Laravel collection has
PHP Laravel
4 votes163 views2 answers
Laravel form method delete
PHP Laravel