/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

1 vote163 views1 answer
Laravel where multiple conditions on single colmn
PHP Laravel
27 votes230 views3 answers
Laravel what is migrations
PHP Laravel
1 vote212 views5 answers
Laravel modules
PHP Laravel
0 vote160 views3 answers
Laravel how to fetch user from user model based on id from post
PHP Laravel
2 votes159 views2 answers
Laravel show table columns
PHP Laravel
5 votes171 views2 answers
Laravel access controller method from another controller
PHP Laravel
47 votes211 views6 answers
How to add new column in laravel migration
PHP Laravel
0 vote176 views1 answer
Illuminate\contracts\container\bindingresolutionexception: target class laravel 8
PHP Laravel
3 votes171 views2 answers
Different days in carbon laravel between different dates
PHP Laravel
0 vote176 views1 answer
Laravel factory relationship one to many
PHP Laravel