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.
Questions tagged [bulkupdate]
299 questions
-1
votes
1 answer
How to update multiple rows in the table? Angular 7
In my project there is popup which contain multiple values in loop.
Every row contains Enable button which convert text into text boxes and in the end of page there is a button name "Update".Then all the enable rows values are goes as a API…
user2609024
- 13
- 1
- 6
-1
votes
1 answer
Bulk update SQL Server and Python
I have the following issues, i am selecting 17K records from Azure SQL server database into a list with Python, preforming text manipulation and i want to update the result into the database , i have two fields record_id and Supplier name , i added…
Nir Elbaz
- 556
- 4
- 19
-1
votes
1 answer
How to do bulk update using the Below query
Merge DBO1..tblinventoryStock_Targer as T
Using DBO2..tblinventoryStock_Source as S
on S.Inventorycode =T.Inventorycode and
S.Locationcode =T.Locationcode
when matched then
update set T.QtyOnhand =…
-1
votes
1 answer
Update Bulk Items with MySQL PHP
I'm trying to update over 3,000 records in my db table with one single bulk query, however I have run into a road block with my id array. Wondering what I'm doing wrong here?
Here is the error I receive:
check the manual that corresponds to your…
soulglow1985
- 141
- 1
- 10
-1
votes
2 answers
Designing a bulk REST API in Java
I have a problem with my appilication when am perfoming bulk update's and create's.
I have very huge rest pay load which contains 1000 fields and with 10000 update at a time. After submitting the request data will be save in db with jdbc…
Display name
- 1
- 3
-1
votes
1 answer
Update bulk number of records in oracle
I am new to sql. Can someone help me with this requirement.
I have table with 10000 records like this
CompanyID Name
300001 A
300004 B
300005 C
300007 D
|
|
|
310000 XXX
And I have a…
Siva GV
- 81
- 2
- 13
-1
votes
1 answer
MS SQL Bulk update\insert
Some time ago we faced with the problem of bulk insert\update into MS SQL database.
Task was pretty simple - retrieve data from DB, perform data transformation and update parent table and fill out child table. Volume of data is huge, that's why we…
alex_bondar
- 422
- 2
- 5
- 18
-2
votes
1 answer
Hide bulk actions from admin orders list except for processing status filtered list
Is there any way to hide bulk actions from admin orders list except for processing status filtered list: post_status=wc-processing where I only want to show bulk actions?
I tried to use code from How to remove bulk actions from admin orders page,…
David
- 7
- 3
-2
votes
1 answer
BULK INSERT/UPDATE statement syntax error?
I am trying to bulk insert or update the data from a csv file to a pre-existing table in a database in SQL and I keep getting the error "Incorrect syntax near keyword 'BULK'" and I've tried everything I can find on google.
Here is the code I am…
Morkaei
- 9
- 2
-2
votes
1 answer
sqlite3 bulk update from temporary table (CTE)
I want to update a special column of every row that meets certain criteria.
This two answeres seemed very promising, but sqlite3 (v 3.24.0) throws an error.
Update multiple rows with different values in a single SQL query
How to use CTE's with…
nkonde
- 1
- 2
-2
votes
1 answer
Bulk MySQL update instead of PHP While loop
I am using PHP code to update week ending date which is on a different day for each subdomain. Each subdomain date range varies.
My current code uses a while loop to update the week end date. This is very slow and I am looking for ideas to…
Adam
- 473
- 5
- 21
-3
votes
2 answers
How to compare and update millions of records in a oracle table?
We receive a CSV file every day, with millions of records. Each record is identified by a unique Id.
Day 1, load the daily file in a 'Master' table. The structure of the table is the same file plus one more column called offset. Initially the value…
tanatan
- 31
- 5
-3
votes
1 answer
How to update all tables in a database comparing with another database?
I have a database of more than 500 tables and now there is a copy of that database from an old backup.We noticed that there are many missing records in the new database which I would like to update from the old?
Whats the best practice to update…
aryan
- 49
- 6
-5
votes
1 answer
How to run php script
I have 7-8 php scripts written which pulls data from remote server and store it into our server. Each script insert/update around 3000-4000 records at a time. When I hit any script from browser it works fine(individual script) but if I try to call…
Shweta Shinde
- 11
- 5