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:
