Connect Ctrl+m Create a new connection CTRL + N Create a new connection with the current connection properties 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 place focus on 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 go to ctrl+o Open file Ctrl+shift+u turn the selection into uppercase Ctrl+shift+l Change the selected part to lowercase ctrl+shift+c in the SQL window to the selected part of the callout ctrl+shift+r Delete the selected part of the comment ctrl+shift+t Insert template ctrl+space List all tags ctrl+enter list matching labels Ctrl + Shift+space list function and route parameter query execution F8 execute the current query and edit the results F9 execute the query (default) ctrl+f9 execute all queries (default) SQL format program F12 format the current query CTRL+F12 format 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 statement result F11 Insert Update window CTRL + R switches the focus to the current tab in the results panel ctrl+l Toggle Results Window/table data for data table/text mode CTRL+ALT+C export table data to Csv,excel,sql etc... Ctrl+alt+e BACKUP database for 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 tab 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 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 rearrange sequence ctrl+alt+T table Diagnostics ctrl+alt+f Output dialog box ctrl+shift+alt+s Create a database structure in HTML CTRL+SHIFT+Q Execute SQL Script Tool Ctrl+alt+wsqlyog Database Synchronization Wizard ctrl+alt+ Q Visual Data Control ctrl+q Schema Sync Tool ctrl+alt+osqlyog External Data Import Wizard ctrl+alt+n Notification Service Wizard ctrl+alt+s Schedule Backup Wizard ctrl+k Query creator 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 favorite Visual data Control ctrl+t Select a table ctrl+enter compare ctrl+h hide similar rows Ctrl + N Next Difference +p Previous difference ctrl+l source ctrl+r target ctrl+right Merge to destination ctrl+left merge to source Ctrl+q preview Sqlctrl+s implement change CTRL + Z Restore changes ctrl+shift+z restore selected changes other F1 help CTRL +shift+h Open history tab ctrl+shift+i Open info tab 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 ctrl+pgdown switch to next tab del Delete selected alt+shift+l change language alt+l close tab ALT+F4 exit
Shortcut keys for SQLyog