/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 vote291 views5 answers
Laravel create multiple models at once
PHP Laravel
1 vote227 views2 answers
Scheduling in laravel in custom cron
PHP Laravel
0 vote200 views1 answer
Laravel post request page csrf disable
PHP Laravel
1 vote219 views1 answer
Parametre grouping laravel quert
PHP Laravel
3 votes211 views1 answer
Laravel validation number greater than 0
PHP Laravel
12 votes320 views4 answers
Laravel return redirect to named route
PHP Laravel
1 vote224 views2 answers
Laravel route group middleware prefix
PHP Laravel
0 vote211 views2 answers
Sortbydesc on a collection laravel
PHP Laravel
51 votes554 views6 answers
Laravel run all seeders
PHP Laravel
0 vote282 views1 answer
Laravel count data wise
PHP Laravel