SQLyog: SQLyog is a Graphical User Interface tool for MySQL development and administration solutions. MySQL is the most popular open-source database engine. But it cannot administrate the text. Furthermore, simple operations can also be accomplished by using the many pre-defined tools and functions while using the GUI. Even though the MySQL engine is very powerful and flexible, it can manage the text interface for beginners. So we have prepared for SQLyog, which is easy to use. SQLyog is developed by Webyog.
SQLyog removes all the barriers to making the functions available through a friendly interface. It can handle all the databases, and it can use in SSH and HTTP tunneling to make remote access.
In this article, you will learn about Useful Shortcuts for SQLyog. Use these shortcuts to manage a significant amount of your time. Let’s get into this article.
Last Updated on Jan11, 2022.
SQLyog Hotkeys – Keyboard Shortcuts:
| Shortcuts | Functions |
|---|---|
| F5 | If you want to execute the current query, use this key. |
| F8 | To execute the update, you can use this key. |
| F1 | If you need any help, you can use this key. |
| F3 | Use this key to go to the Keyboard Shortcuts Window. |
| F7 | Press this key to manage the index window. |
| F9 | By pressing this key, you can refresh the screen. |
| F10 | Use this key to manage foreign relationships. |
| F11 | Make use of this key to update the dialog. |
| Ctrl+1 | This key is used to show/hide the object browser. |
| Ctrl+ | Helps to Show/hide the result page. |
| Ctrl+3 | If you want to show/hide the query window, use this key. |
| Ctrl+D | Make use of this key to create a database. |
| Ctrl+E | It is used to Set focus on SQL Window. |
| Ctrl+F | In order to find the text, you can use this shortcut. |
| Ctrl+L | To toggle results in text/grid mode, use this key. |
| Ctrl+m | Make use of this key to create a new connection. |
| Ctrl+N | Used to Create a new connection with current connection properties. |
| Ctrl+O | Helps to open a SQL document in SQL Window. |
| Ctrl+R | Make use of this key to set focus results on the window. |
| Ctrl+S | This key is used to save the current SQL document. |
| Ctrl+EU | If you want to add a new user, use this key. |
| Ctrl+V | By using this shortcut, you can Paste data into the SQL window. |
| Ctrl+Q | For the database synchronization tool, use this key. |
| Ctrl+F5 | To execute the selected queries, use this key. |
| Shift+F5 | With the help of this shortcut, you can execute all queries. |
| Shift+Del | Use this key to empty a table or empty a database. |
Keyboard Shortcuts for SQLyog:
| Shortcuts | Functions |
|---|---|
| Ctrl+Alt+O | To import the ODBC wizard, use this key. |
| Ctrl+Alt+C | Export table data as CSV, use this key. |
| Ctrl+Alt+X | Make use of this key to export table data as XML, use this key. |
| Ctrl+Alt+H | To export the table as HTML, use this key. |
| Ctrl+Alt+E | It is to export data as batch scripts. |
| Ctrl+Alt+R | This key is used to reorder the columns. |
| Ctrl+Alt+T | Use this key to table diagnostics. |
| Ctrl+Alt+U | Used to edit the user permissions. |
| Ctrl+Alt+F | If you want to flush the dialog, use this key. |
| Ctrl+Alt+S | This key is used to schedule backup. |
| Ctrl+Shift+C | Make use of this key to comment selection in the SQL window. |
| Ctrl+Shift+E | If you want to export the result set, use this key. |
| Ctrl+Shift+F | Use this key to add current SQL to the personal folder. |
| Ctrl+Shift+L | To make the selection in lowercase, use this shortcut. |
| Ctrl+Shift+P | In order to activate the personal folder menu, you can use this shortcut. |
| Ctrl+Shift+R | To remove the comment from the selection menu, use this key. |
| Ctrl+Shift+S | Use this key to open a Create Schema dialog. |
| Ctrl+Shift+T | This key is used to open the Insert Template Dialog. |
| Ctrl+Shift+U | By using this shortcut, you can make the selection in uppercase. |
| Ctrl+Shift+M | In order to Import CSV data to the table, use this key. |
| Ctrl+Shift+Q | Make use of this key to execute a SQL batch file. |
| Ctrl+Shift+W | Use this key to open the Manage User dialog box. |
Verdict:
You can use these shortcuts for both Windows 10 and Windows 11. Make sure to use these shortcuts properly.
From this article, you will learn about “Useful Shortcuts for SQLyog”. If you have any questions or feedback regarding this article, please share them in the comment section. Thank you!. Have a nice day!!