Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Displaying posts with tag: autocommit open transaction (reset)

Jun

2010

Autocommit, Implicit Commit and Open Transactions

Posted by Venu Anuganti on Sun 13 Jun 2010 07:11 UTC
Tags:

database, implicit commit, autocommit implicit commit, autocommit open transaction, MySQL active transaction error, mysql fails to truncate table, MySQL

If you have any open transaction(s); and if there is any statement that causes implicit commit, especially DDL statements; then the current active transaction will be committed and transaction will[...]

The latest from the MySQL community

Get Started Contributing

Events

MySQL Showcase

Top Authors

Oracle MySQL Blogs

Team Blogs

Vendor Blogs

MySQL Links