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

What is the best method to update small records from a big database?

I have a database which contains all the data from a CSV that I downloaded from a botanic website, and I want to it always updated based on the version of this CSV. My problem is that the CSV is extremely huge, It contains at least 1 million records…
lambadeltaz
  • 57
  • 1
  • 4
0
votes
0 answers

Powershell: bulk parametr set

am trying to bulk edit "UsageLocation" for a list of users. Running against one UPN is working fine, but bulk not :-/ CSV example UPN user1@company.smt user2@compamy.smt user3@company.smt Import users from CSV $userlist = Import-Csv…
Ermess
  • 1
  • 1
0
votes
2 answers

Codeigniter update_batch in Core PHP

everyone. In the codeigniter there is update_batch function by using it we are able to bulk update multiple rows. $this->db->update_batch('table_name', $update_data_array, 'where_condition_field_name'); I want similar functionality in core PHP in…
Abhay
  • 1
0
votes
0 answers

How to bulk change external column values defined in Orders table and stored in database?

I am working on return processes in Woocommerce. I am getting returned or not returned information from table named return_table. I added this information to a new column in the orders table. The table is simply as follows: I need to make changes…
user14907549
0
votes
2 answers

Efficient way to perform an UPSERT with EFCore.BulkExtensions when data does not include primary key

I need to upload bulk data into a database through an API and I am looking at using EFCore.BulkExtensions. Unfortunately, the data will not include the auto-generated primary key (Id). However, we have a unique composite key that will be included in…
ChristyPiffat
  • 359
  • 1
  • 6
  • 26
0
votes
1 answer

Application design for bulk insert/update

I came across one use case where user may send bulk records through UI for Postgres table update . Maximum possible record is 60,000 Business logic will apply some logic on the data and insert/update 8 different tables There is already one Rest api…
Java_the_great
  • 331
  • 1
  • 2
  • 4
0
votes
1 answer

Efficient Bulk Insert/Update Operations on Existing Table Using SQLAlchemy

I am looking to insert/update a large volume of data stored in either a list of tuples or list of dictionaries into an existing table using SQLAlchemy. What is the most efficient way to do this? What I have right now is this, session_maker =…
Minura Punchihewa
  • 1,498
  • 1
  • 12
  • 35
0
votes
1 answer

Can't do bulk update using MariaDB, pool.query and Express

I have an API written in Express and MariaDB as DBMS, I'm trying to update multiple records at the same time using an array but it doesn't work. Example: const data = [ [ '2', '130' ], [ '4', '10' ] ] try { const updatedInventory = await…
vandret
  • 13
  • 2
0
votes
2 answers

How to bulk update 1000 records using C#/SQL

I am reading from a table with a million records, I perform some modifications to some columns and I would like to save them back in bulk. I would like to perform a bulk update after every 10000 records. I'm using .Net Core 3.1 My code : public void…
Ayoub Salhi
  • 312
  • 1
  • 4
  • 19
0
votes
1 answer

how to avoid select queries (for every entity separately) before bulk update (Hibernate -spring data jpa)

Im using the saveAll method by spring-data-jpa. I know that when i update an entity, hibernate needs to re-attach the detached entity and thats why before the update it executes select statements. But when i try to update about 10.000 entity it…
erdem
  • 103
  • 1
  • 11
0
votes
0 answers

Insert if not exists doesn't work. I have 20000 records in JSON file. I want to do insert/update into table from json table accordingly using SP

I want to update/insert records from Json table ( which has 5000 records) to another table . when I run for first time Insert works fine and when I update ,it updates accordingly. But when I ran again the same file with additional records it doesn't…
john
  • 119
  • 1
  • 8
0
votes
1 answer

How to update fields of related model in one query using Django ORM or SQL?

I want to update model fields and fields of related model in one query in Django: Link.objects.filter(alpha=True).update( alpha=False, target__backup_of_original_start=F('target__original_start'), …
shpindler
  • 357
  • 2
  • 12
0
votes
1 answer

Talend- Need to extract data from JSON (JSON array) and load it to Oracle DB

I have a Talend Job that receives a JSON(JSON format below) from a route. I need to extract data from JSON and load it to Oracle DB table. Job JSON format: { "data": [ { "name": "FRSC-01", "recordnum": "01", …
mavenuser
  • 5
  • 1
0
votes
0 answers

Salesforce Bulk API Lock Issue?

I'm trying to mass update child__c object linked to parent__c object using Salesforce Bulk-API. I will not modify any relations, so in my opinion there is no need to lock parent__c object. I do not know the parent__c.id, so I cannot order by the…
antidote
  • 127
  • 1
  • 12
0
votes
3 answers

Laravel: is there a way to execute fast bulk update?

I came across a method of fast bulk update in mySQL recently: The slow way: UPDATE `example` SET `name` = 'Mary', `age` = '20' WHERE id = 2; UPDATE `example` SET `name` = 'Nancy', `age` = '30' WHERE id = 4; UPDATE `example` SET `name` = 'Oliver',…
cr001
  • 655
  • 4
  • 16
1 2 3
…
19 20