/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

4 votes160 views2 answers
Auth guard (admin) is not defined laravel 8
PHP Laravel
0 vote220 views1 answer
Laravel 8 model filter
PHP Laravel
0 vote135 views1 answer
Laravel package for getID3()
PHP Laravel
8 votes147 views4 answers
Laravel model soft delete
PHP Laravel
22 votes196 views5 answers
Foreign key string laravel
PHP Laravel
0 vote146 views1 answer
Laravel set innodb scema builder
PHP Laravel
2 votes150 views2 answers
Laravel validation unique email except self
PHP Laravel
33 votes153 views4 answers
Carbon format date in laravel
PHP Laravel
0 vote156 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel
1 vote145 views1 answer
Laravel query get big table records
PHP Laravel