Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
A
A
Alexander2017-09-22 10:19:10
MySQL
Alexander, 2017-09-22 10:19:10

How in Django (MySQL) you can bulk update records in the database with different values?

There is a table
cf65aab4ae584d0f9e2b99ef63aa6f6d.png
The table is planned to have about 100,000 records.
I need to select all the records, pass them through a number of methods (filter, calculate) and update the remaining ones (80,000 records may remain).
The trick is that when processing the table fields "left_points" and "right_points" - for each record there will be different ones.
Question. How to bulk update records with different values ​​as efficiently as possible?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
A
Anton Zolotarev2015-04-20 17:51:12
How to make 2 conditions in Apache - Rewrite rule? 4Reply
F
fara_ib2019-09-21 18:21:15
How to set up adding a port to vlan after checking for 802.1x? 2Reply
A
AlexStolman2015-06-06 09:26:47
How to remove or replace HTTP referer when submitting a form from site A to site B? 4Reply
A
Alex2015-06-29 15:03:19
How to Livereload server side and client side at the same time using Gulp? 2Reply
#
#FFFFFF2019-11-19 14:39:34
What is better to use for e2e testing Vue? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question