title: Bulk update MySql with python
body: <p>I have to update millions of row into MySQL. I am currently using for loop to execute query. To make the update faster I want to use <a href="https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-executemany.html" rel="nofollow"><code>executemany()</code></a> of Python MySQL Connector, so that I can update in batches using single query for each batch.</p>