Navicat Shortcuts

As a database visualization tool, navicat believes that many people are using it, but we all know that shortcut key operations can greatly improve our efficiency. The Navicat shortcut keys are recorded below for everyone to learn and share.

Window Shortcuts

// Open a mysql command line window, similar to cmd openingF6// Open a query window, that is, create a new queryCtrl + Q// close a query windowCtrl + W// close all query windowsCtrl + Shift + W

SQL

SQL writing shortcuts

// sql code promptESC// Select the record of the sql promptTab

SQL comments

// Comment/uncomment sqlCtrl + /

SQL shortcut keys

// Run all sql statements in the query window, that is, execute all sql statementsCtrl + R// Run the sql statement selected in the query window, that is, execute the currently selected sql statementCtrl + Shift + R

SQL delete current row

// delete a line (the cursor needs to be placed on the line to be deleted)Ctrl + Shift + L

Dual function shortcuts

// If it is in the open data table interface, the following shortcut key is to switch to the structure design page of the table;// If it is in the query window (that is, the interface for writing sql), the following shortcut keys are to copy the current rowCtrl + D// On the table design page, quickly switch to the table content display pageCtrl + O

Query history log

// Query history logCtrl + L

Common shortcut keys

// findCtrl + F// replaceCtrl + H// skip to the beginning of the entire statementCtrl + Home// skip to the end of the entire statementCtrl + End// NextTab Ctrl + Tab// Switch between this line and the previous lineCtrl + T// Create a new favorite (you can save the query statement in the favorite)Ctrl + Shift + 1// open help fileF1