/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 vote171 views1 answer
Function inside model laravel
PHP Laravel
22 votes153 views5 answers
Update or insert in laravel
PHP Laravel
3 votes163 views2 answers
Laravel required if it meet some value from another field
PHP Laravel
0 vote176 views1 answer
How to add page link in laravel
PHP Laravel
49 votes236 views6 answers
Laravel clear all cache
PHP Laravel
0 vote162 views1 answer
Laravel eloquent get x number of results
PHP Laravel
0 vote204 views3 answers
Writing into the database with one click laravel
PHP Laravel
9 votes184 views3 answers
Laravel join 2 tables eloquent
PHP Laravel
0 vote161 views1 answer
Laravel app service provider why eloquent model error
PHP Laravel
1 vote169 views1 answer
Laravel s3 presigned url
PHP Laravel