Create a raw MySQL query in Django to bulk updata millions of records

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;

Django Python

项目ID： #12966798

关于项目