How to speed up multiple column bulk updates in MySQL using python
I have some python code that reads data from a pandas Dataframe and updates multiple fields in a MySQL table using the primary key in the where clause. The “merchant_id” field is indexed. The code goes like this: