Navicat Tips (with shortcut keys)

1. Sometimes press the shortcut key ctrl+f searches a certain data time to search, but can use the SQL to find out, this is how to go about.

Ctrl+f can only search the data on this page, not the data on this page cannot be searched, Navicat only 1000 data per page. When the data is many times the navicat is displayed, you can press the left/right arrow in the lower right corner to turn to the upper/next page. At this time if the data too much, so the page to find this data is too troublesome, or use SQL to find out.

2. On Navicat a field is sorted in ascending or descending order, all pages of this table on Navicat are arranged in this way, not just on this page

3. Create a new query. Note SQL shortcut keys: ctrl+/Uncomment: shift+ctrl+/

4.Navicat do not find the field name of the function button, only with SQL (not Baidu This problem, personal exploration, verification through, want to develop this function with themselves)

Query method See: http://blog.csdn.net/superit401/article/details/69389714

The descending or ascending order of the fields in the 5.navicat does not affect the sorting of the data in the database, but navicat the order of the data in front of them.

6. The order of the data in the database is stored and sorted by creation time, isolated from the database (the default ordering (the SQL does not write sort order by), the order by Create_time ASC) The data in the list is consistent with the data order in the database. All the data displayed in the Navicat are from the top down corresponding to the data creation time from morning to night. The order of the Entity class list (the default sort (not the sort order by in SQL), which is the order by Create_time ASC, is detected by the program, and the element index corresponding to the list is small to large, that is, the higher the index value, the later the data is created. Corresponds to the order in the database.

7. The table's data content Display page switches to the structure design page of the table: the Data Content Display page of the table is built by shortcut key Ctrl+d

Instead switch back to the Data Content Display page: Ctrl+o

8. Quickly switch to the table query: On the Data Content Display page Press the shortcut key Ctrl+q

8. Select a line shortcut when editing sql: Mouse Three Click to move forward

9.Navicat shortcut keys:

Ctrl+q Open Query window

ctrl+/Comment SQL statement
Ctrl+shift +/dismiss Comment
Ctrl+r SQL statement that runs the query window
Ctrl+shift+r only run the selected SQL statement
F6 open a MySQL command line window
Ctrl+l Delete a row
CTRL + N opens a new query window
Ctrl+w Close a Query window

The data display page of the Ctrl+d table switches to the structure design page of the table, but is copied when the query page writes SQL

10. "Pound sign" # is a comment function