How to disable Auto Commit after editing data?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Sławek
Posts: 9
Joined: Tue 06 Mar 2018 14:34

Re: How to disable Auto Commit after editing data?

Post by Sławek » Thu 31 Jan 2019 16:36

Just a comment. Change of the Auto Commit behaviour, if I am not wrong appeared end of 2017, was one of the main reasons that I discontinued subscription of dbForge Studio after seven years of using. I am still on the 7.2.78 version. I tried a few new next versions (up to Febraury/March 2018), all were equally unacceptable. In 7.2.78 Auto Commit is assigned just to the session. It's unexplainable to me why Devart removed it afterwards.

alexa

Re: How to disable Auto Commit after editing data?

Post by alexa » Mon 04 Mar 2019 08:58

In the new version, we removed those buttons. Now, to manage transactions, you have to manually specify the START TRANSACTION, COMMIT and ROLLBACK statements http://www.mysqltutorial.org/mysql-transaction.aspx .

Post Reply