/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

3 votes358 views1 answer
Print session in laravel
PHP Laravel
0 vote348 views1 answer
How to update all row in laravel
PHP Laravel
0 vote331 views1 answer
Clear from faild_jobs laravel
PHP Laravel
0 vote354 views1 answer
Stdclass not found laravel
PHP Laravel
2 votes298 views1 answer
Laravel create txt file
PHP Laravel
2 votes362 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP Laravel
2 votes404 views1 answer
Laravel how to test email testing
PHP Laravel
1 vote351 views1 answer
How to alias table name in laravel model
PHP Laravel
1 vote360 views5 answers
Laravel jobs tutorial
PHP Laravel
12 votes352 views6 answers
Set session data in laravel
PHP Laravel