/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

2 votes190 views3 answers
Laravel get file size uploaded
PHP Laravel
0 vote163 views1 answer
Redirect to attempting url after login laravel
PHP Laravel
1 vote211 views1 answer
Laravel validation required_if one parameter exist
PHP Laravel
0 vote191 views1 answer
Laravel routes return view in web.php
PHP Laravel
0 vote189 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel
1 vote198 views1 answer
Laravel clone row
PHP Laravel
-1 vote191 views1 answer
Echo in console command laravel
PHP Laravel
1 vote190 views2 answers
Cart::subtotal in laravel
PHP Laravel
0 vote189 views2 answers
Laravel composite unique key
PHP Laravel
0 vote223 views1 answer
Laravelda so`rovlarni cheklash
PHP Laravel