/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 votes209 views2 answers
Send multiple attachment in mail laravel 8
PHP Laravel
5 votes233 views2 answers
Laravel vue
PHP Laravel
14 votes183 views4 answers
Laravel transactions eloquent
PHP Laravel
1 vote253 views1 answer
Laravel multiple orderby
PHP Laravel
1 vote196 views1 answer
Human readable date laravel
PHP Laravel
-1 vote201 views1 answer
Add method to laravel blade
PHP Laravel
13 votes212 views6 answers
Prefix laravel route
PHP Laravel
6 votes182 views2 answers
Installing livewire on laravel v6
PHP Laravel
1 vote221 views2 answers
How console log laravel
PHP Laravel
0 vote188 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel