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: