/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 vote393 views1 answer
Laravel with callback
PHP Laravel
0 vote360 views1 answer
Laravel 8 - get values of url query strings in controller
PHP Laravel
0 vote373 views1 answer
Use s3 storage laravel
PHP Laravel
0 vote380 views1 answer
Get value mentthod get laravel
PHP Laravel
2 votes353 views3 answers
Php laravel dump
PHP Laravel
0 vote377 views1 answer
Laravel creating_table_name
PHP Laravel
0 vote381 views1 answer
Laravel How to access imagen uploaded in storage
PHP Laravel
15 votes377 views3 answers
Get id user login laravel
PHP Laravel
0 vote359 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
0 vote354 views1 answer
Laravel vue browser cache auto clear
PHP Laravel