/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 votes177 views2 answers
Valdidate laravel if falid
PHP Laravel
0 vote136 views1 answer
How to pass variable to an event listener laravel
PHP Laravel
1 vote117 views3 answers
Laravel required if
PHP Laravel
0 vote148 views6 answers
Use varable on all site pages laravel
PHP Laravel
11 votes116 views3 answers
Laravel get last month records
PHP Laravel
1 vote109 views1 answer
Laravel env google smtp
PHP Laravel
9 votes125 views5 answers
Uuid in laravel
PHP Laravel
1 vote76 views1 answer
Use username instead of email laravel
PHP Laravel
3 votes120 views1 answer
Run laravel cron job on cpanel
PHP Laravel
1 vote120 views2 answers
Url segment in laravel
PHP Laravel