/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 vote200 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel
0 vote183 views1 answer
Laravel count data wise
PHP Laravel
9 votes171 views5 answers
Uuid in laravel
PHP Laravel
49 votes217 views6 answers
Laravel clear all cache
PHP Laravel
0 vote155 views1 answer
Array of dates laravel
PHP Laravel
2 votes167 views2 answers
Get session id in laravel
PHP Laravel
2 votes133 views2 answers
The requested url was not found on this server. laravel
PHP Laravel
0 vote161 views1 answer
Payment gateway webhook returning 302 laravel
PHP Laravel
6 votes154 views4 answers
Laravel previous url
PHP Laravel
12 votes146 views3 answers
For else laravel
PHP Laravel