Planet MySQL

Displaying posts with tag: mysql fails to truncate table (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[...]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links