/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 vote146 views1 answer
Laravel get biggest id
PHP Laravel
0 vote127 views1 answer
Disable laravel cors
PHP Laravel
1 vote132 views2 answers
Laravel view with data in blade
PHP Laravel
4 votes137 views2 answers
Ubuntu laravel storage permission
PHP Laravel
21 votes144 views6 answers
Laravel seeder update
PHP Laravel
0 vote144 views6 answers
Laravel tips
PHP Laravel
0 vote130 views1 answer
Php value to javascript variable laravel blade
PHP Laravel
0 vote126 views1 answer
Editing items in collection in laravel
PHP Laravel
0 vote134 views1 answer
Defining constant in config laravel
PHP Laravel
48 votes196 views5 answers
Laravel clear route cache
PHP Laravel