PEP 249 (database api) -- executemany() with iterable?

Petite Abeille petite.abeille at
Tue Oct 12 20:52:15 CEST 2010

On Oct 12, 2010, at 8:35 PM, Jon Clements wrote:

> 4) Execute an update with a from statement joining your main table and
> temp table (pretty sure that's ANSI standard, and DB's should support
> it -- embedded one's may not though, but if you're dealing with 1mil
> records, I'm taking a guess you're not dealing with embedded)

Not ANSI. Perhaps with a subquery, which is ANSI-compliant.

More information about the Python-list mailing list