Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 18, 2002

Introducing SQLyog, a MySQL Front End - Page 2

By DatabaseJournal.com Staff

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM