/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

4 votes334 views2 answers
Laravel please provide a valid cache path
PHP Laravel
1 vote291 views4 answers
Laravel form request validation api
PHP Laravel
10 votes298 views2 answers
Try and catch laravel
PHP Laravel
2 votes317 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
0 vote301 views1 answer
Laravel validation unique if this field is changed
PHP Laravel
28 votes329 views5 answers
Migrate specific table laravel
PHP Laravel
1 vote295 views1 answer
Why storage link do not work in host for laravel
PHP Laravel
3 votes276 views5 answers
Laravel permission
PHP Laravel
12 votes278 views4 answers
Bcrypt laravel
PHP Laravel
19 votes307 views6 answers
Laravel date validation
PHP Laravel