/PHP/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.

Similar codes

1 vote356 views1 answer
How to add property to the request object in laravel
PHP
9 votes393 views6 answers
Laravel validation custom message
PHP Laravel
0 vote321 views1 answer
Foreach comma separated string php
PHP
0 vote346 views2 answers
Current date time in php for input
PHP
2 votes360 views5 answers
Laravel drop table migration
PHP
-1 vote402 views1 answer
Chrome web driver laravel
PHP Laravel
3 votes339 views2 answers
Laravel carbon created_at date in current month
PHP
1 vote316 views1 answer
How validate the becrypt password in laravel
PHP
0 vote321 views1 answer
How to loop array in laravel
PHP
0 vote429 views1 answer
Users not having any role laravel spatie
PHP Laravel