Navicat for MySQL shortcut keys

Source: Internet
Author: User
Tags mysql command line

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.
  1. Ctrl+q Open Query window
  2. ctrl+/Comment SQL statement
  3. Ctrl+shift +/dismiss Comment
  4. Ctrl+r SQL statement that runs the query window
  5. Ctrl+shift+r only run the selected SQL statement
  6. F6 open a MySQL command line window
  7. Ctrl+d (1): View table structure details, including index trigger, stored procedure, foreign key, unique key, (2): Copy one row
  8. Ctrl+l Delete a row
  9. CTRL + N opens a new query window
  10. Ctrl+w Close a Query window
  11. 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.