/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 vote145 views1 answer
Laravel route contains particular segment
PHP Laravel
0 vote153 views1 answer
Laravel select option form add please select option
PHP Laravel
0 vote145 views1 answer
Array of dates laravel
PHP Laravel
6 votes131 views6 answers
Laravel get current route url
PHP Laravel
0 vote210 views1 answer
How to take last entry in database in laravel Method Three
PHP Laravel
53 votes283 views6 answers
Laravel join
PHP Laravel
0 vote137 views1 answer
Laravel query foreach
PHP Laravel
-1 vote119 views2 answers
Laravel 5.6 orderby
PHP Laravel
0 vote134 views1 answer
Configuration laravel dompdf
PHP Laravel
3 votes189 views2 answers
Laravel model exists id
PHP Laravel