SQLyog keyboard shortcuts

SQLyog keyboard shortcuts

Connection
Ctrl+m Create a new connection
CTRL + N Create a new connection with the current connection properties
Ctrl+f4/ctrl+w Disconnect Current Connection
Ctrl+tab Switch to the next connection
Ctrl+shift+tab Switch to previous connection
ctrl+1...8 Select Connection (1 to 8)
Ctrl+9 Select the last connection


Object Browser
F5 Refresh Object Browser (default)
Ctrl+b Toggle focus to Object Browser
Ctrl+shift+b Place focus on the Object Browser filter


SQL window
Ctrl+t New Query window
Ctrl+e Toggle focus to SQL window
Ctrl+y Redo
CTRL + Z Revoke
Ctrl+x Shear
CTRL + V Paste
Ctrl+h Replace
Ctrl+g Go to
Ctrl+o Open File
Ctrl+shift+u Capitalize the selected part
Ctrl+shift+l Turn selected parts to lowercase
Ctrl+shift+c In the SQL window, highlight the selected part
Ctrl+shift+r Remove Comments from selected sections
Ctrl+shift+t Insert Template
Ctrl+space List all tags
Ctrl+enter List matching Labels
Ctrl+shift+space List functions and route parameters


Query execution
F8 Execute the current query and edit the results
F9 Execute Query (default)
Ctrl+f9 Execute all queries (default)


SQL Format Program
F12 Formatting the current query
Ctrl+f12 Formatting the selected query
Shift+f12 Formatting all queries


Paste SQL statement
Alt+shift+i Insert statement
Alt+shift+u UPDATE statement
Alt+shift+d Delete statement
Alt+shift+s Query statements


Results
F11 Insert Update window
Ctrl+r Switch focus to the current tab in the results panel
Ctrl+l Toggle Results window/table data to data table/text mode
Ctrl+alt+c Export table data to Csv,excel,sql, etc...
Ctrl+alt+e Backing up a database for a SQL dump
Ctrl+shift+m Import data from CSV
Ctrl+shift+e Export result set
Ctrl+space Open FOREIGN Key Lookup
alt+1...8 Select the tabs in the Results window (1 to 8)
Alt+9 Select the last tab in the results window


Show/Hide
Ctrl+shift+1 Show/Hide Object Browser
Ctrl+shift+2 Show/Hide Results panel
Ctrl+shift+3 Show/Hide Query window


Database/Table
Ctrl+d Create a database
F6 Modify database/table structure/indexes/views/stored Procedures/functions/triggers/Events
F2 Renaming tables/views/triggers/Events
Shift+del Truncate database/table
F7 Manage Index windows
F10 Relationships/foreign keys
Ctrl+alt+r Rearrange sequences
Ctrl+alt+t Table Diagnostics
Ctrl+alt+f Output dialog box
Ctrl+shift+alt+s Create a database structure in HTML form
Ctrl+shift+q Execute SQL Script


Tools
Ctrl+alt+w SQLyog Database Synchronization Wizard
Ctrl+alt+q Visual Data Control
Ctrl+q Schema Synchronization Tool
Ctrl+alt+o SQLyog External Data Import Wizard
Ctrl+alt+n Notification Service Wizard
Ctrl+alt+s Schedule Backup Wizard
Ctrl+k Query Builder
Ctrl+alt+d Schema Designer
Ctrl+shift+d Data Lookup


User Management
Ctrl+u Open User Manager


Bookmark
Ctrl+shift+f Add current SQL to Favorites


Visual Data Control
Ctrl+t Select a table
Ctrl+enter Comparison
Ctrl+h Hide a similar row
CTRL + N Next difference
Ctrl+p A difference in the last place
Ctrl+l Source
Ctrl+r Goal
Ctrl+right Merge to Target
Ctrl+left Merge to Source
Ctrl+q previewing SQL
Ctrl+s Implementing changes
CTRL + Z Revert changes
Ctrl+shift+z Restore the selected changes


Other
F1 Help
Ctrl+shift+h Open history tab
Ctrl+shift+i Open Information tab page
CTRL + C Copy
CTRL + A Select All
Ctrl+f Find (SQL Window/Results window and text mode table Data/blob Viewer)
F3 Find Next (SQL Window/Results window and text mode table Data/blob Viewer)
Ctrl+s Save
Ctrl+pgup Switch to previous tab page
Ctrl+pgdown Switch to the next tab page
Del Delete selected parts
Alt+shift+l Change language
Alt+l Close tabs
Alt+f4 Exit

SQLyog keyboard shortcuts