/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 vote135 views1 answer
Laravel secure url with query string
PHP Laravel
0 vote138 views1 answer
Touches in laravel
PHP Laravel
2 votes137 views4 answers
Laravel has many
PHP Laravel
0 vote138 views1 answer
Mixed content laravel form target
PHP Laravel
0 vote134 views1 answer
Laravel console example
PHP Laravel
7 votes142 views5 answers
Laravel if else condition in blade file
PHP Laravel
0 vote136 views1 answer
Laravel get previous route without domain
PHP Laravel
8 votes114 views1 answer
Laravel link storage to public
PHP Laravel
5 votes146 views5 answers
Unique laravel migration
PHP Laravel
0 vote130 views1 answer
How to change laravel logo image
PHP Laravel