Summary of commonly used shortcut keys in Navicat
This article brings you a summary of commonly used shortcut keys in Navicat. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.
This official Chinese document is very detailed
https://www.navicat.com.cn/manual/online_manual/cn/navicat/win_manual/index.ht
Shortcut keys
Navicat main window
##Keys |
Action |
Set location folder | |
Open the object window from the favorites list | |
Command Line Interface | |
Historical log | |
New query | |
Show active objects only |
Keys
|
Action
|
New object | |
Add favorites | |
Navicat main window | |
Next window | |
Description | |
Online File |
##Action |
CTRL O |
CTRL F | |
F3 | |
SHIFT F3 | |
Action |
##CTRL D Design Table or Design View |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Query table or query view | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Find text | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Find next text | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Go to line | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Current The first data column recorded | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The last data column currently recorded | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The first data row of the current column | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The last data row of the current column | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The first data line of the current window | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Current window The last data row | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Apply filter in Filter Wizard | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Select cell | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Open editor to edit data | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
INSERT RECORD | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DELETE RECORD | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
APPLY RECORD CHANGES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cancel recording changes | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Stop loading data | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Key |
Action |
Load view or load query | |
Comment line | |
Uncomment line | |
View Definition or Query Editor | |
Run | |
Run Selected The | |
Run a statement from here | |
Stop |
SQL Editor
##Keys
|
Action
| ##CTRL F
## F3 | |
CTRL = or CTRL mouse wheel up | |
CTRL - Or CTRL mouse wheel down | |
CTRL 0 | |
Action |
F9 |
F8 | |
F7 | |
SHIFT F7 | |
Action |
##CTRL O | Open the report in report design
CTRL P | Print in report design |
CTRL G | Group in report design |
PAGE DOWN | Next page |
PAGE UP | Previous page |
END | Last page |
HOME | First page |
##Model |
Keys
##Action | CTRL DCreate a new chart in the model |
Select | |
Move Chart | |
New Table | |
New view | |
New layer | |
New tag | |
New note | |
New image | |
New foreign key | |
Display selected Tables, views, foreign keys or shapes are bold | |
Zoom in | |
Zoom out | |
Reset zoom | |
The above is the detailed content of Summary of commonly used shortcut keys in Navicat. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Navicat Keygen Patch is a key generator that activates Navicat Premium, allowing you to use the full functionality of the software without purchasing a license. How to use: 1) Download and install Keygen Patch; 2) Start Navicat Premium; 3) Generate the serial number and activation code; 4) Copy the key; 5) Activate Navicat Premium, and Navicat Premium can be activated.

The following steps can be used to resolve the problem that Navicat cannot connect to the database: Check the server connection, make sure the server is running, address and port correctly, and the firewall allows connections. Verify the login information and confirm that the user name, password and permissions are correct. Check network connections and troubleshoot network problems such as router or firewall failures. Disable SSL connections, which may not be supported by some servers. Check the database version to make sure the Navicat version is compatible with the target database. Adjust the connection timeout, and for remote or slower connections, increase the connection timeout timeout. Other workarounds, if the above steps are not working, you can try restarting the software, using a different connection driver, or consulting the database administrator or official Navicat support.

Navicat is a powerful database management tool that supports Dameng database. It provides comprehensive features such as connection management, SQL queries, data modeling, performance monitoring, and user management. With its intuitive user interface and in-depth support for Dameng database, Navicat provides database administrators and developers with solutions to efficiently manage and operate Dameng databases.

You can use Navicat to create a stored procedure, the steps are as follows: Open the database object list and expand the "Procedures" node. Right-click the Procedures node and select Create Procedure. Enter the stored procedure name and body and set the parameters (if required). Select Compile in the File menu to compile the stored procedure. By executing a query or using "E in the "Procedures" list

Create a database using Navicat Premium: Connect to the database server and enter the connection parameters. Right-click on the server and select Create Database. Enter the name of the new database and the specified character set and collation. Connect to the new database and create the table in the Object Browser. Right-click on the table and select Insert Data to insert the data.

Navicat provides data analysis capabilities, including: Create pivot tables: Aggregate data by field. Draw charts: Visualize data patterns. Writing SQL queries: perform complex analysis.

How to check if Navicat is activated: View the Registration Information section in the "About Navicat" of the Help menu: Activated: Show valid registration information (name, organization, expiration date) Not activated: Show "Not Registered" or "Register Information Not Available" Check the activation icon in the toolbar: The green icon indicates that the active observation trial period countdown: The trial version will show the countdown at startup, the activated version will not view feature limitations: The trial version may limit advanced features, and the activated version will unlock all functions

You can create a new MySQL connection in Navicat by following the steps: Open the application and select New Connection (Ctrl N). Select "MySQL" as the connection type. Enter the hostname/IP address, port, username, and password. (Optional) Configure advanced options. Save the connection and enter the connection name.
