Example explanation of Navicat For Mysql shortcut keys

1.ctrl+q Open query window

2.ctrl+/ Comment sql statement

3.ctrl+shift +/ Uncomment
4.ctrl+r Run query window sql statement
5.ctrl+shift+r Run only the selected sql statement
6.F6 Open a MySQL command line window
7.ctrl+l Delete a row
8.ctrl+n Open A new query window
9.ctrl+w Close a query window

I think most people who make programs can do navicat It is convenient, fast, intuitive, etc., and has many advantages, which is why I wrote this article. In the past, I basically used phpmyadmin, which was pretty easy to use. However, it also had many shortcomings. For example, the database backup file was too large and could not be imported at all. To manage multiple database servers, I had to configure phpmyadmin, which was actually quite unpleasant. Navicat is actually not very convenient for people who are just using it, but it will be different once you get used to it. Here's how to combine shortcut keys to make using Navicat more comfortable.

1. How to write sql statement query in navicat?

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

Method 2: Press f6 and a command window will pop up. The operation is the same 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

navicat multi-window switching

There are two windows in the above picture, 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 a window will pop up in the export wizard above the point, allowing you to choose what kind of file to back up, next step

navicat Back 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 the 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. With ctrl+d, you 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 on the upper left and connect a few more.

5. How to use navicat to manage database administrators?

Click manage users on the upper left and a window will pop up, which will list 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 Example explanation of Navicat For Mysql shortcut keys. For more information, please follow other related articles on the PHP Chinese website!