SQLyog shortcut keys
CTRL+M Create a new connection
CTRL + N Use current settings to create a new connection
CTRL+F4 disconnecting the current connection
Object Browser
F5 refreshing the Object Browser (default)
Ctrl+b setting focus on Object Browser
SQL window
ctrl+t new Query Editor
ctrl+e setting focus on SQL window
Ctrl+y Redo
Ctrl + Z undo
Ctrl+x Cut
Ctrl + V paste
Ctrl+h Replacement
ctrl+g go to
ctrl+o opening a SQL document in the SQL window
ctrl+shift+u make selection uppercase
ctrl+shift+l make selection lowercase
ctrl+shift+c Comment SQL window select content
Ctrl+shift+r Remove comments from selection
ctrl+shift+t inserting a template
ctrl+enter List all the labels
ctrl+space List of matching tags
Execute Query
F8 executing the current query and editing the result set
F9 executing the current query (default)
CTRL+F9 Execute selected query (default)
SHIFT+F9 Execute all queries (default)
Paste SQL Statement
Alt+shift+i INSERT statement
ALT+SHIFT+U UPDATE statement
ALT+SHIFT+D DELETE statement
Alt+shift+s SELECT statement
Results
F11 Insert Update dialog box
Ctrl+r set focus on the active tab in the results panel
ctrl+l Switch Results window/table data is displayed in table/text mode
ctrl+alt+c Export table data in CSV, SQL, Excel, etc.
ctrl+alt+e backing up data with a SQL dump file
ctrl+shift+m importing data from CSV
ctrl+shift+e Exporting result sets
ALT+1...N Select the nth label in the results window
Show/Hide
Ctrl+1 Show/Hide Object Browser
Ctrl+2 Show/Hide Results panel
Ctrl+3 Show/Hide Query window
database/Data Tables
ctrl+d Creating a database
F6 Change database/data table structure/index/view/stored procedures/functions/triggers/Events
F2 Renaming data tables/views/triggers/events
Shift+del truncate database/data table
F7 Managing the Index window
F10 Association/FOREIGN Key
ctrl+alt+r Reorder Fields
ctrl+alt+t Data Sheet Diagnostics
ctrl+alt+f Refresh dialog box
Ctrl+shift+alt+s Creating a database schema in HTML format
ctrl+shift+q recovering the database from a SQL dump file
enhanced tool
ctrl+w Database Synchronization Wizard
ctrl+q schema Sync tool
ctrl+alt+o Data Migration Kit
ctrl+alt+n Notification Service Wizard
ctrl+alt+s schedule backup
ctrl+k query builder
ctrl+alt+d schema designer
User Management
Ctrl+u adding users
Ctrl+alt+u Editing users
Ctrl+shift+w Managing User Rights
Personal Folders
Ctrl+shift+f Add current SQL statement to personal Folder
other
F1 Help
F12 shortcut key window
Ctrl + C copy
Ctrl + A Select all
ctrl+f/f3 Find (SQL window/Result window and table data displayed in text)
Ctrl+s Save
Ctrl+pgup Switch to previous tab
ctrl+pgdown switch to next tab
DEL Delete selected
alt+l Closing Labels
ALT+F4 Exit Program
? SQLyog shortcut keys