/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 votes369 views2 answers
Laravel migration column type json
PHP Laravel
0 vote443 views2 answers
Undefined index token in get_request_headers
PHP
7 votes313 views2 answers
Laravel unique multiple columns
PHP Laravel
0 vote347 views1 answer
Diffforhumans laravel
PHP Laravel
2 votes299 views1 answer
Phpmyadmin first login
PHP
4 votes341 views2 answers
Php get list of filenames in diretory
PHP
0 vote296 views1 answer
How to create header in csv file inphp
PHP
7 votes315 views2 answers
Prevent SQL injection in PHP?
PHP
1 vote299 views1 answer
Get file each line in php
PHP
23 votes299 views6 answers
Laravel validation messages
PHP