/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 vote207 views1 answer
Get all errors view laravel
PHP Laravel
0 vote206 views1 answer
Laravel lang with parameter
PHP Laravel
37 votes227 views4 answers
Foreign key in laravel migration
PHP Laravel
1 vote223 views3 answers
Laravel get url segment
PHP Laravel
0 vote226 views1 answer
Laravel count without pagination
PHP Laravel
7 votes223 views5 answers
Jetstream laravel
PHP Laravel
0 vote235 views1 answer
Laravel add package without updating
PHP Laravel
0 vote219 views4 answers
Upload image in laravel
PHP Laravel
2 votes208 views1 answer
Laravel meilisearch flush
PHP Laravel
5 votes205 views3 answers
Laravel validation time hours minutes format
PHP Laravel