How can I disable auto-commit in Navicat?
To disable auto-commit in Navicat, you can follow these steps:
- Open Navicat and connect to your database.
- Click on the “Tools” option in the toolbar.
- Select “Options” from the drop-down menu.
- Select the “SQL Editor” option in the dropdown menu.
- Locate the “General” tab on the right-hand side window.
- Uncheck the “Auto Submit” option under the “General” tab.
- 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.