/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

3 votes231 views4 answers
Round() laravel
PHP Laravel
1 vote221 views2 answers
Laravel blade dump
PHP Laravel
1 vote244 views1 answer
Laravel + join 2 eloquent queries
PHP Laravel
0 vote219 views1 answer
Trait 'laravel\sanctum\HasApiTokens' not found laravel 7
PHP Laravel
0 vote237 views1 answer
Foreach empty laravel
PHP Laravel
11 votes215 views2 answers
Laravel log level
PHP Laravel
5 votes254 views2 answers
Laravel APP_ENV config
PHP Laravel
4 votes223 views3 answers
Ubuntu where are laravel logs stored
PHP Laravel
0 vote211 views1 answer
Laravel api get controller
PHP Laravel
0 vote225 views1 answer
Orwhere in wherehas laravel
PHP Laravel