/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

0 vote197 views1 answer
Find curren monday in laravel carbon
PHP Laravel
0 vote209 views1 answer
Laravel firstorcreate with multiple parameters
PHP Laravel
0 vote190 views1 answer
Delete folder laravel
PHP Laravel
0 vote197 views1 answer
Laravel checkbox checked
PHP Laravel
0 vote169 views1 answer
Laravel migration first or model first
PHP Laravel
0 vote177 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
1 vote192 views1 answer
How convert the date and time to integer in laravel
PHP Laravel
2 votes212 views2 answers
How uninstall the laravel
PHP Laravel
5 votes201 views2 answers
Set unique value validation for laravel form request
PHP Laravel
63 votes285 views6 answers
Clear all cache in laravel
PHP Laravel