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
» 
Comment and Contribute
