6. Drag-n-drop import files to Navicat
To start an Import Wizard in Navicat, you can just drag your import files over and then drop them into the target database.
7. Set variable - Server Monitor
You can edit values for the variables in MySQL and Oracle servers directly in Navicat. To do so, select “Server Monitor” for your target server from the “Tools” menu. Under the “Variables” tab, click the button next to the value or press Ctrl+Enter to open it for editing.
8. Table shortcut
Simply right-click the table and choose “Create Open Table Shortcut”. You can then open the table without starting Navicat.
9. Drag-n-drop query icon between Navicat and OS (right and left drop)
If you right-drop a query from Navicat to a Windows location, you can choose to copy, move, or create query shortcuts. If you left-drop a query, Navicat will move the query to that location.
