Fast operation of MySQL Navicat

工欲善其事, its prerequisite! The operation of the database also requires good tools, learning process has been using NAVICAT to operate, feeling very useful.

Always use mouse punctuation is also more trouble, so search summary of the use of shortcut keys, recorded to facilitate learning and use;

Ctrl+q Open Query window

CTRL + N opens a new query window

Ctrl+w Close a Query window

Ctrl+r SQL statement that runs the query window

ctrl+/Comment SQL statement

Ctrl+shift +/dismiss Comment

Ctrl+d you can quickly adjust the field data type by switching from the data page to the Design table page. (Note: When you write an SQL statement, the shortcut command is to copy the current line and write to the next line);

Switch back from the Design table page to the Data Content Display page: Ctrl+o

Ctrl+shift+r only run the selected SQL statement

F6 open a MySQL command line window

Ctrl+l Delete a row

Ctrl+f Finding data (find this page)

Fast operation of MySQL Navicat