Y42 SQL Shortcuts
Minimal Must-Knows
| International Keyboard | Description | Mac | Windows |
|---|---|---|---|
| See all shortcuts | Find all shortcuts - you can also execute them directly | (fn + ) F1 | (fn + ) F1 |
| Undo | Goes one step back | CMD + Z | CTRL + Z |
| Redo | Goes one step further | CMD + Y | CTRL + Y |
| Multi-Line Commenting | Comments the line or selected text | CMD + / | CTRL + / |
| Toggle Block Comment | Inserts block comments /* */ If you select text it puts the selected text inside block comments | Option + Shift + A | ALT + Shift + A |
| Search | Opens the option to find and search for a matching text in the editor | CMD + F | CTRL + F |
| Run Query | Run either all the code or just the selected part | CMD + Enter | CTRL + Enter |
| Format Query | Select and format a query nicely | CMD + Shift + F | CTRL + Shift + F |
| Multi-Cursor | Very useful to write multiple lines at the same time | Option + Shift + Mouse | ALT + Shift + Mouse |
Essentials
| International Keyboard | Description | Mac | Windows |
|---|---|---|---|
| Replace | Opens the Find and Replace editor | CMD + H | CTRL + H |
| Find Next | Finds the next occurrence of the search | Enter or CMD + F3 | Enter or CMD + F3 |
| Find Previous | Finds the previous occurrence of the search | Shift + Enter or Shift + CMD + F3 | Shift + Enter or Shift + CMD + F3 |
| Move line | Move a line up and down without copying | Option + Arrow | ALT + Arrow |
| Duplicate Line | Duplicates the line or selection where the cursor is placed | Option + Shift + Arrow | ALT + Shift + Arrow |
| Add Cursor Down | Adds a new cursor one line below | CMD + Option + Arrow Down | CTRL + ALT + Arrow Down |
| Add Cursor UP | Adds a new cursor one line up | CMD + Option + Arrow Up | CTRL + ALT + Arrow Up |
| Add the next occurrence in the selection | If the text it repeated it adds anytime an occurrence in the selection | CMD + D | CTRL + D |
| Find/change all occurrences | Highlights text matching the selected keyword, you can as a next step edit those simultaneously | CMD + F2 + Mouse Left Click | CTRL + F2 + Mouse Left Click |
| Delete Line | Deletes the current line | CMD + Shift + K | CTRL + Shift + K |
| Indent Line | Indents the Line | CMD + ] | CTRL + ] |
| Out Indent Line | Out indents the Line | CMD + [ | CTRL + [ |
| Go to line column | Goes directly to the line column you specify | CMD + G | CTRL + G |
| Select All the text | Selects all the text | CMD + A | CTRL + A |
| Trigger suggest | Ads suggestion popup | CMD + Space | Ctrl + Space |
Advanced
Select All occurrences
Another way of selecting multiple blocks of text with multiple cursors is Select All Occurrences command, which selects all the other occurrences in the current file of the already selected text. In case no text is selected/clicked, the closest word to the current cursor is selected.
This command can be triggered by
- Ctrl + F2 on Linux or Windows
- CMD + F2 on Mac.
Additional Shortcuts
| International Keyboard | Description | Mac | Windows |
|---|---|---|---|
| Add cursor to line ends | Adds cursors where to line ends | Shift + Option + I | Shift + ALT + I |
| Cursor Undo | Undoes the last cursor movement | CMD + U | CTRL + U |
| Expand selection | Expands the text selection | Shift+Option+ RightArrow | Shift+ALT+ RightArrow |
| Shrink selection | Shrinks the text selection | Shift+Option+ LeftArrow | Shift+ALT+ LeftArrow |
| Go to Bracket | Positions the cursor where the Bracket is | CMD + SHIFT + \ | CTRL + SHIFT + \ |
| Go to Next Problem in Files (Error Warning Info) | F8 | F8 | |
| Go to Previous Problem in Files (Error Warning Info) | Shift + Option + F8 | Shift + ALT + F8 | |
| Insert Line Above | Inserts Line Above | CTRL+ SHIFT + Enter | CMD + SHIFT + Enter |
| Replace with next Value | CTRL + SHIFT + . | CTRL + SHIFT + . | |
| Replace with Previous Value | CTRL + SHIFT + , | CTRL + SHIFT + , | |
| Toggle Tab Key Moves Focus | CTRL + M | CMD + M | |
| Trim trailing White-space | CMD + K or CMD + X | CTRL + K or CTRL+ X | |
| Show all occurrences of find match | CMD + Shift + L | CTRL + Shift + L | |
| Show accessibility help | Opens informative popup | Option + F1 | ALT + F1 |
| Show editor context menu | Shift + F10 | Shift + F10 |
All Commands
These are all commands possible in the Editor, even the ones without a shortcut. You can access them with (fn + ) F1.
| Commands | Description |
|---|---|
| Add Cursors to top | Add cursors ti the end of every line above the cursor |
| Add Cursors to bottom | Add cursors ti the end of every line below the cursor |
| Add selection to previous find match | Places the cursor to every matching word/phrase to the one selected text |
| Convert indentation to spaces | |
| Convert indentation to Tabs | |
| Copy with syntax highlighting | |
| Cursor Redo | |
| Delete all left | Deletes all text or space in the left of the cursor |
| Delete all right | Deletes all text or space in the right of the cursor |
| Delete word | Deletes the word where the cursor is placed |
| Detect indentation form Content | Detects indentation form Content |
| Developer: Force Retokenize | |
| Developer: Inspect tokens | Opens an inspector everywhere you put the cursor |
| Find with selection | Opens the Find panel with the selection ready for search |
| Duplicate selection | Copies and Pastes the selection already made |
| Editor Font Zoom in | Zooms in the font |
| Editor Font Zoom out | Zooms out the font |
| Edit font zoom reset | Resets the font to its default state |
| Indent using spaces | Indents using spaces |
| Indent using tabs | Indents using tabs |
| Insert line below | Inserts line below |
| Join Line | Joins 2 Lines together |
| Move last selection to previous find match | |
| Move selected text left | |
| Move selected text right | |
| Open Link | Opens selected link in a new tab |
| Re-indent selected lines | Re-indents selected lines |
| Reset Suggest widget size | Reset Suggest widget size |
| Select to bracket | Selects text inside the bracket |
| Sort lines Ascending | Sorts selected lines ascending |
| Sort lines Descending | Sorts selected lines descending |
| Toggle High contrast theme | Changes the color of the editor into a high contrast theme (black) |
| Transform to lowercase | Transform selected text to lowercase |
| Transform to title-case | Capitalizes the first letter of the word |
| Transform to uppercase | Transforms all the letters into upper case |
| Transpose letters | |
| Trigger inline suggestion |