/PHP/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.

Similar codes

2 votes188 views2 answers
Get_boundary_post wordpress
PHP Wordpress
3 votes168 views1 answer
Laravel remove controller
PHP
0 vote206 views1 answer
Laravel response json status 500
PHP Laravel
0 vote164 views1 answer
Update Query in Codeigniter Using Multiple Where Condition
PHP
1 vote247 views1 answer
Strpos codeigniter php 7
PHP CodeIgniter
2 votes155 views1 answer
Laravel required if another field has value
PHP
0 vote191 views1 answer
Check null in laravel blade
PHP Laravel
15 votes201 views6 answers
Transaction laravel
PHP Laravel
1 vote164 views1 answer
For loop php increment by 2
PHP
0 vote193 views1 answer
Laravel asset prevent browser caching
PHP