Learn SQLyog Shortcuts for Windows
Connection Shortcuts
| Action | SQLyog Shortcuts |
|---|
| Create A New Connection | Ctrl + M |
| Create A New Connection With Current Connection Properties | Ctrl + N |
| Disconnect The Current Connection | Ctrl + F4 |
| Switch to the Next Connection | Ctrl + Tab |
| Switch to the Previous Connection | Ctrl + Shift + Tab |
| Select Connection (1 to 8) | Ctrl + 1 to Ctrl + 8 |
| Select Last Connection | Ctrl + 9 |
Object Browser Shortcuts
| Action | SQLyog Shortcut keys |
|---|
| Refresh Object Browser (Default) | F5 |
| Set Focus On Object Browser | Ctrl + B |
| Set Focus On Object Browser Filter | Ctrl + Shift + B |
| Collapse All in Object Browser | Shift + – |
SQL Window Shortcuts
| Action | SQLyog Shortcuts |
|---|
| New Query Editor | Ctrl + T |
| Rename Query Editor | Alt + F2 |
| Set Focus On SQL Window | Ctrl + E |
| Redo | Ctrl + Y |
| Undo | Ctrl + Z |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Replace | Ctrl + H |
| Go to | Ctrl + G |
| Open File In New Tab | Ctrl + O |
| Open File In Same Tab | Ctrl + Shift + O |
| Make Selection Uppercase | Ctrl + Shift + U |
| Make Selection Lowercase | Ctrl + Shift + L |
| Comment Selection In SQL Window | Ctrl + Shift + C |
| Remove Comment From Selection | Ctrl + Shift + R |
| Insert Templates | Ctrl + Shift + T |
| List All Tags | Ctrl + Enter |
| List Matching Tags | Ctrl + Spacebar |
Query Execution Shortcuts
| Action | SQLyog Shortcut keys |
|---|
| Execute Current Query And Edit Result | F8 |
| Execute Current Query (Default) | F9 |
| Execute Selected Query(s) (Default) | Ctrl + F9 |
SQL Formatter Shortcuts
| Action | SQLyog Shortcut keys |
|---|
| Format Current Query | F12 |
| Format Selected Query | Ctrl + F12 |
| Format All Queries | Shift + F12 |
SQL Statements Shortcuts
| Action | SQLyog Shortcut keys |
|---|
| Insert Statement | Alt + Shift + I |
| Update Statement | Alt + Shift + U |
| Delete Statement | Alt + Shift + D |
| Select Statement | Alt + Shift + S |
Result Shortcuts
| Action | SQLyog Shortcuts |
|---|
| Insert Update Dialog | F11 |
| Set Focus To The Active Tab In Result Pane | Ctrl + R |
| Switch Result Window/Table Data Between Grid/Text Mode or Form View/text | Ctrl + L |
| Switch Result Window/Table Data Between Grid and Form View | Ctrl + Alt + L |
| Export Table Data As CSV, Excel, SQL, etc. | Ctrl + Alt + C |
| Backup Data As SQL Dump | Ctrl + Alt + E |
| Import Data From CSV | Ctrl + Alt + M |
| Export Resultset | Ctrl + Alt + E |
| Select Tab In Result Window (1 to 8) | Alt + 1 to Alt + 8 |
| Select the Last Tab in the Result Window | Alt + 9 |
Show/Hide Shortcuts
| Action | SQLyog Shortcuts |
|---|
| Show/Hide Object Browser | Ctrl + Shift + 1 |
| Show/Hide Result Pane | Ctrl + Alt + 2 |
| Show/Hide Query Window | Ctrl + Alt + 3 |
Database/Table Shortcuts
| Action | SQLyog Shortcuts |
|---|
| Create Database | Ctrl + D |
| Alter Database/Table Structure/Index/View/Store Proc/Function/Trigger/Event | F6 |
| Rename Table/View/Trigger/Event | F2 |
| Truncate Database/Table | Shift + Delete |
| Manage Index Window | F7 |
| Relationships/Foreign Keys | F10 |
| Reorder Column(s) | Ctrl + Alt + R |
| Save Table | Alt + S |
| Revert Changes Made To Table Schema | Alt + R |
| Table Diagnostics | Ctrl + Shift + T |
| Flush Dialog | Ctrl + Shift + F |
| Create Schema For Database In HTML | Ctrl + Shift + Alt + S |
| Restore From SQL Dump | Ctrl + Shift + Q |
Other Shortcuts
| Action | SQLyog Shortcuts |
|---|
| Database Synchronization Tool | Ctrl + Alt + W |
| Schema Synchronization Tool | Ctrl + Q |
| Migration Toolkit | Ctrl + Alt + O |
| SQL Scheduler and Reporting Tool | Ctrl + Alt + N |
| Scheduled Backup Wizard | Ctrl + Alt + S |
| Query Builder | Ctrl + K |
| Schema Designer | Ctrl + Alt + D |
| Data Search | Ctrl + Shift + D |
| Info Tab | Ctrl + Shift + I |
| History Tab | Ctrl + Shift + H |
| Add A New User | Ctrl + U |
| Edit User | Ctrl + Alt + U |
| Manage Privileges | Ctrl + Alt + W |
| Add Current SQL To Favorites | Ctrl + Shift + F |
| Change Language | Alt + Shift + L |
| Help | F1 |
| Copy | Ctrl + C |
| Select All | Ctrl + A |
| Find (SQL Window/Result Window And Table Data In Text Mode/Blob Viewer) | Ctrl + F |
| Find Next (SQL Window/Result Window And Table Data In Text Mode) | F3 |
| Save | Ctrl + S |
| Switch To the Previous Tab | Ctrl + Page Up key |
| Switch To the Next Tab | Ctrl + Page Down key |
| Delete Selected | Delete |
| Refresh Table Data Tab | Alt + F5 |
| Close Tab | Alt + L |
| Exit | Alt + F4 |
READ NEXT:
