#506·PyMySQL

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.