/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 votes214 views1 answer
Laravel project editor
PHP Laravel
11 votes192 views6 answers
Datetime validation in laravel
PHP Laravel
7 votes295 views5 answers
Search laravel
PHP Laravel
4 votes202 views4 answers
Search in laravel 8
PHP Laravel
2 votes210 views2 answers
Laravel eloquent randomise data from database
PHP Laravel
2 votes207 views2 answers
File exist check in laravel blade
PHP Laravel
0 vote198 views1 answer
Laravel check if postback
PHP Laravel
0 vote219 views2 answers
Insert multiple rows laravel
PHP Laravel
12 votes228 views5 answers
Laravel transactions
PHP Laravel
4 votes217 views5 answers
Laravel with and where
PHP Laravel