How can I disable auto-commit in Navicat?

To disable auto-commit in Navicat, you can follow these steps:

  1. Open Navicat and connect to your database.
  2. Click on the “Tools” option in the toolbar.
  3. Select “Options” from the drop-down menu.
  4. Select the “SQL Editor” option in the dropdown menu.
  5. Locate the “General” tab on the right-hand side window.
  6. Uncheck the “Auto Submit” option under the “General” tab.
  7. Click the “OK” button to save the settings.

After completing the above steps, Navicat will no longer automatically submit your SQL statements, you will need to manually submit the changes.

Leave a Reply 0

Your email address will not be published. Required fields are marked *


广告
Closing in 10 seconds
bannerAds