/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

2 votes238 views1 answer
Find word in text in laravel
PHP Laravel
2 votes201 views1 answer
Return back in blade laravel
PHP Laravel
4 votes215 views3 answers
Laravel return json header json
PHP Laravel
6 votes232 views3 answers
Laravel ide helper
PHP Laravel
0 vote243 views1 answer
Auto reload for laravel
PHP Laravel
61 votes259 views6 answers
Cache clear in laravel
PHP Laravel
1 vote213 views1 answer
Select sum in laravel
PHP Laravel
3 votes222 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel
3 votes236 views1 answer
Laravel eloquent get column
PHP Laravel
31 votes227 views6 answers
Make model with migration laravel
PHP Laravel