/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

11 votes339 views6 answers
Php curl
PHP
0 vote340 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel
3 votes258 views5 answers
Php artisan jwt secret
PHP
2 votes248 views1 answer
How to set field type of date of birth in laravel
PHP
0 vote249 views1 answer
Array filter multiple conditions php
PHP
1 vote302 views1 answer
Laravel failed jobs retry
PHP Laravel
0 vote272 views1 answer
Wp_post wordpress
PHP Wordpress
16 votes254 views3 answers
Change existing migration laravel
PHP
5 votes268 views1 answer
Laravel rate limit
PHP Laravel
0 vote262 views1 answer
Laravel-medialibrary packagist
PHP