In the editor you may find the parenthesis/bracket matching one another by simply positioning the cursor after a bracket. The actual bracket and its match will be highlighted. Note that…
SQLyog has an ability to format the SQL displayed in the active QUERY tab. You may format a single query only or the complete content of a QUERY tab. Formatting…
The purpose of the autocomplete feature of SQLyog is to make it ease to type any type of database object (tables, columns etc.) names, and the names of MySQL keywords…
In SQLyog, you get ready templates for all the SQL statements supported by MySQL. Select Edit -> Insert Templates (or press Ctrl+Shift+T). Now select the SQL statement to insert the template and click Insert button. The template…
The relationship between the QUERY Tabs and the different Tab views in the – lower – DATA area is basically a parent-child relationship. For every QUERY tab there can be…
With SQLyog you can enjoy a great feature of multiple editor tabs in the SQL window. You can open several files at the same time and logically separate your queries…
Making a New Connection After you start SQLyog, you have to enter the details of MySQL server you want to connect to. You must connect to a MySQL server before…
Select Edit -> Hide SQL Editor (or press Ctrl+Shift+3) to toggle Show/Hide SQL Editor Window. However, at least one of the window (SQL Editor, Result Set, Object Browser) will be visible (you cannot…
For ease of use, components of an SQL query are shown in different colors. There are certain SQLyog defaults, but you can setup your own highlight fonts and color scheme…
