/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 vote275 views2 answers
Laravel notification database
PHP Laravel
0 vote237 views10 answers
Laravel relations find
PHP Laravel
12 votes262 views2 answers
Laravel query with trashed
PHP Laravel
3 votes240 views3 answers
Laravel pagination having raw query not working
PHP Laravel
5 votes263 views3 answers
Laravel if request has
PHP Laravel
3 votes209 views1 answer
Laravel inrandomorder
PHP Laravel
10 votes305 views4 answers
Laravel migration change column default
PHP Laravel
1 vote255 views2 answers
Install laravel in ubuntu 20.04
PHP Laravel
1 vote237 views1 answer
Autoload file laravel
PHP Laravel
4 votes239 views2 answers
Delete all rows in table laravel
PHP Laravel