/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

3 votes284 views1 answer
Laravel middleware route
PHP Laravel
23 votes200 views5 answers
Laravel seed specific file
PHP
0 vote146 views1 answer
Php percent sign
PHP
2 votes155 views1 answer
Laravel register false
PHP
0 vote229 views5 answers
Run schedule laravel
PHP
7 votes208 views1 answer
Laravel wher in
PHP Laravel
0 vote177 views2 answers
Separate date from datetime php
PHP
4 votes288 views5 answers
Php variable in string
PHP
-1 vote147 views2 answers
Wp websites login
PHP
1 vote181 views1 answer
Php pdo check if update query successful
PHP