Convenient use of navicat

Navicatcan support connecting to a variety of databases, and its functions are also relatively powerful.

If you use the built-in database tool ofIDEA(I like to use this personally) or the official database management tool ofSQL Server, you will find that there are differences in usage. , the difference is mainly in the use of shortcut keys (other menu options are almost fool-proof), especially the shortcut keys for executingSQL(actually just remember this). Here is a summary of some commonly used shortcut keys inNavicat. The main advantage of using shortcut keys is that you free your right hand and do not have to switch back and forth between mouse and keyboard values (this is very annoying).

Navicat main window

Keys	Action
CTRL G	Set location folder
CTRL # (# represents 0 to 9)	Open object window from favorites list
F6	Command line interface
CTRL H	Historical log
CTRL Q	New query
F12	Display only Active Object

Regular

CTRL N New Object SHIFT CTRL # (# represents 0 to 9) Add favorites F8 Navicat main window CTRL TAB or SHIFT CTRL TAB Next window F1 Description ##CTRL F1 Table Designer

##Key	Action
Online File

##CTRL O Open table CTRL F Find field F3 Find next field SHIFT F3 Find Previous Field Table Viewer or View Viewer

Key	Action

View or Query

Keys Action CTRL D Design table or design view CTRL Q Query table or query view CTRL F Find text F3 Find next text CTRL G Go to line CTRL Left Arrow The first data column of the current record CTRL Right Arrow The first data column of the current record The last data column CTRL HOME The first data row of the current column CTRL END The last data row of the current column CTRL PAGE UP or CTRL up arrow The first data row of the current window CTRL PAGE DOWN or CTRL down arrow The last data row in the current window CTRL R Apply filter in the filter wizard SHIFT Arrow Select cells CTRL ENTER Open the editor to edit data INSERT or CTRL N Insert record CTRL DELETE Delete record CTRL S Apply record changes ESC Cancel record changes CTRL T Stop loading data

Key	Action
CTRL O	Load view or load query
CTRL /	Comment line
SHIFT CTRL /	Uncomment the line
CTRL E	View Definition or Query Editor
CTRL R	Run
SHIFT CTRL R	Run the selected
F7	Run a statement from here
CTRL T	Stop

SQL Editor

Key	Action
CTRL F	Find text
F3	Find next text
CTRL = or CTRL mouse wheel up	Zoom in
CTRL - or CTRL mouse wheel down	Zoom out
CTRL 0	Reset zoom

Debugger

##F8 Step by step F7 Step by step Statement SHIFT F7 Skip

Keys	Action
F9	Run

Report

CTRL O Open the report in report design CTRL P Print in report design CTRL G Group in report design PAGE DOWN Next page PAGE UP Previous page END Last page HOME First Page ##Model

Keys	Action

##Key Action CTRL D Create a new chart in the model Print ##ESC Select H Move chart T New table V New view L New layer A New label N New note I New image R New foreign key CTRL B Display the selected table, view, foreign key or shape in bold CTRL = or CTRL mouse wheel up Zoom in CTRL - or CTRL mouse wheel down Zoom out CTRL 0 Reset Zoom navicat

	## CTRL P
	Recommended:

The above is the detailed content of Convenient use of navicat. For more information, please follow other related articles on the PHP Chinese website!