Python DB API - commit() v. execute("commit transaction")?

Jon Ribbens jon+usenet at unequivocal.eu
Fri Jun 2 12:45:40 EDT 2017


On 2017-06-02, Dennis Lee Bieber <wlfraed at ix.netcom.com> wrote:
> 	Connector/Python (MySQL) [guess it is time for me to finally upgrade to
> Python 3.x -- it was the delay in getting mysqldb ported that held me back]
> does allow for turning on autocommit -- which is documented as issuing an
> implicit commit after each SQL (which I take to mean each .execute() ), and
> would likely cause problems with explicit BEGIN. Also not recommended for
> InnoDB tables, but considered appropriate for MyISAM tables [no transaction
> feature on those].

Bewaare - MyISAM tables have no transactions for DML but they do have
transactions for DDL. Insane but true.



More information about the Python-list mailing list