New executemany() implementation supporting UPDATE query
Author: methaneCreated Aug 30, 2016Updated Sep 11, 2024
LabelsFeature Request
SQLAlchemy supports update batching using Cursor.executemany().
Sadly, executemany in PyMySQL (and mysqlclient) only support INSERT and REPLACE
query.
I'll add new executemany implementation which uses multi results.
While it doesn't reduce number of queries, it can reduce number of roundtrips.
Source: PyMySQL/PyMySQL