Clever use of Navicat for MySQL shortcut keys, can greatly improve work efficiency, this experience will be classified to introduce NAVICAT for MySQL shortcut keys.
- Ctrl+q Open Query window
- ctrl+/Comment SQL statement
- Ctrl+shift +/dismiss Comment
- Ctrl+r SQL statement that runs 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 trigger, stored procedure, foreign key, unique key, (2): Copy one row
- Ctrl+l Delete a row
- CTRL + N opens a new query window
- Ctrl+w Close a Query window
- Ctrl+tab Multi-Window switching
Note: Please do not write a lot of update and delete! in a window Navicat the main window, as shown in the shortcut key:
Table Designer, as shown in the shortcut keys:
Table Viewer, as shown in the shortcut keys:
View Viewer, as shown in the shortcut keys:
View or query, as shown in the shortcut keys:
SQL Editor, shortcut keys as shown:
Report, shortcut keys as shown:
Model, as shown in the shortcut keys:
One, navicat how to write SQL statement query?
Method 1:ctrl+q will pop up a SQL input window, you can write SQL in it. After the SQL is written, the SQL is executed directly ctrl+r . Another point, when writing SQL statements,Navicat will prompt, root code to complete the same , pretty cool.
Method 2: Press f6 will pop up a command window, the root mysql-u mysql-p into the same operation, but \g use will error . Can also be queried here.
Tip: These windows can be dragged together into the
Navicat Multi-window switch, we can through, shortcut key ctrl+tab, switch between the Windows.
Second, navicat how to back up, restore database, and table?
Method 1: Right-click data name = "Check the dump SQL file can be backed up, if you want to restore, choose Execute SQL file is OK." Backup table, the same operation as the root backup database. To restore the table, just use the Import Wizard on the line. This backup can only be produced by. sql files. If you want to back up to another file format, look at Method 2.
Method 2: Click on the database, the Export Wizard above the point will pop up a window, let you choose what kind of files to backup , the next
Navicat backup database, and table
If there are too many tables, it is inconvenient to back it up in this way. If it is imported, then use the Import Wizard on the line. Backup table the same operation.
Third, how to view table data and table structure?
Double-click the table to see the table data,ctrl+d can not only see the table structure, but also can see indexes, foreign keys, triggers and so on.
Four, how to manage multiple MySQL servers?
Click on the Connection button at the top left to connect a few more lines.
Five, how to use Navicat to manage the database administrator?
Click on the top left Manage users will pop up a window that lists all MySQL administrators. Once you have modified the permissions, you can save them.
Above 5 points, just some common, basic operation, Navicat also has a lot of humanized operation. Here is not much to say, interested friends, you can play next. Personally, I think it's pretty cool.
Navicat for MySQL shortcut keys