/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

31 votes214 views4 answers
Php generate random string of characters
PHP
2 votes202 views1 answer
Remove phpmyadmin ubuntu 20.04 completely
PHP
-1 vote234 views1 answer
Create new record via model in laravel
PHP Laravel
0 vote210 views2 answers
Carbon add 3 hours
PHP
5 votes213 views1 answer
Check if user is on mobile php
PHP
1 vote242 views1 answer
Laravel validation in controller
PHP Laravel
0 vote240 views1 answer
Laravel database engine innodb
PHP Laravel
1 vote218 views2 answers
Laravel check if object is empty
PHP
0 vote208 views1 answer
Get deleted value laravel
PHP
0 vote218 views1 answer
Laravel routes options
PHP Laravel