/PHP/Laravel/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.

Source: grepper.com

Similar codes

12 votes212 views2 answers
Laravel query with trashed
PHP Laravel
0 vote203 views3 answers
Database and files backup laravel
PHP Laravel
0 vote184 views1 answer
Get data from model in chunks laravel
PHP Laravel
0 vote221 views1 answer
Laravel easy form
PHP Laravel
1 vote203 views1 answer
Laravel 8 plural singular
PHP Laravel
0 vote157 views1 answer
Default null migration laravel
PHP Laravel
0 vote201 views1 answer
Laravelda urlga keladigan so`rovlarni cheklash
PHP Laravel
0 vote218 views1 answer
Dummy data in laravel
PHP Laravel
5 votes186 views2 answers
Laravel filter
PHP Laravel
3 votes197 views1 answer
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file laravel
PHP Laravel