/PHP/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.

Similar codes

2 votes186 views1 answer
Laravel model string primary key
PHP Laravel
1 vote168 views2 answers
How to install php dependencies
PHP
5 votes116 views9 answers
Laravel socialite
PHP
0 vote141 views2 answers
Laravel composer sanctum
PHP
0 vote145 views2 answers
Faker image laravel
PHP
6 votes140 views2 answers
Php string cut first x characters
PHP
0 vote178 views2 answers
Php radians to degrees
PHP
4 votes110 views1 answer
Opencart order change status
PHP
1 vote157 views1 answer
Laravel remove apostrophe variables
PHP Laravel
0 vote133 views1 answer
What is php?
PHP