Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to use navicat for everyone. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

Navicat can support the connection of a variety of databases, the use of the function is also more powerful.

If you use IDEA's built-in database tools (personal favorite) or SQL Server official database management tools, you will find that there are differences in use, mainly in the use of shortcut keys (other menu options are almost fool-like), especially the execution of SQL shortcut keys (in fact, remember this is good). Here is a summary of some of Navicat's commonly used shortcuts, the benefits of using shortcuts, mainly the release of the right hand does not have to switch back and forth between the mouse and keyboard values (this is annoying).

Navicat Main Window

key

action

CTRL+G Set location folder CTRL+#(#stands for 0 to 9) Open object window from favorites list F6 Command line interface CTRL+H History log CTRL+Q New query F12 Show only active objects

conventional

key

action

CTRL+N New Object SHIFT+CTRL+#(#stands for 0 to 9) Add Favorite F8Navicat Main Window CTRL+TAB or SHIFT+TAB Next Window F1 Description CTRL+F1 Online File

table designer

key

action

CTRL+O Open table CTRL+F Find field F3 Find next field SHIFT+F3 Find previous field

Table Viewer or View Viewer

key

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 row CTRL+ Left arrow First data column of current record CTRL+ Right arrow Last data column of current record CTRL+HOME First data row of current column CTRL+END Last data row of current column CTRL+PAGE UP or CTRL+ UP arrow First data row of current window CTRL +PAGE DOWN or CTRL+ DOWN arrow Last data row of current window CTRL+ CTRL+ HOME CTRL+ENTER Open an editor to edit data INSERT or CTRL+N Insert a record CTRL+ Delete a record CTRL+S Apply a record Change ESC Cancel a record Change CTRL+T Stop loading data CTRL+T

View or query

key

action

CTRL+O Load View or Query CTRL+/Comment Line SHIFT+CTRL+/Uncomment Line CTRL+E View Definition or Query Editor CTRL+R Run SHIFT+CTRL+R Run 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 Zoom up CTRL+-or CTRL+ mouse wheel Zoom down CTRL+0 Reset zoom

debugger

key

action

F9 Run F8 Procedure-by-procedure F7 Statement-by-statement SHIFT+F7 Skip

statements

key

action

CTRL+O Open a report in Report Design CTRL+P Print a report in Report Design CTRL+G Group PAGE DOWN PAGE UP END END HOME First Page

model

key

action

CTRL+D Create a new chart in the model CTRL+P Print ESC Select H Move Chart T Create a new table V Create a new view L Create a new layer A Create a new label N Create a new note I Create a new image R Create a new foreign key CTRL+B Display the selected table, view, foreign key or shape in bold CTRL+= or CTRL + mouse wheel up CTRL+-or CTRL+ mouse wheel down CTRL+0 Reset zoom About "how to use navicat" This article is shared here, I hope the above content can be of some help to everyone, So that you can learn more knowledge, if you think the article is good, please share it to let more people see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.