/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

2 votes316 views1 answer
Laravel ever over https
PHP Laravel
5 votes326 views5 answers
Table drop foreign php laravel
PHP Laravel
16 votes273 views4 answers
Laravel auth helper function
PHP Laravel
1 vote296 views1 answer
Laravel nova 3 belongtomany don't display
PHP Laravel
3 votes312 views1 answer
How validate array in laravel in request
PHP Laravel
43 votes279 views6 answers
Laravel cache
PHP Laravel
0 vote301 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
5 votes275 views6 answers
Laravel 8 auth
PHP Laravel
3 votes289 views1 answer
Run laravel cron job on cpanel
PHP Laravel
9 votes299 views3 answers
Laravel load view in variable
PHP Laravel