/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

1 vote182 views1 answer
Laravel profile migration tool
PHP Laravel
3 votes162 views2 answers
Name csrf token laravel mismatch
PHP Laravel
0 vote165 views1 answer
Multiple laravel site in one directory
PHP Laravel
53 votes323 views6 answers
Laravel where in
PHP Laravel
2 votes157 views2 answers
How set variable public in static method in laravel
PHP Laravel
0 vote156 views1 answer
Laravel where false
PHP Laravel
5 votes169 views4 answers
Laravel response redirect
PHP Laravel
0 vote157 views1 answer
Laravel many to many relation update
PHP Laravel
21 votes166 views2 answers
Long text in laravel migration
PHP Laravel
3 votes163 views2 answers
Create variable in laravel blade
PHP Laravel