/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 vote167 views1 answer
Laravel deleted controller still cached
PHP Laravel
2 votes154 views2 answers
Create custom rule in laravel
PHP Laravel
48 votes159 views6 answers
Laravel join table
PHP Laravel
1 vote192 views2 answers
Laravel check if email is real
PHP Laravel
3 votes134 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel
0 vote115 views1 answer
Laravel auth without vue or bootstrap
PHP Laravel
0 vote134 views1 answer
Laravel eloquent order by alphabetical order
PHP Laravel
1 vote127 views1 answer
Laravel create on model
PHP Laravel
6 votes148 views1 answer
How to add new column in table laravel
PHP Laravel
0 vote128 views1 answer
Laravel blade all syntex description
PHP Laravel