/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

8 votes148 views6 answers
Laravel session
PHP
0 vote106 views1 answer
Laravel (8) - Routing to controller with optional parameters
PHP
14 votes118 views5 answers
Laravel debugbar
PHP Laravel
0 vote141 views2 answers
Csv utf-8 excel into php
PHP
18 votes109 views6 answers
Redirect to route laravel
PHP
4 votes110 views2 answers
Php array to console
PHP
5 votes121 views5 answers
Laravel get all request parameters
PHP Laravel
0 vote138 views1 answer
Laravel command Retrieve a specific option
PHP Laravel
0 vote113 views1 answer
Load player avatar url
PHP
1 vote100 views1 answer
Php single quote vs double quote
PHP