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
0
votes
3 answers
MongoDB multiple update attributes
I have a collection A that has documents in form of:
{
_id: 12345,
title: "title"
}
and document B in form of:
{
_id: 12345,
newAttribute: "newAttribute12345"
}
I want to update collection A to have documents like:
{
_id: 12345,
title:…
taminov
- 591
- 7
- 23
0
votes
2 answers
Bulk insert or update yii2
What I did
I am inserting bulk data in table as follows:
if(count($bulkInsertArray)>0){
$columnNameArray=['columnName1','columnName2','columnName3'];
// below line insert all your record and return number of rows inserted
$insertCount =…
Er.KT
- 2,852
- 1
- 36
- 70
0
votes
1 answer
CRM 2011 Bulk Edit form : how to update some of the form fields with different values for each record record?
Currently I am dealing with a problem while using bulk edit functionality. I am trying to achieve the below. I also have given the code below.
On the bulk edit form , select values from the 2 option sets.
On the change event of the value2 , it…
CRM Beginner
- 1
- 2
0
votes
2 answers
Bulk Insert and Update and Update at the same time
I am currently inserting data from a file into a table. I format the data before inserting it into the table (Remove tabs/carriage returns/get char codes for certain text etc).
Firstly I have to check if a record exists and update it if it does. If…
oxy
- 1
- 3
0
votes
0 answers
How can I update the pattern in masked input field in Drupal?
I am having the masked input field for US phone number in this pattern (999) 999-9999 and saved all data in this pattern now I am changing the pattern to 999.999.999
but when I change the pattern it's not getting updated in the filed.
I added this…
DEVARAJ JOHNSON
- 235
- 3
- 13
0
votes
0 answers
Bulk Update set of rowkeys with same value in hbase
I have a set of rowkeys stored in an arrayList, and I want to bulk update the value of all the rowkeys in hbase with same value. Is it possible to do ?
vaibhav.g
- 729
- 1
- 9
- 28
0
votes
1 answer
How to do bulk save / updates without using HQL?
I can use HQL to do bulk operations but these operations do not update the first level cache of NHibernate, so I'm facing various problems because I do not want to clear the session or refresh objects.
Is there any way of performing bulk updates /…
Efstathios Chatzikyriakidis
- 1,341
- 2
- 15
- 33
0
votes
1 answer
How to re-factor bulk update with nested query
I was wondering how can I re-factor this script since both nested queries are quite similar (I'm using ORACLE for my database):
UPDATE
ALERT alert
SET
VERIFICATION_COUNT =
(
SELECT COUNT(*)
FROM TRANSCRIPTION trans
…
dilm
- 687
- 2
- 7
- 14
0
votes
3 answers
Bulk update in grails
I'm using grails 2.2.2 and mysql database.There are 800 records in my table(which will increase over time).I have to update a particular column value to a new value based on some calculations. Please suggest a way which does not impact the…
Manisha
- 775
- 6
- 13
- 30
0
votes
1 answer
SQL Compact Bulk Update table from another table
I've hit a little problem. I'm Inserting/Updating over 2k of records and within the 2k, there may be some record that I already have. The once I have already I may need to update the original record etc.
The solution uses SQL Compact and it can…
Chris Cooper
- 389
- 3
- 16
0
votes
1 answer
How to Use Date Object in Hibernate bulk update query
Hi here i am trying to write hibernate bulk update query as following
Date purchsedDate = TimeUtils.getSystemTimeInGMT();
String updatetest = "update Appointment app set app.appointmentStatus = ? WHERE app.purchased.boughtTime = ?…
Shabarinath Volam
- 789
- 5
- 19
- 48
0
votes
3 answers
Update Large Number of rows in sql server
I'm trying to update a column in a table which has ~90,000 rows. Is there is any optimized way to update the table?
I have added necessary indexes.. so that no table scans/lookups are not happening. But still it takes much time to run (1hr).
My…
SESHI
- 33
- 2
- 7
-1
votes
1 answer
oracle cursor or loop statement for update
I have employee table where it keep the history with Active data indicator , recently we have provided new Emp ID and the emp table got updated with active data indicator Y for all new employee ID update , where as old emp id got 'N'
Now i wanted…
-1
votes
1 answer
Is There A More Efficient Way To Code This Entity Framework Core UpdateRange Code?
var results = context.Customer.Where(c => c.CustomerId == customerId).AsQueryable();
foreach(Customer cust in results)
{
cust.isDeleted = true;
}
context.UpdateRange(results);
context.SaveChanges();
** Using the loop seems inefficient. Can…
HABosch
- 49
- 3
-1
votes
1 answer
How to sync revisions when calling bulkDocs on pouchdb instance in RxDB
I'm trying to bulk update some RxDB docs, since RxDB does not have a bulk update function I have to use the bulkDocs function on the built in pouchdb instance. I can successfully do this but then my revisions are out of sync. Is there a way to sync…
