/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 vote309 views1 answer
Laravel include files
PHP Laravel
1 vote222 views3 answers
Laravel api enable cors
PHP Laravel
5 votes222 views6 answers
Sync laravel
PHP Laravel
3 votes207 views2 answers
Laravel adding condition to relation
PHP Laravel
0 vote262 views1 answer
Laravel file permission denied
PHP Laravel
0 vote212 views2 answers
Laravel notification database
PHP Laravel
1 vote238 views1 answer
Laravel get last get request
PHP Laravel
0 vote226 views1 answer
Store image to s3 laravel
PHP Laravel
0 vote206 views1 answer
Laravel migration make auto increment
PHP Laravel
28 votes218 views6 answers
Laravel make model with migration
PHP Laravel