========================= SQLyog keyboard shortcuts ========================= First published at 6/5/2019 on https://defkey.com/sqlyog-shortcuts SQLyog is a MySQL GUI developed by Webyog. It has features such as intelligent code completion, data manipulations on a spreadsheet-like interface, visual schema designer and visual query builder. SQLyog is provided as a try-before-buy software. SQLyog has 93 shortcuts and we have listed all of them below. Connection ---------- Ctrl + M Create A New Connection Ctrl + N Create A New Connection With Current Connection Properties Ctrl + F4 Disconnect The Current Connection Ctrl + W Disconnect The Current Connection Ctrl + Tab Switch to Next Connection Ctrl + Shift + Tab Switch to Previous Connection Ctrl + 1 … to Ctrl + 8: Select Connection (1 to 8) Ctrl + 9 Select Last Connection Object Browser -------------- F5 Refresh Object Browser (Default) Ctrl + B Set Focus On Object Browser Ctrl + Shift + B Set Focus On Object Browser Filter Shift + - Collapse All in Object Browser SQL Window ---------- Ctrl + T New Query Editor Alt + F2 Rename Query Editor Ctrl + E Set Focus On SQL Window Ctrl + Y Redo Ctrl + Z Undo Ctrl + X Cut Ctrl + V Paste Ctrl + H Replace Ctrl + G Go to Ctrl + O Open File In New Tab Ctrl + Shift + O Open File In Same Tab Ctrl + Shift + U Make Selection Uppercase Ctrl + Shift + L Make Selection Lowercase Ctrl + Shift + C Comment Selection In SQL Window Ctrl + Shift + R Remove Comment From Selection Ctrl + Shift + T Insert Templates Ctrl + Enter List All Tags Ctrl + Space List Matching Tags Query Execution --------------- F8 Execute Current Query And Edit Result F9 Execute Current Query (Default) Ctrl + F9 Execute Selected Query(s) (Default) SQL Formatter ------------- F12 Format Current Query Ctrl + F12 Format Selected Query Shift + F12 Format All Queries Paste SQL Statements -------------------- Alt + Shift + I Insert Statement Alt + Shift + U Update Statement Alt + Shift + D Delete Statement Alt + Shift + S Select Statement Result ------ F11 Insert Update Dialog Ctrl + R Set Focus To The Active Tab In Result Pane Ctrl + L Switch Result Window/Table Data Between Grid/Text Mode or Form View/text Ctrl + Alt + L Switch Result Window/Table Data Between Grid and Form View Ctrl + Alt + C Export Table Data As CSV, Excel, SQL etc... Ctrl + Alt + E Backup Data As SQL Dump Ctrl + Shift + M Import Data From CSV Ctrl + Shift + E Export Resultset Alt + 1 …to Alt + 8: Select Tab In Result Window (1 to 8) Alt + 9 Select Last Tab in the Result Window Show/Hide --------- Ctrl + Shift + 1 Show/Hide Object Browser Ctrl + Shift + 2 Show/Hide Result Pane Ctrl + Shift + 3 Show/Hide Query Window Database/Table -------------- Ctrl + D Create Database F6 Alter Database/Table Structure/Index/View/Store Proc/Function/Trigger/Event F2 Rename Table/View/Trigger/Event Shift + Del Truncate Database/Table F7 Manage Index Window F10 Relationships/Foreign Keys Ctrl + Alt + R Reorder Column(s) Alt + S Save Table Alt + R Revert Changes Made To Table Schema Ctrl + Alt + T Table Diagnostics Ctrl + Alt + F Flush Dialog Ctrl + Shift + Alt + S Create Schema For Database In HTML Ctrl + Shift + Q Restore From SQL Dump PowerTools ---------- Ctrl + Alt + W Database Synchronization Tool Ctrl + Q Schema Synchronization Tool Ctrl + Alt + O Migration Toolkit Ctrl + Alt + N SQL Scheduler and Reporting Tool Ctrl + Alt + S Scheduled Backup Wizard Other Tabs ---------- Ctrl + K Query Builder Ctrl + Alt + D Schema Designer Ctrl + Shift + D Data Search Ctrl + Shift + I Info Tab Ctrl + Shift + H History Tab User Manager ------------ Ctrl + U Add A New User Ctrl + Alt + U Edit User Ctrl + Shift + W Manage Privileges Favorites --------- Ctrl + Shift + F Add Current SQL To Favorites Language -------- Alt + Shift + L Change Language Other ----- F1 Help Ctrl + C Copy Ctrl + A Select All Ctrl + F Find (SQL Window/Result Window And Table Data In Text Mode/Blob Viewer) F3 Find Next (SQL Window/Result Window And Table Data In Text Mode) Ctrl + S Save Ctrl + Page Up Switch To Previous Tab Ctrl + Page Down Switch To Next Tab Del Delete Selected Alt + F5 Refresh Table Data Tab Alt + L Close Tab Alt + F4 Exit Source Last modified on(UTC): Monday, November 11, 2019 Defkey © All rights reserved.