/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 vote135 views1 answer
Laravel CORS config `allowed_origins` should be an array
PHP Laravel
3 votes154 views2 answers
Laravel base table or view not found hasmany
PHP Laravel
0 vote149 views1 answer
Laravel permission create role
PHP Laravel
8 votes144 views6 answers
Laravel eloquent with
PHP Laravel
0 vote156 views1 answer
Double in migration laravel
PHP Laravel
0 vote156 views1 answer
Null check nested object laravel
PHP Laravel
0 vote137 views1 answer
Composer new project laravel acl
PHP Laravel
0 vote149 views1 answer
Migrate only one table laravel
PHP Laravel
-1 vote139 views1 answer
Laravel Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on
PHP Laravel
57 votes312 views6 answers
How to create migration in laravel
PHP Laravel