Stack Overflow
Stack Overflow

Questions tagged [bulkupdate]

Bulk update a database

Methods to bulk update a database with single or multiple columns of data. This could be either unique data for each row or same data for a column.

299 questions
0
votes
2 answers

Bulk change all entries for a particular column in a SQL Server database

Problem: I am trying to insert a .csv file with thousands/millions of rows into a SQL Server table with a bulk insert query. Now I want to update the table with bulk update where specific column is change e.g where price is changed. How can I do…
Malik Kashmiri
  • 5,741
  • 11
  • 44
  • 80
0
votes
2 answers

couchdb doc property based on existing property: bulk update

I have a million documents that I need to transform. Each document looks like this: { "_id": "00082786797c0a31ab8b5e67fb0000dc", "_rev": "3-d67692b1c94b936ae913bf7ea4896bed", "type": "Feature", "properties": { "timestamp": "2015-08-03…
user3362424
  • 11
  • 5
0
votes
0 answers

mongodb multiple update performance while building a new index

We need to add a new field along with an index to a huge collection of documents in mongodb. We've created an index for the new field, and then started running a script that uses UnorderedBulkOp to update each document and add that field to it. The…
marmor
  • 27,641
  • 11
  • 107
  • 150
0
votes
0 answers

SQLAlchemy - Bulk update using sqlalchemy core table.update() expects all columns in the values data

I'm trying to do a bulk update using core SQLAlchemy to a postgres database. bulk_update_mappings does not work (reports StaleDataError). So I'm trying to use core functions to do a bulk update. This works fine when the update data passed to the…
nektar
  • 73
  • 6
0
votes
1 answer

How to multiupdate using a deque instead of find in MongoDB?

I'm trying to overload a method, allowing it to increment the count of several documents in a one multi update to optimize DB accessing. The current (single update) method looks like: static synchronized void updateDb(String col, DBObject oldDoc) { …
Anders Bernard
  • 541
  • 1
  • 6
  • 19
0
votes
1 answer

Bulk update Postgres column from python dataframe

I am using the below python code to update postgres DB column valuebased on Id. This loop has to run for thousands of records and it is taking longer time. Is there a way where I can pass array of dataframe values instead of looping each row? for…
Prasad
  • 175
  • 1
  • 2
  • 9
0
votes
1 answer

How to pass bulk data for update listing attributes with flipkart listing Management api using PHP

I want to update listing attribute like stock count ,pricing in bulk using php. I check Flipcart api doc https://seller.flipkart.com/api-docs/listing-api-docs/LMAPIRef.html there i got these…
Urvashi
  • 239
  • 2
  • 10
0
votes
3 answers

T-SQL - Update long list of values based on long list of ids

It may seem as a straight forward task, but I can't really find a good approach. I have a long list of ids with a long list of corresponding values to update for a field (a single field) id = 1 | field = value_1 id = 2 | field =…
AdrianD
  • 279
  • 4
  • 20
0
votes
1 answer

Insert/Update bulk data to sql table in entity framework

I have one product table with consist of product number , price and currency. I upload the data through excel file with the data. When i upload the data then i create a list at back end with all data from excel and then send entire list to server to…
Hector
  • 31
  • 1
  • 9
0
votes
4 answers

Pl sql block to update a table with periodic commit with values from temp table

I am new to PL/SQL . I have a requirement to update phone number in table employee_details where in the old phone number and new phone number is stored in another table phone_no (columns are old_phone_no and new_phone_no) I want to take the first…
Anonymous
  • 11
  • 1
  • 2
0
votes
2 answers

How do I bulk update Salesforce records using NodeJS?

I'm looking to bulk update Salesforce records with NodeJS. I've been using the JSForce library for most Salesforce transactions and it works great, however the Bulk Update method only seems to Bulk update a set of records with the same information…
Patrick
  • 493
  • 1
  • 6
  • 10
0
votes
1 answer

Update in bulk through JDBC batch gives SQLException TransactionImpl

I'm using EJB3 with Oracle database and JDBC. I'm working on an app where I have to fire 25000 UPDATE queries. My code is as follows: public int updateStatus(List idList) { Connection connection = getConnection(); // Connection…
RAS
  • 8,100
  • 16
  • 64
  • 86
0
votes
0 answers

Update 30k to 40k records from screen all with different values

I have a screen where a user click a button to start a process and the backend process will update a set of records (around 20k - 60k ) with different values (wat ever it should be). The "Where" clause that I am using is indexed but the process is…
chapter473
  • 15
  • 7
0
votes
1 answer

Oracle Pro*C updating with host arrays sometimes updating less rows than host array has

I'm using host arrays to insert and update data as shown in Oracle manual. Here is a bit of code: in my_func(void* ctx, int run_id, DB_DATA** db_data) { int i = 0; EXEC SQL BEGIN DECLARE SECTION; int ora_id_run[BULK_SIZE]; int…
hasnobrains
  • 109
  • 6
0
votes
1 answer

How to implement all Inserts, Updates, Delete operations at once in bulk in ASP:ListView

I have an Asp:ListView control which I am showing in a pop up in a web form. Currently, it does all the changes directly in database as soon as I click the Insert, Update or Delete LinkButtons. But I need all the changes to be done in database only…
Ridhi Jain
  • 19
  • 1
  • 3
1 2 3
…
19 20