Use the shortcut keys of Navicat for MySQL skillfully

The content of this article is about the skillful use of Navicat for MySQL shortcut keys. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

Clever use of Navicat for MySQL shortcut keys can greatly improve work efficiency. This article will introduce Navicat for MySQL shortcut keys by category.

ctrl q Open the query window

ctrl / Comment the sql statement

ctrl shift / Uncomment

ctrl r Run the sql statement of the query window

ctrl shift r Only run the selected sql statement

F6 Open a mysql command line window

ctrl d (1): View table structure details, including index triggers, stored procedures, Foreign key, unique key; (2): Copy a row

ctrl l Delete a row

ctrl n Open a new query window

ctrl w Close a query window

ctrl tab Multi-window switching

Note: Please do not write many updates and deletes in one window!

Navicat main window, the shortcut keys are as shown below:

Table Designer, the shortcut keys are as shown below:

Table viewer, the shortcut keys are as shown in the figure below:

View viewer, the shortcut keys are as shown in the figure below:

View or query, the shortcut keys are as shown below:

SQL editor, the shortcut keys are as shown below:

Report, the shortcut keys are as shown below:

Model, The shortcut keys are as shown in the figure below:

1. How to write SQL statement query in Navicat?

Method 1: ctrl q A sql input window will pop up, and you can write sql in it. After writing the sql, just ctrl r to execute the sql. Another point is that when writing sql statements, navicat will prompt, and the root code completion is almost , which is quite cool.

Method 2: Press f6 and a command window will pop up. The operation is the same as when entering as root mysql -u mysql -p. However, an error will be reported when using \G . You can also check here.

Tips: These windows can be dragged together to switch between

navicat multi-windows. We can use the shortcut key ctrl tab to switch between windows.

2. How does navicat back up and restore the database and tables?

Method 1: Right-click the data name=》Select dump sql file to back up. If you want to restore, just select execute sql file. Back up the table and back up the database in the same way. To restore the table, just use the import wizard. This kind of backup can only export .sql files. If you want to back up to other file formats, see method 2.

Method 2: Click on the database, and the export wizard above the point will pop up a window, let you choose the backup format What kind of files, next step

navicat backs up the database and tables

If there are too many tables, it is really inconvenient to back them up in this way. If you are importing, just use import wizard. The same operation is performed for the backup table.

3. How to view table data and table structure?

Double-click the table to view the table data. ctrl dYou can not only see the table structure, but also indexes, foreign keys, triggers, etc.

4. How to manage multiple mysql servers?

Click the connection button in the upper left corner to connect a few more.

5. How to use navicat to manage the database administrator?

Click on the upper left manage users and a window will pop up listing all mysql administrators. After modifying the permissions, just save it.

The above 5 points are just some commonly used and basic operations. Navicat also has many user-friendly operations. I won’t go into details here. Friends who are interested can come and play next. Personally, I find it quite enjoyable to use.

The above is the detailed content of Use the shortcut keys of Navicat for MySQL skillfully. For more information, please follow other related articles on the PHP Chinese website!