/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 vote364 views1 answer
How check if variable is resgister in laravel
PHP Laravel
0 vote359 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
1 vote451 views1 answer
How laravel return the old value
PHP Laravel
0 vote398 views1 answer
Debugbar:clear in laravel
PHP Laravel
0 vote383 views1 answer
Laravel controller constructor auth user null
PHP Laravel
0 vote413 views1 answer
Check laravel first null
PHP Laravel
23 votes365 views6 answers
Laravel model insert
PHP Laravel
10 votes373 views2 answers
Format date in laravel using carbon
PHP Laravel
0 vote372 views1 answer
Laravel env asset_url
PHP Laravel
1 vote371 views2 answers
Insert batch in laravel
PHP Laravel