Executing Queries

You execute all your SQL commands in the SQL window. To help you out with SQL syntax, SQLyog provides templates for all the SQL supported by MySQL. You can get to the template window by selecting Edit -> Insert Templates (Ctrl+T).

There are three methods of executing queries in SQLyog -- Execute Current Query (F5), Execute All Query(s) (Shift+F5) and Execute Selected Query (Ctrl+F5). If you have written multiple queries and want to execute a particular query, then place your cursor in the respective query and press F5.

When you execute a query that returns a resultset, a new Result tab is inserted in the Result window. If you have executed multiple queries that produce multiple resultset(s), then you will have multiple Result tabs in the window, with the resultset of the respective query attached to it. If you double click on a BLOB column, SQLyog would try to parse the BLOB data to find out whether it is a valid text/image file and then display the contents in a modeless dialog. All popular file formats like (GIF/JPEG/PNG) are supported.


Toggle between GRID/TEXT modes to view results by selecting Edit -> Show Results In Text (Ctrl+L). While in grid mode you can click on the header to sort the results on that column. This sorting is done on the client side without sending any query to the MySQL Server. You can also apply simple filters on the result set by selecting the Filter option in the right-click context menu.


Viewing result sets in text mode is very helpful if you want to cut and paste plain text into another application. While viewing a result set in text mode, you can also search for a particular string in the result set by selecting Edit -> Search from the menu.

Page 3: Exporting Resultset in XML, HTML, CSV Formats