Navicat query is based on user needs to extract the data in a readable format from the database, Navicat provides two powerful tools and SQL query work: Query creation tool and Query Editor, the query creation tool can visually create a query, the Query Editor can directly edit the query text. Clever use of Navicat shortcut keys, can greatly improve work efficiency, this tutorial will explain Navicat Win and Mac view class shortcut key comparison.
Navicat Windows ViewNavicat Windows Platform view class shortcut keys:
CTRL+Q: Open new Query window
CTRL+R: Runs all statements within the current window
Shift+ctrl+r: Run the selected
Ctrl+w: Close the current window
F6: Open a MySQL command line window
Ctrl+o: Loading a view or loading a query
ctrl+/: Comment Lines
shift+ctrl+/: Uncomment line
Ctrl+e: View definition or Query Editor
CTRL + D: View table definitions on the Table Data window
CTRL +l: Delete a row
CTRL +/: Comments
CTRL + N: Open new Query window
F7: Run a statement from here
Ctrl+t: Stop
Navicat Mac OS x EditionNavicat Mac Platform view class shortcut keys:
Cmd-r: Run
Shift-cmd-r: Run the selected
SHIFT-CMD-E: Run a statement from here
Cmd-o: Open View or Load query
Shift-cmd-enter: Stop
Option-cmd-f: Find and replace
CMD-E: Use selection to find
Cmd-j: Jumps to the selected area
Cmd-down arrow: Go to Footer
From Navicat official website
Navicat Win and Mac view class shortcut keys comparison