How to save data after modified by navicat

In Navicat, you can save data modifications in the following ways: directly click the "Save" button on the toolbar or use the shortcut key F9. Submit the transaction: First click "Start Transaction", then submit the data modification, and finally click "Submit Transaction". Right-click in the data grid and select Save Changes, or when editing a cell and select Save.

How to save modified data in Navicat

Save directly

• After editing the data, click the "Save" button directly on the toolbar.
• Shortcut key: F9

Save by submitting a transaction

If multiple tables are modified, you can use a transaction to do it all at once To save all changes:

• Click the "Start Transaction" button on the toolbar.
• Perform data modification.
• Click the "Submit Transaction" button on the toolbar.

Other ways

• Shortcut menu: Right-click the data grid and select "Save Changes".
• Context Menu: When editing a specific cell, right-click and select "Save".

Note

• If your changes are not saved, a confirmation dialog box will be displayed when closing Navicat.
• If an error is encountered during transaction commit, modifications will be rolled back.
• To ensure data integrity, it is recommended to back up the database before making extensive modifications.

The above is the detailed content of How to save data after modified by navicat. For more information, please follow other related articles on the PHP Chinese website!