SQLyog keyboard shortcuts and sqlyog shortcuts

SQLyog keyboard shortcuts and sqlyog shortcuts

SQLyog keyboard shortcut

Connection
Ctrl + M create new connection
Ctrl + N create a new connection with the current connection Property
Ctrl + F4/Ctrl + W disconnect the current connection
Ctrl + Tab switch to the next connection
Ctrl + Shift + Tab switch to the 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 switch focus to Object Browser
Ctrl + Shift + B focus on the Object Browser Filter


SQL window
Ctrl + T New query window
Ctrl + E switch focus to SQL window
Ctrl + Y redo
Ctrl + Z undo
Ctrl + X cut
Ctrl + V Paste
Ctrl + H replace
Ctrl + G
Ctrl + O open the file
Ctrl + Shift + U convert the selected part to uppercase
Ctrl + Shift + L convert the selected part to lowercase
Ctrl + Shift + C mark the selected part in the SQL window
Ctrl + Shift + R delete comments of the selected part
Ctrl + Shift + T insert Template
Ctrl + Space to list all tags
Ctrl + Enter to list matching tags
Ctrl + Shift + Space list function and route Parameters


Query execution
F8 execute the current query and edit the result
F9 queries (default)
Ctrl + F9 execute all queries (default)


SQL format Program
F12 format the current query
Ctrl + F12 format the 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 query statement


Result
F11 insert update window
Ctrl + R switch the focus to the current tab in the result panel
Ctrl + L switch result window/table data to data table/text mode
Ctrl + Alt + C export table data to CSV, Excel, SQL, etc...
Ctrl + Alt + E back up the database as an SQL dump
Ctrl + Shift + M import data from CSV
Ctrl + Shift + E export result set
Ctrl + Space open the foreign key search
Alt + 1... 8 select the tab (1 to 8) in the result window)
Alt + 9 select the last tab in the result window


Show/hide
Ctrl + Shift + 1 show/hide Object Browser
Ctrl + Shift + 2 display/hide result panel
Ctrl + Shift + 3 display/hide the query window


Database/table
Ctrl + D create database
F6 modify Database/table structure/index/View/stored procedure/function/trigger/event
F2 rename table/View/trigger/event
Shift + Del truncate database/table
F7 manage index window
F10 relationship/foreign key
Ctrl + Alt + R re-Sort Columns
Ctrl + Alt + T table Diagnosis
Ctrl + Alt + F output dialog box
Ctrl + Shift + Alt + S create database structure in HTML Format
Ctrl + Shift + Q run the SQL script


Tools
Ctrl + Alt + W SQLyog Database Synchronization Wizard
Ctrl + Alt + Q visual data comparison
Ctrl + Q architecture synchronization Tool
Ctrl + Alt + O SQLyog external data import wizard
Ctrl + Alt + N Notification Service wizard
Ctrl + Alt + S scheduled backup wizard
Ctrl + K query creator
Ctrl + Alt + D Architecture designer
Ctrl + Shift + D data search


User Management
Ctrl + U open User Manager


Bookmarks
Ctrl + Shift + F add current SQL to favorites


Visual data comparison
Ctrl + T select a table
Ctrl + Enter comparison
Ctrl + H hide similar rows
Ctrl + N next difference
Ctrl + P previous difference
Ctrl + L Source
Ctrl + R target
Ctrl + Right merge to target
Ctrl + Left merge to source
Ctrl + Q preview SQL
Ctrl + S implement changes
Ctrl + Z restore changes
Ctrl + Shift + Z restore selected changes


Others
F1 help
Ctrl + Shift + H open the history tag
Ctrl + Shift + I open the information Tab
Ctrl + C copy
Ctrl + A select all
Ctrl + F search (SQL window/result window and text mode table data/Blob viewer)
F3 find the next one (SQL window/result window and text mode table data/Blob viewer)
Ctrl + S save
Ctrl + PgUp switch to the previous Tab
Ctrl + PgDown switch to the next tab
DEL Delete selected part
Alt + Shift + L change language
Alt + L close the tab
Alt + F4 exit