Create a raw MySQL query in Django to bulk updata millions of records
$10-30 USD
Paid on delivery
I have a very large MySQL table in my Django project. I need a Django Management Command with raw MySQL query to bulk updata millions of records.
If I just create a big string with one million update queries MySQL will go away.
e.g.:
"
UPDATE my_big_table SET value = 15.61 WHERE id = 1;
UPDATE my_big_table SET value = 35.61 WHERE id = 2;
...
UPDATE my_big_table SET value = 265.58.61 WHERE id = 1000000;
"
So the idea is to to create the the query in batches of 1000 and to update the MySQL database using threading ...
... keep getting: [login to view URL]: (2014, "Commands out of sync;
Project ID: #12966798
About the project
5 freelancers are bidding on average $59 for this job
i have done it already using multiprocessing put raw data in amazon redshift data ware house. so i same way i will perform the updation