Navicat for MySQL option Setup Tips

Navicat for MySQL provides users with complete user-defined interface options, from the main menu to select Tools---options, but many users first contact, how to set this aspect is not very understanding, this tutorial will be detailed to introduce the introduction Navicat For MySQL Options settings tips. Hope can help everyone.

Navicat for MySQL General Options

Navicat General Options mainly include the following:

The window appears in the Work column: Each time a new window is opened, it is automatically displayed in the Windows taskbar. When this option is deactivated, all windows (for example: tables, queries) will be closed when you exit the Navicat main window. It is important to note that a restart of Navicat is required before it takes effect.

Allow the form to be opened repeatedly: tick this option, the user can open the selected window repeatedly.

Allow Navicat to run repeatedly: uncheck this item, meaning that clicking the Navicat shortcut will restart the running Navicat without running a new Navicat.

Refresh when clicked: Automatically refreshes the list of objects whenever the object is clicked.

Show Function Wizard: Displays the Function Wizard when a new query or process is created.

Prompt to save new query or settings file before closing: Tick this option, Navicat will prompt you to save a new query or settings file each time you leave the relevant subwindow.

Docked

Open window: Opens a new window "to main Window", "to docking Window" or "as a new window".

Code attach option (Navicat full version only)

Auto-complete code: When entering between object names. (dot) symbol, the SQL editor will display some approximate code in the pop-up list for the user to select.

Delay: Changes the time it takes for the pop-up list to appear.

AutoComplete Word: When entering the first word, the SQL editor will pop up the list to display some approximate words for the user to select.

Use syntax highlighting: syntax highlighting helps users to see the code clearly. Depending on the category in which the code belongs, the code is highlighted in a different color and font in the SQL editor.

The syntax highlighting feature can be used to improve performance by setting the maximum file limit (for example: 10) in the "Apply syntax highlighting statement when the statement size is less than (MB)".

Auto Save

Use Auto Save: Define AutoSave interval (s) (for example: 30 seconds) and save it automatically after the SQL editor has made changes.

The above is the Navicat for MySQL option set up a detailed introduction, how to have any questions, you can refer to the relevant tutorials. For example, if you encounter a navicat connection Oracle 12737 Error, you can focus on the navicat connection Oracle 12737 error .

Navicat for MySQL option Setup Tips